Want to display display columns horizontally in Stimulsoft report
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Want to display display columns horizontally in Stimulsoft report
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
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
-
- Posts: 6198
- Joined: Tue Mar 20, 2018 5:34 am
Re: Want to display display columns horizontally in Stimulsoft report
Hello,
In that case, you can use the Cross-Data component.
Thank you.
In that case, you can use the Cross-Data component.
Thank you.
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
HiLech Kulikowski wrote: ↑Wed May 13, 2020 1:40 pm Hello,
In that case, you can use the Cross-Data component.
Thank you.
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
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
Is there no solution available in stimulsoft 2013.1 version for the issue I have raised
-
- Posts: 6198
- Joined: Tue Mar 20, 2018 5:34 am
Re: Want to display display columns horizontally in Stimulsoft report
Hello,
You can add an additional column for grouping.
Thank you.
You can add an additional column for grouping.
Thank you.
- Attachments
-
- Annotation 2020-05-18 215146.png (134.78 KiB) Viewed 2637 times
-
- Report.mrt
- (21.69 KiB) Downloaded 177 times
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
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
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 (61.38 KiB) Viewed 2607 times
-
- Designer Image.png (401.73 KiB) Viewed 2608 times
-
- AssessmentReportDesigner.png (61.38 KiB) Viewed 2608 times
-
- AssessmentReport.mrt
- (835.55 KiB) Downloaded 131 times
-
- AssessmentReportDesigner.png (61.38 KiB) Viewed 2610 times
-
- Designer Image.png (401.73 KiB) Viewed 2612 times
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
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.
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.
-
- Posts: 6198
- Joined: Tue Mar 20, 2018 5:34 am
Re: Want to display display columns horizontally in Stimulsoft report
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.
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.
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
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
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 (86.13 KiB) Viewed 2580 times
-
- ResultData.xlsx
- (11.2 KiB) Downloaded 138 times
Re: Want to display display columns horizontally in Stimulsoft report
Thank you for this updates.Great Job