Seal Report Forum
»
Report Edition
»
Reports
»
Using one filter for multiple charts
Rank: Newbie
Groups: Registered
Joined: 8/13/2018(UTC) Posts: 6  Location: Ankara Thanks: 2 times
|
Hi, I have multiple tables that have same column name. Those tables have nothing in common, only column names and types are the same. For example, both table have date column and I want to filter for date. I can do it with using multiple prompt but this time, dashboard become messy. I want to know if we can use one prompt for multiple tables/charts Here are table details: Quote:income_table
id int,
...
income_type int references another_table1
date timestamp
outcome_table
id int,
...
outcome_type int references another_table2
date timestamp Output is like; Quote:Total Income Per Type
Income_type1 %43
Income_type2 %40
Income_type3 %17
Total Outcome Per Type
Outcome_type1 %53
Outcome_type2 %45
Outcome_type3 %2 Output should be like after filter 01-01-2018/01-03-2018 Quote:Filtered Income Per Type
Income_type1 %53
Income_type2 %35
Income_type3 %12
Filtered Outcome Per Type
Outcome_type1 %43
Outcome_type2 %40
Outcome_type3 %17
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
The simplest to handle this is to copy your restriction prompted to your other restrictions...
This can be done using Pre Load Script in your models, or in a Task.
You have to understand C# and the Seal Report object.
Check samples 51 and 52 to have a clue...
Good luck.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/13/2018(UTC) Posts: 6 Location: Ankara Thanks: 2 times
|
Thanks for you reply.
I have another problem.
I am trying to get restriction value from another model and set it to this model's restriction.
I could get/set restriction value from same model but cannot go further.
Can you please explain how to do it?
If my method is wrong, can you please suggest the right method?
Have a good day.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
The Report object has a list of models...
So if you are in your model scripts:
List<ReportModel> models = model.Report.Models;
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
Using one filter for multiple charts
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
