Print Message when Subreport has no Record

[Ajay]

Hi,

I need to display "No Record Found" Message in Section of Parent report when subreport has no record to display.

Please suggest what to do ??

Thanks...

[Steve]

Hi Ajay,

There is no out of the box way to show "No Record Found" message. You would have to check the data source for the SubReport and if there aren't any records, set desired "No Records" message to a label TextBox. See the following blog post for a possible approach to accomplish this.

Kind regards,
Steve
the Telerik team

[Ajay]

Hi  Steve,

Thanks for reply,

I have tried this solution before posting question..

This is My Code for Hide/Show message

private void subrptClass_ItemDataBound(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.SubReport subReport = (Telerik.Reporting.Processing.SubReport)sender;
            subReport.Visible = subReport.ChildElements.Find("TextBox16", true).Length > 0;
            textBox2.Visible = !subReport.Visible;
        }

This works fine to hide subreport But textBox not get Visible..
If I've check textBox value is Set as per Last Record.
means..   if two record then in first textbox is visible true, and by second record it be visible false then it will visible false for every subReport.

How to Make Textbox visible when subreport has No Value ???

[Stef]

Hi Ajay,

The approach that my colleague has suggested is valid and I have attached two reports which work as expected (ApproachfromBlog.zip).
Another approach is to use a textBox item in the detail report with visibility bound to an expression checking if Count(1)=0 (if there is data), and displaying text from within the subReport item as 'No data'. Other suggestion is illustrated in the attached reports, based on the same approach. Please notice that we work with processing elements.

Greetings,
Stef
the Telerik team

[Ajay]

Thanks for reply.

I have got my solution by your answer..