Want to display display columns horizontally in Stimulsoft report
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
Hi Lech
There is also one more issue.
If suppose user marks the Room column whose value is Basement as invisible then data shifts one cell left even though header remains static.
So what happens is basically header remains static but values in the rows shift .
Please see attaches screenshot.
There is also one more issue.
If suppose user marks the Room column whose value is Basement as invisible then data shifts one cell left even though header remains static.
So what happens is basically header remains static but values in the rows shift .
Please see attaches screenshot.
- Attachments
-
- Data shifted one colun left.png (25.38 KiB) Viewed 1806 times
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
Hi lech
Is this possible using the stimulsoft report ?
Is this possible using the stimulsoft report ?
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Want to display display columns horizontally in Stimulsoft report
Hello,
Yes, it is possible. You can group as additional data source all Display values and show it all 16 records in a row and show Question/Answer by that data source via filtering.
Thank you.
Yes, it is possible. You can group as additional data source all Display values and show it all 16 records in a row and show Question/Answer by that data source via filtering.
Thank you.
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
Hi Lech
I am very new to the stimulsoft ,little confused.What do you mean by show all 16 records in a row ?
do you mean pivot the answers ?
Will there be 3 different data sources ?
One which will have all the questions and answers and used to display Questions and Answers
SELECT Question, ISNULL(ModifiedAnswer, Answer) AS Answer,
RenderAsTable,DisplayOrder,SubFormTable
FROM JobFormQuestionnaireDetails
WHERE HeaderId = {QuestionnaireID}
and Ignore = 0
AND Visible = 1
AND RenderAsTable = 1
2nd Data Source which has distinct ids which is used as a relation between 1st and 2nd datasource
and 3rd new one which will only have questions and answers grouped by id
SELECT Question, ISNULL(ModifiedAnswer, Answer) AS Answer,id
FROM JobFormQuestionnaireDetails
WHERE HeaderId = 66340
and Ignore = 0
AND Visible = 1
AND RenderAsTable = 1
group by Question, ISNULL(ModifiedAnswer, Answer),id
Now we will use filter condition on data source 1 to meet the following conditions
data source1 Question = datasource 3 question
data source 1 id = data source 3 id
Am I thinking correctly ?
I am very new to the stimulsoft ,little confused.What do you mean by show all 16 records in a row ?
do you mean pivot the answers ?
Will there be 3 different data sources ?
One which will have all the questions and answers and used to display Questions and Answers
SELECT Question, ISNULL(ModifiedAnswer, Answer) AS Answer,
RenderAsTable,DisplayOrder,SubFormTable
FROM JobFormQuestionnaireDetails
WHERE HeaderId = {QuestionnaireID}
and Ignore = 0
AND Visible = 1
AND RenderAsTable = 1
2nd Data Source which has distinct ids which is used as a relation between 1st and 2nd datasource
and 3rd new one which will only have questions and answers grouped by id
SELECT Question, ISNULL(ModifiedAnswer, Answer) AS Answer,id
FROM JobFormQuestionnaireDetails
WHERE HeaderId = 66340
and Ignore = 0
AND Visible = 1
AND RenderAsTable = 1
group by Question, ISNULL(ModifiedAnswer, Answer),id
Now we will use filter condition on data source 1 to meet the following conditions
data source1 Question = datasource 3 question
data source 1 id = data source 3 id
Am I thinking correctly ?
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Want to display display columns horizontally in Stimulsoft report
Hello,
Please send us your request on support@stimulsoft.com. We will try to prepare sample for you.
Thank you.
Please send us your request on support@stimulsoft.com. We will try to prepare sample for you.
Thank you.
-
- Posts: 12
- Joined: Tue May 12, 2020 10:56 am
Re: Want to display display columns horizontally in Stimulsoft report
Hi Lech
Sorry for the late reply , I was able to resolve this issue.
Thanks for the guidance.
Sorry for the late reply , I was able to resolve this issue.
Thanks for the guidance.
Re: Want to display display columns horizontally in Stimulsoft report
Hello,
Okay, great! Thank you for letting un know abou this.
Stay safe!
Okay, great! Thank you for letting un know abou this.
Stay safe!
Re: Want to display display columns horizontally in Stimulsoft report
Hello,
Okay, great! Thank you for letting un know about this.
Stay safe!
Okay, great! Thank you for letting un know about this.
Stay safe!