riodavid

What is your current table layout? Can you paste a screenshot as well? (Just like the correct table you posted)

Strange I can't reproduce your issue. I didn't set the property, the docx file looks fine. What Jasper server or studio version do you use?

Is it working dude?

Sorry, can you paste a screenshot to demonstrate your idea?

Try creating data source on portal to see if it works. https://ibb.co/iowd59

Sample data: create table test_qa( question varchar(100) , answer varchar(3) , family varchar(10) ) insert into test_qa values('Have you or anyone in your household had diagnosed with high blood pressure?','No','Family-1') insert into test_qa values('Have you or anyone in your household had diagnosed with high blood pressure?','Yes','Family-2') insert into test_qa values('Have you or anyone in your household had diagnosed with high blood pressure?','No','Family-3') insert into test_qa values('Have you or anyone in your household had diagnosed with diabetes?','No','Family-1') insert into test_qa values('Have you or anyone in your household had diagnosed with diabetes?','No','Family-2') insert into test_qa values('Have you or anyone in your household had diagnosed with diabetes?','No','Family-3') insert into test_qa values('Have you or anyone in your household had diagnosed with heart disease?','No','Family-1') insert into test_qa values('Have you or anyone in your household had diagnosed with heart disease?','No','Family-2') insert into test_qa values('Have you or anyone in your household had diagnosed with heart disease?','No','Family-3')

https://ibb.co/i69yoU Not sure if it is what you want. If it is I will share the jrxml file for your reference.

I'm not sure if it's a good idea to use subreport in this case. But if you can join the question and anwser result sets together, it wil be very easy to display them in a crosstab.

Use $V{REPORT_COUNT} And remember to set the "Reset Type" to "Report"

Hi Jahn, can you post a scratch screenshot?

Hi Mauro, I can reproduce your issue. I tried and fixed it by: 1. Save the .jrxml file 2. Close it 3. Open it again Hope it helps.

I see your problem. Yes it's confusing. I hope some Tibco guys can see this and make the change.

Hi Pierrehakan, I noticed that your picture was uploaded to this forum server, how did you do that? Every time I want to upload a picture I have to find a third party website. This is what I did. I'm not sure if it satisfies your needs:

Zonglin you are a genius.

Don't know why. Can you give it a back color as well and see what happens?

I met some problems when reading fields too. Restart your studio and try again.

"V" is the name of your stored procedure, or other Oracle sub programs. Have you created something like that? And the message tells you the arguments passed to "V" is not correct. Check your stored procedure.

Sorry, as I said, this is the closest solution I know. As well as a Tibco consultant suggested.

Seems you can't edit the default type detection mechanism. If you have lots of fields, edit them in bulk in the jrxml file.

I don't think it's possible to implement the exact layout you did. Once I asked a Tibco consultant he did not know it too. The closest possible layout is like this: https://postimg.cc/image/ow4d47jkx/ Of course, you can remove the borders in each group to make it look better. To implement this, first sort your data on the grouping column (I did this in Dataset and Query -> Sorting) then check Textfield property -> Print Repeated Values -> Uncheck

Hello folks, Usually when I design a report, I will put a Table element in a group footer. But I realized that someone don't use the Table element. Instead, they collocate cells in the detail band to make a table. Which way do you prefer? Any cons or pros from these 2 ways? Thank you D

9 years has past, the issue is still there.

It can be easily achieved by a Crosstab element.

Hi Hozawa, thanks for replying. But it looks like the date format configuration in jasperreports_messages.properties is for reports. Please check my screenshot, it's the portal date that have the wrong format.