Dynamic Cross with changeble rows

Stimulsoft Reports.JS discussion
Post Reply
h.hojjati
Posts: 3
Joined: Tue Apr 09, 2019 3:32 am

Dynamic Cross with changeble rows

Post by h.hojjati »

hi
my problem is to creating a dynamic crosstab / cross band.
the problem is the data came from my JSON is not fixed.its mean i cant define a simple row for my cross tab.the rows came from json(its the filter applied by user in our web app) .sometimes its include 1 filter so my cross tab have 1 row and 1 column in JSOn. but sometimes the JSON includes more than 1 filter so my crosstab should have more than one row.
the output must be something like the picture bellow:
Image

so how can i design this report? thanks.
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Dynamic Cross with changeble rows

Post by Lech Kulikowski »

Hello,

It is difficult to say something without test data.

Also, you can try to create report from code:
https://www.stimulsoft.com/en/samples/j ... -from-code

Thank you.
h.hojjati
Posts: 3
Joined: Tue Apr 09, 2019 3:32 am

Re: Dynamic Cross with changeble rows

Post by h.hojjati »

VariableJson.json
sample json
(592 Bytes) Downloaded 130 times
hi dear Lech
thanks for your atention.
the solution im looking for is a bit different.let me ask my question in another way. i want to design a report without changing to program code or using JS codes.this report should have a table with multiple column and rows Assuming that the number of columns and rows are changing depending on the exported json.
the json can be look like the file attached.
serie : title of columns
value : data values
w,x,y,z : row titles but in different columns (like the picture upladed before).
thanks.
h.hojjati
Posts: 3
Joined: Tue Apr 09, 2019 3:32 am

Re: Dynamic Cross with changeble rows

Post by h.hojjati »

Lech Kulikowski wrote: Tue Apr 09, 2019 11:11 pm
hi dear Lech
thanks for your atention.
the solution im looking for is a bit different.let me ask my question in another way. i want to design a report without changing to program code or using JS codes.this report should have a table with multiple column and rows Assuming that the number of columns and rows are changing depending on the exported json.
the json can be look like the file attached.
serie : title of columns
value : data values
w,x,y,z : row titles but in different columns (like the picture upladed before).
thanks.
Attachments
VariableJson.json
(592 Bytes) Downloaded 137 times
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Dynamic Cross with changeble rows

Post by Lech Kulikowski »

Hello,

Unfortunately, there is no solution to make it without any coding with that data structure.

Thank you.
Post Reply