Hello,
In report I have four tables, (for example table1, table2, table3, table4). I need to do filtering by tables.
For example:
If I select table1 and table3, the report must only show this two tables (table1, table3)
Would anyone know how is this possible to implement?
Thanks
14 Answers, 1 is accepted
0
Hi Jara,
First you have to clarify, how the user would specify which tables would be visible and which not. A straight-forward way would be to create a multivalue report parameter which lists all tables and depending on the selected values, create a Conditional Formatting rule which would show only the desired tables.
Greetings,
Steve
the Telerik team
First you have to clarify, how the user would specify which tables would be visible and which not. A straight-forward way would be to create a multivalue report parameter which lists all tables and depending on the selected values, create a Conditional Formatting rule which would show only the desired tables.
Greetings,
Steve
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0
Jara
Top achievements
Rank 1
answered on 23 Aug 2010, 10:37 AM
Thanks Steve
0
Jara
Top achievements
Rank 1
answered on 23 Aug 2010, 07:49 PM
Now, I have another problem:
In application, I have reportBook, which contains 2 reports: Report_1 and Report_2;
Report_1 have 2 tables: tableA, tableB;
Report_2 have 1 table: tableC;
I did as you said, create a multivalue report parameter which lists all tables and depending on the selected values, create a Conditional Formatting rule which show only the desired tables.
It works fine.
The problem is that, when I do not choose (for showing) tableC, from Report_2, tableC is not visible, but is printed a blank page. How can I delete this blank page or make invisible.
Maybe you know, how can I solve this problem?
Thanks
In application, I have reportBook, which contains 2 reports: Report_1 and Report_2;
Report_1 have 2 tables: tableA, tableB;
Report_2 have 1 table: tableC;
I did as you said, create a multivalue report parameter which lists all tables and depending on the selected values, create a Conditional Formatting rule which show only the desired tables.
It works fine.
The problem is that, when I do not choose (for showing) tableC, from Report_2, tableC is not visible, but is printed a blank page. How can I delete this blank page or make invisible.
Maybe you know, how can I solve this problem?
Thanks
0
Hello Jara,
When a report item is hidden (Visible=false) it does not occupy any space, so it is strange that you observe such behavior. Try adding the following line right after the report constructor to see if that would make a difference:
this.detail.Height = new Telerik.Reporting.Drawing.Unit(0.01, Telerik.Reporting.Drawing.UnitType.Cm);
assuming that your table items are placed in the detail section. If they are contained within other sections, change the line of code respectively.
All the best,
Steve
the Telerik team
When a report item is hidden (Visible=false) it does not occupy any space, so it is strange that you observe such behavior. Try adding the following line right after the report constructor to see if that would make a difference:
this.detail.Height = new Telerik.Reporting.Drawing.Unit(0.01, Telerik.Reporting.Drawing.UnitType.Cm);
assuming that your table items are placed in the detail section. If they are contained within other sections, change the line of code respectively.
All the best,
Steve
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0
Jara
Top achievements
Rank 1
answered on 24 Aug 2010, 03:36 PM
Not helped.
Now I create very simply project:
ReportBook contains 3 reports: ReportA (page 1), ReportB (page 2) and ReportC (page 3);
All reports have textbox with some value;
When I made ReportC visible = false, and adding your line, I still seeing 3 pages: first page ReportA, second page ReportB and still seeing third page, which is blank.
Do you have some suggestion?
Maybe it is because I have using Trial Version, because it prints at the bottom of the page some line?
Now I create very simply project:
ReportBook contains 3 reports: ReportA (page 1), ReportB (page 2) and ReportC (page 3);
All reports have textbox with some value;
When I made ReportC visible = false, and adding your line, I still seeing 3 pages: first page ReportA, second page ReportB and still seeing third page, which is blank.
Do you have some suggestion?
Maybe it is because I have using Trial Version, because it prints at the bottom of the page some line?
0
Jara
Top achievements
Rank 1
answered on 26 Aug 2010, 08:41 AM
Steve,
Maybe you have any suggestions?
Maybe you have any suggestions?
0
Hi Jara,
I missed the fact that you're working in the context of a report book in your previous post - sorry about that.
Indeed as specified in the Report Book documentation, each report would start on a new page in the combined document, so hiding the table is required but not sufficient as the report sections and the report itself is visible, so a page would be created in the report book.
To avoid this, you would have to apply a conditional formatting rule for the report itself. Its expression should contain checks for the parameter values of the tables contained within this report and if none of the values are selected, then the conditional rule would hide the report itself.
Best wishes,
Steve
the Telerik team
I missed the fact that you're working in the context of a report book in your previous post - sorry about that.
Indeed as specified in the Report Book documentation, each report would start on a new page in the combined document, so hiding the table is required but not sufficient as the report sections and the report itself is visible, so a page would be created in the report book.
To avoid this, you would have to apply a conditional formatting rule for the report itself. Its expression should contain checks for the parameter values of the tables contained within this report and if none of the values are selected, then the conditional rule would hide the report itself.
Best wishes,
Steve
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0
Jara
Top achievements
Rank 1
answered on 26 Aug 2010, 02:36 PM
I did something similar, but still get the same result.
Maybe, can you show a simple example of how to do it?
Thanks
Maybe, can you show a simple example of how to do it?
Thanks
0
Jara
Top achievements
Rank 1
answered on 27 Aug 2010, 07:39 AM
For example:
In reportC I have create report parameter id, type - boolean, value - false;
and apply a conditional formatting rule for the report
(Expression) = False
(Operator) =
(Value) =Parameters.id.Value
and in style Builder, Layout uncheck visible checkbox.
But still get the same result (blank page).
Maybe I am usimg the wrong logic, or my conditional formatting rule is wrong?
Please, give me some example.
Thanks,
In reportC I have create report parameter id, type - boolean, value - false;
and apply a conditional formatting rule for the report
(Expression) = False
(Operator) =
(Value) =Parameters.id.Value
and in style Builder, Layout uncheck visible checkbox.
But still get the same result (blank page).
Maybe I am usimg the wrong logic, or my conditional formatting rule is wrong?
Please, give me some example.
Thanks,
0
Jara
Top achievements
Rank 1
answered on 30 Aug 2010, 01:52 PM
Steve,
Can you show any example?
Can you show any example?
0
Hi Jara,
Please open a support ticket and attach your reports so that I can run them locally and pinpoint where the culprit is.
Kind regards,
Steve
the Telerik team
Please open a support ticket and attach your reports so that I can run them locally and pinpoint where the culprit is.
Kind regards,
Steve
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0
Reinan Shook
Top achievements
Rank 1
answered on 02 Sep 2010, 09:07 PM
Hi, I am having the same issue. I was wondering if a fix or workaround was found.
Thanks
Thanks
0
Jara
Top achievements
Rank 1
answered on 03 Sep 2010, 07:31 AM
I have send a support ticket, but did not receive a response, yet.
0
Hi,
The reported behavior seems to be an unsupported scenario which we're going to address in subsequent version.
For the time being, I can suggest another approach and it is to use subreports. The idea is to have a master report with detail section, subreport items in it and parameter controlling the visibility of the subreport items.
NOTE: Mind the slightly different rendering of subreports against report book (in the pointed article). For example page sections of subreport are ignored (page sections of the master report are rendered).
Sorry for the temporary inconvenience.
Regards,
Steve
the Telerik team
The reported behavior seems to be an unsupported scenario which we're going to address in subsequent version.
For the time being, I can suggest another approach and it is to use subreports. The idea is to have a master report with detail section, subreport items in it and parameter controlling the visibility of the subreport items.
NOTE: Mind the slightly different rendering of subreports against report book (in the pointed article). For example page sections of subreport are ignored (page sections of the master report are rendered).
Sorry for the temporary inconvenience.
Regards,
Steve
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items