Multi-line display (crystal report)

[kkabongo]

I have a pre-printed page with space for 10 descriptions. The descriptions come from a table in the database. Description one goes on the first line, description two goes on the second line and so on. If there are less than 10 descriptions, the remaining lines should be left blank. I am using the .net version of crystal report. What is the best way to have these print on the prescribed line? Do I need to have ten formulas (seems excessive) to accomplish this?

Thanks

 

[synapsevampire]

Formulas wouldn't make sense.

By description 1 thru 10, do you mean you have 10 columns, or the first 10 rows from the data. Stating descriptions come from a table doesn't describe it adequately.

If it's 10 fields:

Place the field in the details section and suppress all other sections except for the page header, in which you will increase the size to cover the page up until the start of the area where you wish to print.

Then right click the details and select insert section 9 times and place the 10 fields in separate details sections.

If it's 10 rows:

Place the field in the details section and suppress all other sections except for the page header and page footer, in which you can increase the size to cover the page up until the start of the area where you wish to print, and the page footer for the rest of the page.

-k

 

[kkabongo]

Sorry I was not clear. The database table is defined as follow:

productId, descrNum, description. The productId and descrNum form the key to description. There can be up to 10 descriptions per productId. So, one can have a maximum of 1 rows of data. The pre-printed form has other info on it such as company name, address, etc...The descriptions have to appear in section on the form. So I am not sure having multiple detail sections will allow this.

Thanks for your help.

 

[dgillz]

Multiple detail sections is exactly what you need to use. Conditinally suppress these sections if blank in order to avoid excessive white space, and you should be good to go.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.srhconsulting.com

 

[lbass]

You probably need to group on {table.ProductID}, suppress the group header and footer, and in the section expert, check "new page after" for the group footer. Then use the multiple detail sections suggested above, and SV's technique for using the page header and footer to control position on the page.

-LB