Default Format (Crystal Report)

rzr

rzr

Member
Hello All..

I'm not familiar with crystal reports ... in our application the following *rule* is followed:

to display 50 char of data on crystal report the format for the character field in db is set to "X(50)".

@ progress default "X(8)" would have been enough and we could still display all 50 characters
@ crystal reports.. if i need to see 50 char of data - is it compulsory for the format to be "X(50)" in db ( btw SQL-WIDTH is also 50) ??
 
Which version of Crystal for a start? They all work differently in so many ways!! :( Also, how does Crystal connect to your database?
 
Ok not familiar with that version of Crystal I'm afraid, but older versions were a lot more strict about data formats than Progress is. AFAIK, if something is going to have 50 characters in it then it needs an x(50) format. If it is only going to have 8 characters in it then x(8) is enough. If the format is too short you risk having blanks displayed.
 
I asked b/c we have a crystal report where user wants to display a new field with 2000 characters of data. And I am not happy creating a new field in the table with format "X(2000)".. just did'nt make sense to me... But if that's how crystal+progress works... then i guess i have no choice !!
 
Crystal Reports is using ODBC to connect to the database and therefore connecting to the SQL92 half of the database. The SQL92 side has no notion of what a format is and only knows about the SQL-WIDTH (MAX-WIDTH in later versions of OpenEdge).

So you do not need to set your format to X(2000) you must however set your SQL-WIDTH / MAX-WIDTH to 2000.
 
You must log in or register to reply here.
Back
Top