Crystal Reports NET - change culture

[Former Member]

My application references Crystal Reports DLLs and uses them to generate reports (Using CrystalDecisions.CrystalReports.Engine.ReportDocument).

I need to customize the way Crystal outputs dates and numbers.

First I tried to set Culture on the thread that uses ReportDocument and calls its ExportToDisk method.

(Thread.CurrentThread.CurrentCulture and Thread.CurrentThread.CurrentUICulture)

Then I tried setting the default culture for my application

(CultureInfo.DefaultThreadCurrentCulture and CultureInfo.DefaultThreadCurrentUICulture).

Neither of these helps.

Is there any way to change Culture under which Crystal generates report?

Thanks

[former_member11696 · Accepted solution]

Hi Jira,

Have a look at this KBA I wrote:

2003581 - How to set the Localization for a Crystal Reports .NET application...

Don

[Former Member · Accepted solution]

Thank you Don,

this really helped a lot. I managed to make it choose the right culture.

I have one more question. Is there a way to specify date or number format explicitly?

Say I want to use Czech date format but I want to keep numbers formatted like US (dot instead of comma as decimal).

Something like you can do with .NET CustureInfo.DateTimeFormat.ShortDatePattern.

Thank you very much!

[former_member11696 · Accepted solution]

Hi Jiri,

You would need to use Formatting formula to handle each object format.

Post to CR Designer forum, search first though, I believe someone else wanted to do the same thing.

In the formula editor there is a formula function called - ContentLocale

You should be able to use it possibly, otherwise a formatting formula for each object.

Don

[Former Member · Accepted solution]

I was hoping I can get around that. Never mind, thank you very much, Don!

[former_member11696 · Accepted solution]

If you set your formula and other objects to System then it may work if you change the culture without having to change each one. Otherwise I don't think there is any other way.

Don