Creating reports and dashboards | Stimulsoft community forum

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.

Hi lech

Is this possible using the 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.

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 ?

Hello,

Please send us your request on support@stimulsoft.com. We will try to prepare sample for you.

Thank you.

Hi Lech

Sorry for the late reply , I was able to resolve this issue.
Thanks for the guidance.

Hello,

Okay, great! Thank you for letting un know abou this.
Stay safe!

Hello,

Okay, great! Thank you for letting un know about this.
Stay safe!