ahulikavi
30th January 2002, 06:28
We are customising some reports where amount of information demands report width of more than 255 characters, we are on BaaN IVc3, report width of more than 255 is not allowed, any suggestions ??
shah_bs
1st February 2002, 20:12
I suppose you may have sorted this out by now.
However, here is what can be done. All involve basically buying-out the end-user on the layout change:
- Create additional HEADER/ DETAIL Layouts and continue the additional fields on the new layouts.
OR
- Create additional REPORTS (example would be say Print Item Data) where related fields are located on each report and then the reports can be printed as desired.
OR (last resort, I would resist this one as far as possible)
- create an ASCII File (CSV format) where all the fields are strung together in one record as desired, 'put' the file to the C: drive of the user, and fire up EXCEL with the file, allowing the user to format and print as required. (It is possible, as you must know, to define a custom layout in EXCEL. So, each time the user runs the report, and when the EXCEL comes up, all he has to do is 'format' to the custom layout.) As you can see, not a very user-friendly solution.
ahulikavi
5th February 2002, 06:00
Thanks Shah for your inputs, but to make reports "Excel Freindly", we need to have all the fields on the same row, otherwise its a pain to work on the info in Excel.
In Fact for some of our reports we have used "," (comma) as column seperators instead of "|" (pipe), user gives extension ".csv" after selecting device as Excel in the report print dialog, this avoids "Text to Columns" conversion in Excel.
naabi0
5th February 2002, 16:20
You can change your list separator to a "|" in the numbers tab of Regional Options inside the Control Panel Folder and get around using a comma.
francishsu
5th February 2002, 18:12
Not exactly an ideal solution, but it'll work.
Create a special Baan device, either a Rewrite file or Direct using my ascii printinf file (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=761), that executes a script/program to merge multiple detail lines into a single line
Baan device -> Baan output file -> script processor -> new output file
Example:
Baan report output (each "row" of detail split into two lines):
A1|B1|C1
D1|E1
A2|B2|C2
D2|E2
result after processed by script (merge every two lines):
A1|B1|C1|D1|E1
A2|B2|C2|D2|E2
shah_bs
5th February 2002, 22:31
Er... maybe I should have clarified more about my 'EXCEL' solution: you will no longer be using the report layout. Instead, you will be using the seq.* functions, and assemble the output as a single row (as you rightly point out) by hand into a sequential file. (As I said earlier, this is the least programmer friendly option.)
sitarammani
16th February 2002, 19:34
I handwove the details with html tags
<html>
<table>
<tr>
<td>Thisfield</td><td>Thatfield</td><td>....</td>
</tr>
over multiple lines of detail.1
</table>
</html>
send the report to excel
copy the entire worksheet
insert a new worksheet
paste-special values.
hawabaan
12th July 2002, 10:20
Please check P.Cole's [Quoted below]
You can find it under :
CODE: AWKward Script for Baan Reports' passage to MS Excel
(http://www.baanboard.com/baanboard/showthread.php?s=&threadid=1546)