View Single Post
Old November 12th, 2003, 09:21 AM
jeroenjmdejong jeroenjmdejong is offline
Registered User
Join Date: Nov 2003
Location: Rotterdam, , Netherlands.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Datasource + logon prompt

I have a problem with a report I made using Crystal Reports (hence this forum....). The report is based on a view on sql server but I want to filter the data. I do this by adjusting the datasource to a new datatable, based on a where string. On screen this all works fine but when a user wants to export the report to word/excel, he/she gets a logon prompt. I have tried setting the datasource to a dataset (based on an xml file) but this doesn't work (no filter is applied although the dataset has only the filtered records, the report seems to hold a connection to the original xml file).

Can any one please help me with this, I've been working with the guys from Crystal Reports Help desk for a week now but so far we haven't been able to solve it.