Hi,
I am wondering why some reports when saved as excel do have a different format.
In some the fields are missing in some fields are added up such as Print Acknowledge Letters.I was wondering , is this something that can be changed accordingly.
Any suggestions.......
Thank you,
Revanth
Revanth,
I may not understand completely, but when you save to excel, there is a checkbox to include data headers. If you do not check this, the data column headers will not be included. Then as Sabina mentioned if the stored procedure you create does not name the computed field, it will just show up as computed field or something like this. Also, with Infomaker reports, composite reports do not include the sub report data. However, an advantage to switching over to SSRS is that it does pass over this data. Which report is causing you the issue?
Hope that helps,
Christian
Some SQL scripts are multi-purpose and serve several reports. If the script in the background is pulling (for example) fifteen columns, but the report you are looking at only uses ten of these, you will get what appears to be five 'extra' columns when you save.
Moreover, some reports utilize subreports. When this happens, only the data source from the main report is returned into the Excel spreadsheet. If it's necessary to get the data that would be displayed in a subreport into a spreadsheet, it's recommended to create a separate custom report just to produce that data.
Thank you very much for all those who have replied.
I am planning to create a new report with the columns required and see how it works.I will get back once I am done with it.