Stored Procedure Remap failed, please help

[srkk]

Hi,

I always face the same problem. I am using CR9 with SQL2000. I developed a report using Stored Procedure (SP) using DB-1 then the same report will be map to 2nd database, DB-2. The SP is exactly the same. The different is just database name which change from DB-1 to DB-2.

I am not using any sub-report in my case. Just 1 report with 1 stored procedure.

And in DB-1, i have a user called "report" and i already make this user allow to EXECUTE that SP in both database. And this
"report" user have the same access permission for both database.

When I re-map the report from DB-1 to DB-2, CR9 keep on asking me to map the field, but the problem is, I unable to see any fields from new database.

Please help...

edm

 

[synapsevampire]

Test by creating a quick new report and pointing to the new SP, if it doesn't see fields, then it would appear that something is amiss with the SP or permissioning.

If it's during a remap (Using Database->Set Location), then during the map fields screen make sure you turn off the match types field, perhaps there's some subtle difference encountered.

-k

 

[srkk]

Hi synapsevampire,

If I create new report using this SP then no problem, i can see all field.

When i map, i take turn off the match type field as well, but still didn't see any field there.

I always face this same problem whenever i need to remap my CR to another database.

edm