200 Field Report

[pkohli8]

Hi,
i have to generate report that includes almost 200 fields and for that i am using SQL query in the COMMAND.
but as soon as after writing SQL query in Command, I hit OK, the crytal closes automatically.
can anybdy tell , is there any limitation on the number of fields in CR or is there anyother way to do this

Thanks In Advance

 

[bdreed35]

Can you verify that the Command runs successfully in a database quesry tool such as Toad (Oracle) or Query Analyzer (SQL Server)?

~Brian

 

[pkohli8]

yes it runs successfully in TOAD

 

[dgillz]

What if you never write a sql query and just pick the fields in the report expert. Does it work then?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[pelajhia]

max size:

http://technicalsupport.businessobj...sliceId=&dialogID=2782806&stateId=1 0 2778945

although this 'fix' article gives a different max size...

http://technicalsupport.businessobj...sliceId=&dialogID=2782806&stateId=1 0 2778945

never tried this myself....