SmileyFace
Programmer
Ok, now I need to know why when I run a report which runs from my browser fine through the Crystal Reports viewer does it ask me to select a datasource when running from the design view!
Basically the report just needs a date range and runs fine through the browser. But when I go into the design mode and try to run it, besides asking me for parameters, it also brings up a window saying 'Select Data Source' and I have a choice between 'File' and 'Machine' data source. I need to get into the SQL query for this report to alter the 'Sort' criteria but it again asks me to 'Select a Data Source' when I do this. I went through the steps for that and selected 'User' defined machine source and SQL db. It ran fine, I was able to make the query change. But when I replace the file name in my asp page and run it from the browser it says 'Server hasn't been opened'! I am assuming I have to set the same 'Server' criteria and connections as the report had earlier. How do I do this?? Is there anyway of altering the query without having to 'Select the Datasource' everytime??
Basically the report just needs a date range and runs fine through the browser. But when I go into the design mode and try to run it, besides asking me for parameters, it also brings up a window saying 'Select Data Source' and I have a choice between 'File' and 'Machine' data source. I need to get into the SQL query for this report to alter the 'Sort' criteria but it again asks me to 'Select a Data Source' when I do this. I went through the steps for that and selected 'User' defined machine source and SQL db. It ran fine, I was able to make the query change. But when I replace the file name in my asp page and run it from the browser it says 'Server hasn't been opened'! I am assuming I have to set the same 'Server' criteria and connections as the report had earlier. How do I do this?? Is there anyway of altering the query without having to 'Select the Datasource' everytime??