Image and Formula in Report Header will not display if no data is returned

[Former Member]

I have a report where there is a dynamic image that is displayed based on the value of a parameter.  Also in the header is a formula that returns a agencies name, address ect based on the parameter value.  All works fine if the report query returns data but fails to display if no data from the query is returned.  How do I go about making sure the image and formulas display regardless if data is returned.

Using Crystal XI and SQL 2014

Mike

[abhilash_kumar · Accepted solution]

Hi Michael,

Insert a Subreport and place it on the Report Header.

Use the table that stores the agency name, address etc as the subreport's datasource.

Use the image on the Subreport's report header and place all other fields as well.

Next, right-click the Subreport > Change Subreport Links > Move the prompt to the pane on the right and link it with a field inside the subreport (much like an inner join).

-Abhilash

[Former Member · Accepted solution]

I would of preferred not using a sub report to accomplish this but I ended up using two of them.  One for the logo and the other for the department name.  I did this because I needed to add other fields or formulas to the page header.

[DellSC]

Another option would be to put the table(s) with the agency info first in the linking order in the Database Expert.  You would then make all of the links left-outer joins and you would probably have to tweak any selection criteria to account for possible null values in tables that are further down in the linking order.  This way you would always have the agency data even if there is no other data.

-Dell

[Former Member]

I tried that method but still had problems.  I ended up doing the sub report method.