Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2010-07-02 : 10:48:47
|
| I have this one report that I created that is using a store procedure. This is what I have in the dataset quer propertiesEXEC P_Historic_TaxID_Report @bottomdate, @topdate, @claimTypesEverything works, but my drop down for @claimsType, when I generate the report. I can only choose 'HCFA' and 'UB' separate on together.I tested the query and it does work, but when I go to generate the report in the preview tab it gives me an error.Query execute failed for dataset dsIMPACT. Must declare the scalar variable @claimsType.Do you happen to have any links I can research or any type of suggestion for me? I tried everything that I can think of.Thanks. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-06 : 09:24:50
|
in report manager under selected dataset just type the name of stored procedure! and be sure to set command type to StoredProcedure (not to Text).in your case: P_Historic_TaxID_Report all input parameters will be automatically read by report. besided that you must have resolved this issue on storedprocedure level. |
 |
|
|
|
|
|
Visual Studio dataset problem