Jump to Report Parameters - SQL Server Forums

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.

All Forums

Development Tools

Reporting Services Development

Jump to Report Parameters

Author

Topic

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-10-18 : 06:49:54

Hi guys I have two reports one is the main one which gives the hours a participant has put into an activity the other shows how they got the hours.
When I go to the main report and click on a participants last name and it takes me to the detailed report tha last name comes up but the date range doesnt. I'm not sure what I am doing wrong. the main report is in a matrix and the detailed report is in a table.

the Matrix is the main report when I enter in a data range (09/01/2009 and 09/30/2009) and then click on a participants last name which takes me to the detailed report this is what I get. those dates are not correct. but in the parameters in the @Enter_StudentLastName it says the correct last name but the date range says 9/03/09 to 09/03/09 but this is what shows up on the table.l can someone help this is an important report please

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-18 : 11:46:52

When you pass the report parms you need to make sure that from the matrix you have a field (or fields) that represents the date range that the detailed report should use. If you are using start and end date selection on the matrix with the date picker, when defining the date parameters to pass on the jump to, select the <Expression> and go select the Parameters. I am guessing you are selecting a Fields value instead of Parameter value to pass.

John

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-10-19 : 01:08:04

Yes I have that in the details section and I have last name there too. I put the parameters in the details but still not working when I click on the name it gives me the last name but not the correct date range

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-19 : 12:13:33

So I don't confuse things... Are you trying to pass a date selected as a parameter or a data element

John

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-10-19 : 12:24:18

I am trying to pass the last name along with the correct date range. So when you jump to the detailed report you see the persons last name along with the dates. IN the first report you choose the date range then if there is someone from that list that you would like to see how they got those hours for those dates, then yoiu click on that their name and they should come up along with the correct date range (the details of how they came to get those hours). So lets say you go to the first report and put a date range of 09/01/09 to 09/30/09 and yoiu choose the name Beltran from the list. Click on their name and it takes you to the details of how they got those hours. the problem is when the jump report happens you see their name but not the correct date range is showing in the table. I hope all that made sense

thanks for your help

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-19 : 12:34:43

OK, now in the first report you have something like Parameter!StartDate.value and Parameter!EndDate.value defined in report parameters?

If that is the case then on the navigation properties do you pass the values of Parameter!StartDate.value and Parameter!EndDate.value to the called report?

If you do, then I would guess that the called report is doing something to the passed dates. Do you have a simple text box in header that can display the values passed from the calling report?

John

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-10-19 : 12:51:45

here is the select statement of the first report

SELECT     People_tbl.[Parent ID], People_tbl.[Student Last Name], People_tbl.[Student First Name], TanfActivity_tbl.EventDate, TanfActivity_tbl.[Earned hours], 
                      TanfActivity_tbl.[Catagory for hours], TanfActivity_tbl.[State Catagory], TanfActivity_tbl.[Services Covered], TanfActivity_tbl.[State Services Covered], 
                      People_tbl.[Referral Date], People_tbl.ReferralStatus, People_tbl.Adult_Child, People_tbl.TANF
FROM         People_tbl INNER JOIN
                      TanfActivity_tbl ON People_tbl.[Parent ID] = TanfActivity_tbl.[Parent ID]
WHERE     (People_tbl.ReferralStatus = N'Active') AND (TanfActivity_tbl.EventDate BETWEEN @Beginning_EventDate AND @End_EventDate) AND 
                      (TanfActivity_tbl.[Earned hours] IS NOT NULL) AND (TanfActivity_tbl.[Catagory for hours] IN (N'ITP', N'Parenting', N'Education', N'Culture', 
                      N'Job Skills Training', N'Life Skills', N'Travel')) AND (People_tbl.Adult_Child = N'Adult') AND (People_tbl.TANF = N'Yes')
ORDER BY CASE WHEN TanfActivity_tbl.[Catagory for hours] = N'ITP' THEN 0 ELSE 1 END, 
                      CASE WHEN TanfActivity_tbl.[Catagory for hours] = N'Parenting' THEN 0 ELSE 1 END, 
                      CASE WHEN TanfActivity_tbl.[Catagory for hours] = N'Job Skills Training' THEN 0 ELSE 1 END, 
                      CASE WHEN TanfActivity_tbl.[Catagory for hours] = N'Culture' THEN 0 ELSE 1 END, 
                      CASE WHEN TanfActivity_tbl.[Catagory for hours] = N'Education' THEN 0 ELSE 1 END, 
                      CASE WHEN TanfActivity_tbl.[Catagory for hours] = N'Life Skills ' THEN 0 ELSE 1 END, People_tbl.[Student Last Name], People_tbl.[Student First Name]

here is the select statement from the details report

SELECT     TanfActivity_tbl.EventDate, TanfActivity_tbl.[Type of Contact], TanfActivity_tbl.[Purpose of Contact], TanfActivity_tbl.[Earned hours], 
                      TanfActivity_tbl.[Catagory for hours], People_tbl.[Parent ID], People_tbl.[Student First Name], People_tbl.[Student Last Name]
FROM         TanfActivity_tbl INNER JOIN
                      People_tbl ON TanfActivity_tbl.[Parent ID] = People_tbl.[Parent ID]
WHERE     (TanfActivity_tbl.EventDate BETWEEN @Beginning_EventDate AND @End_EventDate) OR
                      (People_tbl.[Student Last Name] = @Enter_Student_Last_Name)

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-19 : 13:07:05

Check your email... I can send a screen snapshot for report number 1 parameter

John

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-10-19 : 13:58:47

I checked it and there was nothing there my email address that I normally use is desireemm1@cox.net

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-19 : 14:12:14

You should have a screen snap of the "Jump To Report" parameter set up.

John