October 10, 2011 at 4:17 pm
Hi,
I am stuck with trying to configure the report and report parameters.
I have two files. One is clients and one is tutors. I have three parameters to to create. Subject, earliest date the tutor is qualified and the zip code of the tutor to match the zip code of the client.
The subject parameter should be A, B and C. I assigned name and prompt as subject. Not sure if that is correct. I also specified labels and values as A A, B B, C C.
For the earliest date qualified I created a dataset
Select MIN(datequalified) As DateQualified
From dbo.Tutors
Not sure how to create the dataset to match the client zip to the tutor zip.
I created a procedure to run the report
Alter Procedure TutorArea
@Zip varchar (50)
As
Select *
From TutorList.dbo.Tutors
Join dbo.CAZipCodes
On dbo.Tutors.Zip = dbo.CAZipCodes.Zip
Where dbo.Tutors.Zip = @Zip
When I view report with date and subject and earliest date it is still returning all fields of only the tutor table.
I hope this makes sense. I am so lost and any help would be greatly appreciated.
October 11, 2011 at 5:59 am
Does your stored procedure return what you are looking for? If yes, then it’s an issue that needs to be solved by SSRS guy (I am not the one ;-)).
Else please post your table DDLs, sample data and expected results here. We will try to help you.
October 11, 2011 at 8:25 pm
Hi Dev,
Thank you for answering! In SSMS the stored procedure returns the correct results it is just when I try to create a report from it in BIDS that I am not getting the correct results. I think the problem lies with trying to code the parameters and the datasets. I am very new to BIDS and having trouble trying to figure out how to configure it. I also can not get report manager to work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply