Hi,
Background: We have crystal reports.NET integrated into our ASP.NET application. Customers can run pre-designed crystal reports against data that they collect in the system. We populate the reports using an ADO.NET 'push' mechanism. When distributing, we install the cr9netredist.zip on the customer server. Customers also by CR Developer Edition so that they can design their own reports to run in the system.
Problem: When we design charts in our report templates on a local computer, we can get the X-Axis (Group By Axis) of charts to be formatted how we want it. eg 22/11/71. When we go to run the templates on the customers server, the date formats come out differently, eg 11/22/71. I would assume this is picking up some sort of local date format on the server.
This is not confined to dates, it also happens with numbers, eg a numeric axis can be 1,2,3 on my local computer, but appear 1.00, 2.00, 3.00 when the report is run the customer server.
Does anybody know how I can get full control over how the Group By Axis is formatted, when run on the customer server. We've tried all settings in the Grid dialog under chart options (in the Numbers tab). Quite often this tab is disabled, depending on the type of chart.
Thanks
Dan
Background: We have crystal reports.NET integrated into our ASP.NET application. Customers can run pre-designed crystal reports against data that they collect in the system. We populate the reports using an ADO.NET 'push' mechanism. When distributing, we install the cr9netredist.zip on the customer server. Customers also by CR Developer Edition so that they can design their own reports to run in the system.
Problem: When we design charts in our report templates on a local computer, we can get the X-Axis (Group By Axis) of charts to be formatted how we want it. eg 22/11/71. When we go to run the templates on the customers server, the date formats come out differently, eg 11/22/71. I would assume this is picking up some sort of local date format on the server.
This is not confined to dates, it also happens with numbers, eg a numeric axis can be 1,2,3 on my local computer, but appear 1.00, 2.00, 3.00 when the report is run the customer server.
Does anybody know how I can get full control over how the Group By Axis is formatted, when run on the customer server. We've tried all settings in the Grid dialog under chart options (in the Numbers tab). Quite often this tab is disabled, depending on the type of chart.
Thanks
Dan