Monday, March 19, 2012

Crystal report server on Solaris

The report which is displaying correct report in Crystal report editor and crystal report server in windows OS is not displaying correct report when published in crystal report server on Solaris.

note: same database is used for all the above cases. (Oracle)

Did anyone have experienced the same? If so please help me to solve this issue.

Thanks,
KWhat's not displaying correctly? Numbers? Dates? Maybe the report fields are using system default formats and you need to explicitly set the formats.|||Thanks for your reply.

The report was designed to pull data from a view. The report is published in Crystal Application server and viewed as HTML format using Java components. When is report is deployed in crystal application server running on windows, works fine. But the same report published in the crystal report server on solaris is displaying different report.
There is grouping included on a particular field in the view. Following is the group name formula used,

ToText ({VW_ACH_PAYMENTDETAIL_RPT.BATCH_ID},0)

Grouping is not happening as designed on solaris. What is 'report fields are using system default formats'? How do I identify and fix this?

Thanks,
Karthik.|||So the reports are different in the way the data are grouped, using your formula. How exactly? Can you give an example? What happens if you change your formula to
ToText ({VW_ACH_PAYMENTDETAIL_RPT.BATCH_ID},0, '')

If the data itself is displaying differently right click on the field and choose Format Field. See if System Default Format is highlighted - you can set it to be explicit rather than relying on the system defaults.

No comments:

Post a Comment