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

Cross Tab Report and String Feild in Summary section with no record in command


We are using crystal report 2008 i.e. 12 version. We are exporting report through C# visual studio code.

The below issue for cross tab report.

We have one field description in report which is not getting displayed properly in column section i.e. summary section of cross tab. This is string field which need to be displayed. To display this field we are using Maximum function of summary and its value is getting displayed properly.

This description field is a formulae field which is formed on the basis of command output.

Now, there is a scenario, where this command query is not having row for particular column which is used in column section of summary. In this case the report when exported is distorted.

I want to show a blank entry in the position where there is no record found for that particular column for that row. Then how this can be achieved in cross tab report. Please let me know, if any more information is required.

Below Image is attached. Field is Desc For the 2nd combination, no record is found, so its distorted. Need to fix this issue.

Untitled1.jpg (80.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 05, 2015 at 02:02 PM

    Hi Renuka,

    Could you post a screenshot of the Crosstab Expert and the Preview Page of the report please?


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      Yes I mentioned to set default value beacuse I was not able to see blank value in string field when there is no row fetched. I cannot post the report with saved data as this is confidential data. But the issue is same as shared in screenshot. Can you please elaborate more on how string field looks blank when there is no row fetched.

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.