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 »

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: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by Lech Kulikowski »

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 »

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 150 times
Stimulsoft Issue.docx
(109.8 KiB) Downloaded 150 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 »

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

Re: Want to display display columns horizontally in Stimulsoft report

Post by Lech Kulikowski »

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 2637 times
Report.mrt
(21.69 KiB) Downloaded 177 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 »

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 216 times
AssessmentReportDesigner.png
AssessmentReportDesigner.png (61.38 KiB) Viewed 2607 times
Designer Image.png
Designer Image.png (401.73 KiB) Viewed 2608 times
AssessmentReportDesigner.png
AssessmentReportDesigner.png (61.38 KiB) Viewed 2608 times
AssessmentReport.mrt
(835.55 KiB) Downloaded 131 times
AssessmentReportDesigner.png
AssessmentReportDesigner.png (61.38 KiB) Viewed 2610 times
Designer Image.png
Designer Image.png (401.73 KiB) Viewed 2612 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 »

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: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Want to display display columns horizontally in Stimulsoft report

Post by Lech Kulikowski »

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 »

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 2580 times
ResultData.xlsx
(11.2 KiB) Downloaded 138 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 »

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