Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Sep 03, 2016 at 09:35 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Posted on Sep 06, 2016 at 01:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.