Skip to Content

Selecting multiple numeric fields for formatting reverts to default when saving

I have a report that has a large amount of numeric fields, both in the main report and in a sub report. The sub report is giving me the most problems. There are 84 fields that I select for formatting. They are all numeric fields in the report footer. There are 12 report footer sections but only one is visible in the printed report, according to the month entered into a parameter.

When I go to "format field..." then I go to number and I can see that the formatting is not the same for all the marked (selected) fields because the rounding and display attributes are blank.

Then I select what I need to display and round as integer. I deselect the fields and re-select them, and then review. The attributes are there. Then I save the report and close it. I reload the report and select the same fields and review. The attributes for the selected group are blank again, indicating that there are differences in the formatting of the selected fields.

Indeed, it seems that the formatting of the 84 fields are randomly saved. Some have reverted back to two decimal places and some kept the settings I gave them.

I have been very careful about what I am doing and I have over a dozen years experience with Crystal Reports. I am wondering if it is the sheer amount of fields involved, although I have saved in sections and it doesn't seem to have helped.

The only thing that seems to be working is if I format and save each field one-by-one.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 26, 2019 at 10:22 AM

    Right-click the subreport, select 'Format subreport', select Subreport tab.
    Make sure 'Re-import When Opening' option is NOT turned on.

    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.