pjohns
5th September 2001, 18:39
When using ttadv3180m000 - Maintain Query Data, a user wants to create a report that is larger than the A3 for Text Files print option. I have tried to create a report default size greater than 255 wide but Baan will not let me. Is there a way around this or is 255 the largest?
The report will not be printed we just need to create a flat file.
I have asked Baan support and they say it cannot be done :( but I thought I would check with the "community" before I give up on this one.
Thanks
PJ
P.S. Don;t ask me why a user needs a report wider than 255
victor_cleto
6th September 2001, 08:41
If it was another number I would bet it could be increased, but a full byte value (0-255) as limitation, looks like a programming limitation, so I think you are stuck with it. :(
vishbaan
6th September 2001, 10:17
Since its a report limitation,
I suggest u better create an update session or 3GL script, which will create an ASCII file rather. (you can use command : seq.open, puts, putc, seq.close etc..).
This works for us. We can have fields concatenated with delimiters of users choice
pjohns
6th September 2001, 13:58
Thank you for your replies.
I don't really know enough, if anything, about 3GL so I will leave things as they are.
Vishbaan - you say create an update session or 3GL script. Would this be against ttadv3180? If so I thought you couldn't make any changes against tt objects?
PJ
zaidlaz
6th September 2001, 15:52
Hi,
If it is a limitation or constraint that Baan has/have try use other options outside of Baan. For example if you're database is Oracle or any other use SQL scripts to write the report.
Best Wishes,
Zaid
vishbaan
11th September 2001, 09:36
Hi,
Instead of a query,
I suggested a session which will filter the required data and put the result into an ascii file (can have more than 232 columns)
Its an easy process, try it out.