Last post Apr 04, 2012 07:12 AM by VJMS
Jun 08, 2010 03:57 AM|Namburi|LINK
I am working with SSRS reports .I have one report called AllOrderDails with Order_No, Order_Date, Project_Name, Boiler_Name, RefNo, Total_NoItems, Total_GrossWeight, Expected_Date .It shows all order Details ,when i click Order_No it shows another report
called OrderDetails.It shows only single Order_No details....In OrderDetails page i am using one textbox for back .It is for going back to AllOrderdetails.
My problem is when i click Order_No in AllOrderDetails page it's show OrderDetails page withrelated Order_No,when i click back it goes to AllOrderDetails Page but It's not displaying any data.....
Jun 14, 2010 03:44 AM|You-Hu Fu|LINK
Did you utilize the Action of “Jump to report” property for your purpose? If so, there is no need for you to add a textback to return to parent report, as the toolbar contains a back button in subreport, you can click the button to return. To your phenomena,
please make sure both of main report and subreport work fine and passing the right parameter to the subreport, you can test them separetly.
Jun 14, 2010 04:29 AM|Namburi|LINK
I utilized the action 'jump to report' ,in my parent report i have fromdate and todate parameters, in my child report i have OrderNo as parameter ,in AllOrderDatails page i used jump report for OrderNo same like in OrderDatails page for back ,OrderDetails
page i use back for return back to AllOrderDetails Page... It show me that page with Fromdate and Todate without data.
Jun 15, 2010 02:08 AM|You-Hu Fu|LINK
Based on your scenario, you can follow these points to solve the issue:
1. Do the parent report and child report work fine? you can test them seperately.
2. Does the parameters Fromdate and Todate in parent report have a default value? if not , it will display nothing besides the parameter drop-down list.
If possilbe you could post the detailed steps you created both of the reports, which will help us get a better undertanding about the problem, and give a proper solution. Thanks.
Jun 15, 2010 08:25 AM|Namburi|LINK
I did run my reports supperatly it's working well.
All Orders -parent report
SELECT Order_No, Order_Date, Project_Name, Boiler_Name, RefNo, Total_NoItems, Total_GrossWeight, Expected_Date
WHERE ( ( Submit_Status=1) AND (CONVERT(DATETIME, Order_Date, 103) BETWEEN convert (DATETIME,@FromDate,103) AND Convert (DATETIME,@ToDate,103) ) )
I set the property for OrdeNo jump to report OrderDetails Report when I click OrderNo
OrderDetails –child report
SELECT Order_No, Order_Date, Project_Name, Boiler_Name, RefNo, Total_NoItems, Total_GrossWeight, Remarks, Expected_Date
WHERE (Order_No = @Order_No)
SELECT Tt_LineItems.GRVNo, Tt_LineItems.SerialID, Tt_LineItems.ColloNo, Tt_LineItems.AI_Order, Tt_LineItems.AI_Pos, Tt_LineItems.AI_Package, Tt_LineItems.Quantity,
Tt_LineItems.Pakage_Type, Tt_LineItems.DescMat1, Tt_LineItems.DescMat2, Tt_LineItems.DescMat3, Tt_LineItems.DescMat4, Tt_LineItems.DescMat5,
Tt_LineItems.DescMat6, Tt_LineItems.DescMat7, Tt_LineItems.DescMat8, Tt_LineItems.HPE_Component_ItemNo, Tt_LineItems.Destination, Tt_LineItems.Length,
Tt_LineItems.Width, Tt_LineItems.Height, Tt_LineItems.Volume, Tt_LineItems.Net_Weight, Tt_LineItems.Gross_Weight
FROM Tt_LineItems INNER JOIN
Tt_GRVDetails ON Tt_LineItems.GRVNo = Tt_GRVDetails.GRVNo
WHERE (Tt_LineItems.Order_Status = 1) AND (Tt_LineItems.Order_No = @Order_No)
If I click ordeNo in AllOrders page it opens this page.
In OrderDatails page for back I use jump to report to AllOrders page .
If I click back it goes back but on data
Jun 15, 2010 08:26 AM|Namburi|LINK
I am trying to send my reportscreens but i am not abale to add.
Jun 15, 2010 10:29 PM|You-Hu Fu|LINK
If possible, send the report rdl and its relevant picture to me through email: sqltnsp
AT microsoft DOT com. To reproduce your issue, i hope you also can attach sample data for me in the mail and describe some details about the report. Once i recieve your email, i will give you a feedback as soon as possible.
Jun 18, 2010 06:53 AM|You-Hu Fu|LINK
I have already received your email; please allow me to ask this question again “Does the parameters Fromdate and Todate in parent report have a default value? If not, it will display nothing besides the parameter drop-down list, so you have to select the
parameters again to view the report.
If you have any question, please feel free to ask.
Jun 18, 2010 07:02 AM|Namburi|LINK
sorry i am not getting you, what is default value?explain me...
Jun 21, 2010 05:01 AM|You-Hu Fu|LINK
When you create the parameters FromDate, ToDate, you will see Default Values option in Report Parameters window. You could select Not-queried option, and type in the a default value for parameter such as:
2001-2-2, from your picture in the email, I find that you drag a textbox to add button back for returning, since there is a back button in ReportViewer control’s toolbar, why you add another button to achieve this? If you have no special purpose, I
would recommend you utilize the back button in the toolbar, then you can keep your main report without default value.
To the position of the back button, please see this picture:
If you have any question, please ask without any hesitation.
Jun 22, 2010 04:49 AM|Namburi|LINK
If i click back button you showed in picture ,it shows the AllOrders report but my PM ask me to do that in superate textbox.that's why i am trying .
Jun 22, 2010 05:55 AM|You-Hu Fu|LINK
Ok, maybe you have special requiremnt to add another button to return, have you solved the issue by giving a default value to the parameter? I wait for your feedback. Thanks.
Jun 22, 2010 06:11 AM|Namburi|LINK
Thanks for your response.
Still i am not getting ...
Jun 23, 2010 09:35 PM|You-Hu Fu|LINK
I am so sorry for not giving the detailed steps of getting parameter's default value.Open the Report Parameters window, to find out the Default Values property, and select No-Quetried option. Lastly, type in a default value for parameter. Just like below
Hope this post could helps you. If you have any question,please feel free to ask.
Jun 25, 2010 04:32 AM|Namburi|LINK
Sorry, that default value only for display in start date without selecting date .if we click preview it shows in textbox for startdate , why we want to select that one as a default value for my case.I am not getting you ,please let know if anything
Thanks in advance...
Jun 25, 2010 07:27 AM|You-Hu Fu|LINK
It is just a example to show you how to give a default value to parameter, without default value for the parameter you will get a blank page when you return from the subreport, of course, you can type in the expression =Today() to get today value or other
date rather than 2010-2-2. I hope you could understand this time. Thanks.
Apr 04, 2012 07:12 AM|VJMS|LINK