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.