Want to display display columns horizontally in Stimulsoft report

Stimulsoft Reports.Net discussion
anshulmehta
Posts: 12
Joined: Tue May 12, 2020 10:56 am

Want to display display columns horizontally in Stimulsoft report

Post by anshulmehta » Wed May 13, 2020 3:39 am

Hi Team

I have a record set which has 2 columns "Questions" and "Answer".

I want to display the values in these columns horizontally in a table ,we are using stimulsoft 2013.

I did create a databand and inserted a text within it and then updated Databand to have 10 columns .

It does work but looks messy ,please help me
Lech Kulikowski
Posts: 2575
Joined: Tue Mar 20, 2018 5:34 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by Lech Kulikowski » Wed May 13, 2020 1:40 pm

Hello,

In that case, you can use the Cross-Data component.

Thank you.
anshulmehta
Posts: 12
Joined: Tue May 12, 2020 10:56 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by anshulmehta » Fri May 15, 2020 1:23 am

Lech Kulikowski wrote:
Wed May 13, 2020 1:40 pm
Hello,

In that case, you can use the Cross-Data component.

Thank you.
Hi

I tried using the cross band but was not able to create the one as desired.

I am trying to create a pivot query so that I can convert my columns to rows but can not display the pivoted columns .

I am attaching the screenshot of what I desire and also the result set.

I can share the mrt file as well if required.

Kindly help me new in using stimulsoft.
Attachments
ResultSet.xlsx
(9.41 KiB) Downloaded 14 times
Stimulsoft Issue.docx
(109.8 KiB) Downloaded 11 times
anshulmehta
Posts: 12
Joined: Tue May 12, 2020 10:56 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by anshulmehta » Sun May 17, 2020 11:26 pm

Is there no solution available in stimulsoft 2013.1 version for the issue I have raised
Lech Kulikowski
Posts: 2575
Joined: Tue Mar 20, 2018 5:34 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by Lech Kulikowski » Mon May 18, 2020 7:52 pm

Hello,

You can add an additional column for grouping.

Thank you.
Attachments
Annotation 2020-05-18 215146.png
Annotation 2020-05-18 215146.png (134.78 KiB) Viewed 300 times
Report.mrt
(21.69 KiB) Downloaded 16 times
anshulmehta
Posts: 12
Joined: Tue May 12, 2020 10:56 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by anshulmehta » Tue May 19, 2020 4:14 am

Hi Lech

Thanks for the reply.

I am confused here.

I am not able to understand what is DataSource1 in the mrt file you have provided.
I have attached screenshot.
We have QuestionnaireHeader which contains columns Header and DisplayOrder and this is used to display the colums header.
and we have QuestionnaireSubforms which has Header,Answer,DisplayOrder,RenderAsTable,SubFormTable. which has the data.


SubFormTable is basically the "id " you have referenced.

I am attaching the reference mrt sheet also.Kindy have a look
Attachments
AssessmentReport.mrt
(835.55 KiB) Downloaded 10 times
AssessmentReportDesigner.png
AssessmentReportDesigner.png (61.38 KiB) Viewed 270 times
Designer Image.png
Designer Image.png (401.73 KiB) Viewed 271 times
AssessmentReportDesigner.png
AssessmentReportDesigner.png (61.38 KiB) Viewed 271 times
AssessmentReport.mrt
(835.55 KiB) Downloaded 9 times
AssessmentReportDesigner.png
AssessmentReportDesigner.png (61.38 KiB) Viewed 273 times
Designer Image.png
Designer Image.png (401.73 KiB) Viewed 275 times
anshulmehta
Posts: 12
Joined: Tue May 12, 2020 10:56 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by anshulmehta » Tue May 19, 2020 7:38 am

Hello

Also this is the query I am using to fetch Header

SELECT distinct Question,DisplayOrder
FROM table1
WHERE HeaderId = 66332
AND Ignore = 0
AND Visible = 1
AND RenderAsTable = 1
order by DisplayOrder

This is query I am fetching to get the answers

SELECT Question,
ISNULL(ModifiedAnswer, Answer) AS Answer,
RenderAsTable,
DisplayOrder,
SubFormTable
FROM table1
WHERE HeaderId = 66332
AND Ignore = 0
AND Visible = 1
AND RenderAsTable = 1

I am using the header result set to display in the Header band and using answer result set to display in the cross data band below.

Please suggest where I am missing the link between the two.
Lech Kulikowski
Posts: 2575
Joined: Tue Mar 20, 2018 5:34 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by Lech Kulikowski » Tue May 19, 2020 2:00 pm

Hello,

Please check the sample from previous post gain.
On the DataBand is used grouped data source by id (DataSource1) - which contains only grouped id - in test data it is 1 and 2
And the main data source with Question and Answer data are placed as Cross-Data on that databand.

Thank you.
anshulmehta
Posts: 12
Joined: Tue May 12, 2020 10:56 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by anshulmehta » Wed May 20, 2020 1:16 am

Hi Lech

Thanks for the reply ,I was able to achieve the desired result .

But the only concern I have now is if in one subformTable I mark one question as "Invisible" and in other I do not ,data is not displayed correctly.

I am attaching the sample data for reference and the sample image as well for reference and also the columns border are empty for blank values

How can I resolve this ?

Regards
Attachments
Report Image.png
Report Image.png (86.13 KiB) Viewed 243 times
ResultData.xlsx
(11.2 KiB) Downloaded 8 times
priyateke
Posts: 1
Joined: Wed May 20, 2020 6:44 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by priyateke » Wed May 20, 2020 6:48 am

Thank you for this updates.Great Job :)
Post Reply