NLS setting for Oracle

DirkJoDirkJo
edited 8:20AM in FastReport .NET
We are trying to use FR.Net using an ODBC connection to Oracle.

When working with dates, we are always getting english results (weekday names, month names, date format). But we want to have german settings. Where to set that FastReport or ODBC connection or Oracle should use NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1'?

Is it possible to execute an SQL like "alter session NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1'" when starting the report?
Or is there any way to pass a setting from .Net (C#) to FR in order to use german settings?

Best regards
Dirk

Comments

  • Mikael P.Mikael P.
    edited 8:20AM
    Hmm, would it be possible to programmatically retrieve the data from C#, format it there with the culture set to German, and then add it to the report by setting it position and such manually?
  • Mark JunkerMark Junker
    edited 8:20AM
    You can probably use the StartReport event as shown in the following post: DataSet

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2024