Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, all!
I need to generate a PDF report, which includes a list box called Index with more than 1000 records. I simply drag the list box in the Report Editor, but instead of showing all records, it only shows one column. I did settings in: 1) List Box Properties---> Presentation--->Fixed Number of Columns (to '10' !!!); and 2) Item Setting---> Stretch (to 'Clip' !!!). How can I make all records listed? Any help or suggestion would be appreciated.
Regards, Luwen
I don't believe that this is possible - the capabilities from report-editor are unfortunately (more or less) restricted. Therefore you will need some kind of workaround - the easiest way seems to be to use a textbox with an expression like: = concat(distinct num(%ID, '00000'), chr(9) & '|' & chr(9), %ID) which you might need to modify the delimiter or the font or other layout-options from the textbox to make it suitable for your report.
Table-Chart solutions might be possible too, especially if there are some precalculations within the script.
Another option is to use tools like NPrinting: QlikView NPrinting.
- Marcus
I don't believe that this is possible - the capabilities from report-editor are unfortunately (more or less) restricted. Therefore you will need some kind of workaround - the easiest way seems to be to use a textbox with an expression like: = concat(distinct num(%ID, '00000'), chr(9) & '|' & chr(9), %ID) which you might need to modify the delimiter or the font or other layout-options from the textbox to make it suitable for your report.
Table-Chart solutions might be possible too, especially if there are some precalculations within the script.
Another option is to use tools like NPrinting: QlikView NPrinting.
- Marcus
Hi, Marcus!
Thanks for the reply. It's very helpful. I tried to use a textbox, and it worked.
Luwen