Regarding date reflecting from main report to child report.
Hi, I have summary report and Detail report.In Summary report, I have filters like Date from and date to and same filter for Detail report also. so when i have given the particular dates in summary report , i will get the data for that and in the summary report when i click the say particular customer id,it will take to detail report and displays only those records for that customer id but the dates that have given in the summary should reflect in the detail .how should i do...can anyone resolve this issue.
February 28th, 2011 5:20pm

Hi Aravind, Create the same FromDate and ToDate parameters in SubReport and when you add the Detail Report in the Summary Report pass the FromDate and ToDate values from Summary Report to Detail Report. In Detail Report you can add the FromDate and ToDate in query like where dateField>=@FromDate and DateField<@ToDate. In Sub Report properties, select Parameters and add FromDate and ToDate.Nanda
Free Windows Admin Tool Kit Click here and download it now
March 1st, 2011 12:57am

Hi Arvind, Here is the simple solution for this request. Take a text box on sub report ,Right click on it than go to Properties >Navigation>Jump To URL : Then write the following code: ="javascript:void(window.open('http://melexhweb02/Reportserver?%2fJQReports%2fFrontline+Voucher+Summary+Weekly+Activity+Status+SubReport" & "&DateFrom=" & Parameters!DateFrom.Value.ToString & "&DateTo=" & Parameters!DateTo.Value.ToString & "&rs:Command=Render&rc:Toolbar=True&rc:Parameters=False',null,'height=500,width=1200,resizable=yes'))" So I think this will really help you. Note : in the statement ="javascript:void(window.open('http://melexhweb02/Reportserver?%2fJQReports%2fFrontline+Voucher+Summary+Weekly+Activity+Status+SubReport" you will required to change the proper link of that sub report- which you can fetch from report server and also parameter name if you have another parameter name.I simply means by this code is that it will be basic criteria for this request.Let me know if this helps you or not. Have a good day! Cheers!! Sumit
March 1st, 2011 6:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics