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

NoDataMessage on TableWizard while Filter Applied

3 Answers 131 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Software
Top achievements
Rank 1
Software asked on 18 Jan 2018, 01:44 AM

Hi, I am working on Telerik Reporting version R3 2017. I got the output as expected and it is giving me report very accurately if all data is there. In some cases I am my Table wizards do not have Data in Datasource and as result it is creating an empty patch on report.
Let me explain: Lets say I have 4 table wizards

TableWizard1 - shows Customer with only with First Name
TableWizard2 - shows Customer with only with Last Name
TableWizard3 - shows Customer with only with Address 
TableWizard4 - shows Customer with only with Phone Number

All 4 table wizards getting filled by only one CustomerDetailsDataSource to make it in different tables I applied filters Lets say for TableWizard1, I applied filter if F_Name!= "" or for TableWizard2 I applied filter L-Name!= "". 

Now, my problem is if there is TableWizard1, TableWizard2 & TableWizard4 has some data and TableWizard3 do not have any data still it is showing an empty patch on  ReportViewer, Obviously on PDF also.
 
I had look on NoDataMessage but it seems like it doesnt work in this case. Can you please suggest how can I handle that?
Thank You

3 Answers, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 22 Jan 2018, 12:20 PM
Hi,

The "No Data Message" is activated when the data source returns NO records, as explained here. If there is no data after the filtering is applied, it should be activated.

I would recommend you to assure that the filtering is correctly applied and no records are returned when the corresponding field is empty. I have attached screenshots from Edit Filters Wizard demonstrating correct and wrong filtering.

I have attached also a sample. Note that all the Addresses are empty (4th column of the CsvDataSource), hence when the filtering is correctly applied the 'No Data Message' is shown. In the rest of the Tables (including the second Address table) there is data (although Blank in Address column), hence the Tables are displayed.

If the problem persists, you can open a Support ticket and attach the report so that we can investigate it and try to provide an appropriate advice.

Regards,
Todor
Progress Telerik
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 Feedback Portal and vote to affect the priority of the items
0
Software
Top achievements
Rank 1
answered on 07 Mar 2018, 10:37 PM
Yes, No Data Message shows when DataSource is empty. I am getting data in DataSource and after that I am filtering. And Filters are working correctly because when there is data it appears in Table Wizard the way I want, That means filters are correct. Need something for No Data Message after data filtered from DataSource
0
Todor
Telerik team
answered on 12 Mar 2018, 11:56 AM
Hi,

The provided information is not sufficient to locate the problem.
To try to provide additional advices we would need the report definition for investigation.

I suggest you to open a Support ticket and attach the report.

Regards,
Todor
Progress Telerik
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 Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Software
Top achievements
Rank 1
Answers by
Todor
Telerik team
Software
Top achievements
Rank 1
Share this question
or