Repeating box in detail

[gmman]

I am using Crystal 8.5 and I am tring to make a box repeat in the detail that may grow several lines. Below is an example of the text. This comes from a data type LONG. I am setting it up in 3 columns so one of the lines will wrap.


Placarding at proper location on tool.
Energy isolating device tags in place.
All lockout controls listed on placard.
Lock boxes equipped with locks and scissors.
Locks in use properly identified.

This is what I want it to look like I used the underscore in place of the check box

___Placarding at proper location on tool.
___Energy isolating device tags in place.
___All lockout controls listed on placard.
___Lock boxes equipped with locks and
scissors.
___Locks in use properly identified.


Thanks for any help

 

[rosemaryl]

Dear gmman,

Since you are in Crystal 8.5 what you can do is use a SQL expression as long as this is not long raw (oracle).

Now if the result of this can be greater than 254 characters the expression will blow up, you would have to use Patindex to return each line to a separate formula.

Anyway, create the following SQL expression:

Insert/Field Object/SQL Expression - Name it whatever

Copy and paste the following replacing Tabl.LongField with your table.field name.

(
(SUBSTRING(replace(substring(Table."Longfield",1,8000), CHAR(46), '<font face = wingdings> o' + CHAR(13)), 1, 253))
)

Now place the sql expression on your report and right click, format field, paragraph formatting tab and select HTML Text Interpretation ... should work.

However, you didn't state your db, so I am using SQL Server 2000 with SQL ODBC connection.

Regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[gmman]

Rosemary,

Our database is Oracle8i so I expect that that will not work for me.

 

[rosemaryl]

Dear gmman,

No you can do it on Oracle - it is specifically the field type cannot be long raw, there is a difference between long raw and long.

Show the statement to your dba and have him translate to Oracle syntax.

I think the only change is to the word substring in oracle it is substr -- I don't have Oracle up right now to test.

But, I think it is solveable.

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[gmman]

Rosemary,

I will check with the DBA tomorrow, I tried the statement with substr and I get a
Crystal Reports: Database Error
ORA-00936: missing expression