GAURAVGUPTA9
27th March 2003, 08:15
hi all;
i want to print a report coulmn wise. in the report rows are fixed but coulmns are not fixed. how can i make variable columns?????
thanx.....
Gaurav

mark_h
27th March 2003, 16:47
You can always make the headings variables in the report. Just like the data under them. This is what I did in one report.
hd1 hd2 hd3 hd4
wc data1 data2 data3 data4

Everything was a variable- actually I used array variables. I would get work center(wc) hours by week - and depending on what week the entered on what dates went in the headings(header.1 of report). So the final data looked like:

1-1-02 1-8-02 1-15-02 1-22-02
3B2 6 20 30 10

Or
3-12-02 3-19-06
3B2 30 20

Does this answer your question?

Mark

Hitesh Shah
4th April 2003, 18:04
If variable columns mean variable values but fixed number of columns , then Mark's suggestion is perfect.

If however u mean variable number of columns in the report , u can do so only with the help of spool functions in Baan. This is bit tough task though not entirely impossible .

Brp.open and rprt_open functions in Baan won't let u have variable number of columns in the report.

OmeLuuk
7th April 2003, 10:57
I have had defects on the multi column reports in Baan and there are several problems that were not able to get solved. This resulted in the Baan statement that multi column with variable heigth of individual records is not going to work well with multi column. This includes text and conditional suppressing of layout parts.

See solution 161877