Limit on number of characters in report query

building reports desktopintelligence
1

I am working on BusinessObjects XI R2 and creating a Desktop Intellgence report. The report query is a massive one which combines 15 to 20 select statements by making use of UNION ALL. The number of SQL statements that are unioned will vary dynamicallly based on inputs from a macro. The report is working fine for a certain limit of select statement. After it exceeds a certain number of characters, it seems to break down. I understand that there is a limit on the number of characters in a report query - 65536. Could somebody clarify if that is the case? Thanks!

nithya_raj (BOB member since 2007-02-03)

2

I should have posted this in the DeskI forum. Could one of the moderators please move it across. Sorry about that!

nithya_raj (BOB member since 2007-02-03)

3

Topic has been moved.

Marek Chladny :slovakia: (BOB member since 2003-11-27)