Change datasource location

[shaunhubbs]

Hi all,

I am using CR9 and am trying to copy a report, but make it change the datasource location. The new datasource has the exact same information with the exact same column names as the first, just the SQL statement is using an extra UNION statement to bring in more information.

So I go to Set Datasource Location and swap the old for the new and then close. Then when I run the report I get 0 records in the bottom corner and obviously no info on the page. When I run the SQL query right on the server I get the number of rows that I am expecting, but for some reason cannot get anything in CR. Also, I tried, rather than swapping datasource locations, creating a new report based on the datasource just to see if I could get a barebones report that I could reformat and again got 0 records.

TIA for any help.

- Shaun

 

[Madawc]

Take a look at your record selection? Maybe cancel out your existing selections and take a look at the raw data? I've had that problem when I switch datasource locations.

Failing that, check the SQL query, which you should find under [Database]. Post it here and see if anyone notices something useful.

Madawc Williams (East Anglia, UK)

 

[shaunhubbs]

Actually, I did find the problem Madawc and it was the SQL query. I guess when running it as a raw query I was getting away with a date type mismatch as it was being ignored there, but with CR9 I was not so lucky and it would return no records. I just had to simply convert the inputted parameter date to a different format and use that in my record selection as the parameter was requesting just a date, but in the record selection was trying to use a datetime.

Thanks for the help though. Sometimes just putting the problem out there helps me solve it for myself.

- Shaun

 

[Madawc]

Thanks for taking the trouble to explain (and also leaving it there for someone maybe to benefit from). We had something similar, a complex selection that 8.5 let us get away with but a higher version interpreted more strictly.

Madawc Williams (East Anglia, UK)