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

[Former Member]

Hi,

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.

[abhilash_kumar]

Hi Renuka,

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

-Abhilash

[Former Member]

Is there a way to set default values to string type of field when used in summary section? For number type of fields, 0 value is shown as by default even though there is no row fetched form database. But how to set default value to string type when there is no row fetched from database?

[abhilash_kumar]

For strings, the default is blank.

You can evaluate formulas against True Nulls in a crosstab - meaning there exists a row for that data point and its value is just NULL.

For blank cells that do not have a row/column combination, there isn't much you can unfortunately.

So, in your case, if the string value that you're trying to set a default value for has atleast a row/column then you can use a formula however, if there does not exist a row in the database then there is no way to evaluate a formula against such blank cells.

-Abhilash

[abhilash_kumar]

For e.g, read through this thread for more info:

-Abhilash

[Former Member]

I dont want to set any default value. And I am not able to see blank value in string field by default. The report is getting distorted when there is no row fetched for the string field.

[abhilash_kumar]

I think you did say in one of your replies that you wanted to set a default value.

Would you be able to post the report with saved date here or send it to my e-mail?

-Abhilash

[Former Member]

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.