Crystal reports help

[Bruce Wiebe]

Hi all

Does anyone know how to bind a crystal report to a dataset that has been
retrieved from a web service to a local machine so that it can be
displayed on a windows form.

any help would be very helpful

 

[Bernie Yaeger]

Hi Bruce,

When you say the dataset has been retrieved, in what format does it exist on
the local machine? If it is a table in sql server, it's easy; even if it's
..xls .csv .dbf or .txt it's also pretty easy.

Bernie Yaeger

 

[Bruce Wiebe]

Hi Bernie

Thanks for your reply should have mentioned in the original post that
the data is being retrieved via a select statement from a sql database
that resides on the webserver. The result from the select statement is
then returned as a datataset via the webservice to the desktop machine
and it is this data that i want to bind to a crystal report

thanks once again for your reply

 

[Bernie Yaeger]

Hi Bruce,

Probably the best thing to do is to copy the dataset into a sql table on the
client or into a .dbf or a .csv on the client. you will need the odbc
driver in .net to copy it to a .dbf file.

I don't think - but I'd recommend you check with crystal - that you can bind
to a dataset in memory.

HTH,

Bernie