August 30, 2013 at 4:34 am
Guys,
I've got a very simple data set which is just 'SELECT * FROM tblA WHERE a.ID = @ID'
Where @ID is a parameter in the report.
If I right click the data set and hit query, I can successfully run it and enter 1,2,3 etc and data is returned as I expect.
If I preview the report and enter these values (just typing them in) one works (1) but the others 2,3,4 etc deliver no data.
It makes no difference if I set the parameter to take values I hard code, to take them from a data set I create or to allow me to just type them straight in. Also doesn't help if I delete and add the parameter again.
Does anyone know how I can troubleshoot this? - Almost like the equivalent of SQL Profiler where it shows what the report is trying to do or something?
I can create anotehr report which has 'SELECT * FROM tblA WHERE ID = 4' and this delivers the expected results, it's just the parameters which are playing up
Any help much appreciated, it seems so simple I'm not sure what could be up.
August 30, 2013 at 5:50 am
Right, so I *can* use profiler for this, guess what, it's identical in all three cases except for hte ID!
exec sp_executesql N'SELECT * FROM tbla
WHERE ID = @ID',N'@ID int',@ID=4
Running what the profiler is creating in Management Studio works just fine, it does deliver results, so, why doesn't the flipping report eh? I'm out of ideas for now, boo!
August 30, 2013 at 7:12 am
It's kind of a shot in the dark, but check to see if you have a filter on your tablix in the report.
August 30, 2013 at 7:36 am
With such a simple report I decided to make it again, it does have 8 subscriptions against it, which still seem to be there after deleting it and deploying a report with the same name, I'm slightly suspicious about this aspect so I'll see what happens on Monday when they're due to send (still test, not production yet).
It really foxed me, I sort of wanted to solve it as if it was a more complex report it would have been really irritating, in the end I didn't have time so I created a new one.
Cheers for the suggestion - alas, no filters on the tablix, but not something I'd have thought!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply