6 Answers, 1 is accepted
Please elaborate on the received warning and at which moment it occurs. A screenshot of the issue will be helpful to understand better the case.
To my knowledge, in Excel files you can receive a warning about cells formatting, if in the report you use the Textbox.Format property or Format built-in Text function with a formatting string not applying correctly to the type of the visiualized content e.g. you try to format as a Date a string field.
You can check if this is the case by running a text search for "Format" in the report's files, and then checking the type of data that is formatted.
Please perform the following test:
- Use the Table item's Context Menu and Copy/Paste it in another empty report;
- Test exporting the newly created report.
- If the issue is not reproducible, perform text compare between the reports' Designer.cs files to pinpoint the different settings.
- If the issue is reproducible, test removing one column from the Table item at a time and exporting in XLSX. The purpose is to find the column with data causing the issue.
then check the data in the given column.
We can perform local tests too, if you can post the report's Designer.cs file which contains the code for generating the report, and test data in CSV format.
I follow your way to test the report. I found the column that caused the warning message.
The column's data if integer from the database, but it is displayed as string in the report. For instance, if it is 1, the report display "InStock". Please help.
We will need a sample report and data (CSV) in order to reproduce the behavior locally and investigate, or at least information about the data type (most probably integer) of the data field and the exact expression used in the column.
Also, let us know if you apply any formatting to the text box used in the column.
Thank you for your reply. I think I fix the issue.