This is a migrated thread and some comments may be shown as answers.

choose to display or not a graph or crosstab before generating report

3 Answers 11 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Wassim
Top achievements
Rank 1
Veteran
Iron
Wassim asked on 24 Feb 2021, 02:25 PM

Hello,
I would like to create a report where the user has two checkboxes and has the choice to either show or not display a crosstab and/or graph when generating the report.
I am working with Telerik Report Designer with Telerik Reporting REST service and using HTML5 MVC Report Viewer as a report viewer.

the management of this need is done when defining the report or I have to add js events handler in my report viewer ?

Does any one have an example please?

regards,

3 Answers, 1 is accepted

Sort by
0
Wassim
Top achievements
Rank 1
Veteran
Iron
answered on 26 Feb 2021, 08:40 AM

I found an idea for the previous question from the forum.

Another need: before generating my report, in my view, there is a DDL with 'type1', 'type2', 'all types' as values,
after the user has chosen to display the correct records in my crosstab, this value is tested against the value of a column from the data source used but two other values 'T1' and 'T2' knowing that 'type1' matches to display 'T1', 'type2' matches to display 'T2' and 'all types' to display all data.
I did not find the way to do that ?

Any suggestions please if i can did this ?

Thank you 

0
Wassim
Top achievements
Rank 1
Veteran
Iron
answered on 26 Feb 2021, 09:01 PM

By posing a filter and linking it to the data source field, I solved the problem.

 

 

Question: I am new in telerik reporting.

I wonder if there is a way so that I can add in my existant report which contains graphs and a crosstab a part of the data to display like  "band report wizard" because I have some data with totals and sub totals associated to categories that i want to display.

It would be much appreciated if you can help me on this.

regards

0
Accepted
Mads
Telerik team
answered on 01 Mar 2021, 10:47 AM

Hello Wassim,

It's great to see that you found answers to your previous questions. I will try my best to answer your latest one.

When using the Band Report Wizard, it will help you quickly create report-groups and generate textboxes to display the information. All of this can still be achieved manually if you wish to apply it to existing reports.

In this scenario, if you wish to use existing graphs and crosstabs inside a Band Report, I can suggest two approaches. Either create a new report using the Band Report Wizard, then copy over the elements you want to keep. These can be copied into different sections, depending on how much data you want the graphs and crosstabs to include. If copied into the Report-Header, all data will be included and it will only be displayed once. If copied into the Group-Header, it will repeat once per group. Use the ReportItem.DataObject to set the data-source of the graph and crosstab to the data available inside each specific section, like mentioned in the last part of this article "Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph)"

The next approach is to apply the groups and create totals and sub-totals to your already existing report. I would suggest creating a report using the Band Report Wizard and see how it will set up the groups and the different sections. Then apply groups in your existing report based on it, in addition to setting up totals and sub-totals like in the Band Report. We have an article explaining more about Report-Groups called "How to Add groups to Report". Totals can also be added directly to the cross-tab if you prefer. By right-clicking on the cell with the number that you want to create totals from, the 'Add Total' option should be available.

I hope you find this information useful. Let me know if it works out, if you run into challenges, or have any further questions.

Regards, Mads Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
General Discussions
Asked by
Wassim
Top achievements
Rank 1
Veteran
Iron
Answers by
Wassim
Top achievements
Rank 1
Veteran
Iron
Mads
Telerik team
Share this question
or