Hi, I have a report returning bl

[mayathebee]

Hi,

I have a report returning blank when there are definitely records to return. This same report works on 2 development versions of the same site. I have queried the db so it's not an issue of there not being records. Please help.

Thanks

 

[HowardHammerman]

There is some problem with your selection statement.
Perhaps you are treating nulls differently?
can you get data with any report?

Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[mayathebee]

Thanks for your reply!

If there is something wrong with the selection statement, why does it work on another version of the site? (which is on another server).

 

[Madawc]

Comment out the selection and see what you do get.

Madawc Williams
East Anglia, Great Britain

 

[RamaKommineni]

Hi I am instantiating CR Viewver thru my Cold Fusion page using VB Script on IE6.

following is the way i am passing URL

webSource0.URL=&quot;http:<severName>:80/VirtualDirectory/roportName.rpt

Diplaying report properly when i put report file on my web server virtual directory.

But displaying Blank when i wish to get report from Remote Server that has Crystal Enterprise Server installed reports to be displayed.

Why CR Viewer is unable to pull report from remote box?

Appriciate any help on this..
Rama Kommineni