This is a general question to see if I'm missing something obvious before I start digging in depth. I'm new to SSRS and I wouldn't necessarily know where to start digging without help.
My problem is that when I a run report in SSRS it returns one row of data but when I run the associated proc in SQL Server 2008 it returns two rows. I've run Alter Proc every time I've made a change, I've refreshed the fields on SSRS and refreshed the report every time I've run it. The parameters in the report are identical to those in proc but still I'm still only getting one row.
Is there anything else I can check to solve this? If there is any more information I can provide to make answering easier please ask and I'll post it as soon as I can.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher How to post a question to get the most help