Issue with crystal reports 2008

[farrukhkamal]

Hi All

There is any which i am facing in crystal report for replacing the link with the table.

The screenshot has been attached.

I want that if there is any data which needs to be appear on table then the comment won't come and if there is no data for the table then the comments appears only.

Please help me..

 

[lbass]

Use a left join from the first table (A) to the table (B) that you want to generate the comment if there is no data. Then create a formula:

If isnull({B.CaseID}) then
"No Results"

If headings appear when there is no data, suppress them with a formatting formula:

Isnull({B.CaseID})

Format sections to "suppress blank sections" in the section editor.

-LB