Creating a Link from a Report to a Page

redrose

Dear all,

As iam a beginner i don't know how to make a report Drilldown like Field drill down in Forms.

My requirement is to display the Customer Balance and it should show a drill down so that it goes to the corresponding Ledger Entry.Is it possible? if then how to do this? Please help, i dont know much about this..



Thanks & Regards
Rose

clausl

First result on http://Bing.com gives you a link to a walkthrough, when searching for "Creating a Link from a Report to a Page", so maybe you are using another search engine. :whistle:

http://msdn.microsoft.com/en-us/library/dd983812.aspx

Regards,
Claus

Marije_Brummel

Sure, Microsoft cannot influence Google...

Hey Claus, nothing happened yet?

redrose

Thanks a lot Claus

I will try that.
One mre thing i want to know in nav 2009....Please guide me through Charts in the Reports. I didn't have any idea about that


Thanks & regards
Rose

jversusj

I am new to .rdlc and have been working through the walk-throughs. I have some issues with the walkthrough on this very topic.

http://msdn.microsoft.com/en-us/library/dd301304.aspx

1. There is no report 111 in my NAV2009 R2 nor NAV2013 installs. The closest there is 10062. When I view the layout of 10062 in VS, there is no textbox with value=Fields!Customer_Name.Value. The body section is displaying the TopName value from the integer data item in NAV.

2. I make all the changes they suggest, making assumptions as to how it applies given the facts in point 1. I try to link TopName to the Page in NAV and save layout. I return to NAV report designer reload the layout, then I attempt to compile the object and I get an error:

---

Microsoft Dynamics NAV Classic

---

Error while validating RDL content:
The Hyperlink expression for the textbox ‘TopName_i_’ refers to the field ‘FORMAT_CustomerRecRef_RECORDID_0_10_’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

---

OK

---

Clearly, I am doing something wrong. For those that have completed this walk-through, did you have report 111? What report did you use?

Note, I also tried to create a hyperlink from a more direct report (Customer List) that has no Integer data item (thinking that the TopName text box was the problem above), following the steps in the walkthrough. I added the link to the Customer.Name Value textbox and eventually wound up with the same problem in NAV - I cannot compile the report without getting the error about the report item expressions only referring to fields within the current data set scope.

Any hints?

Edit: i am trying this in 2009R2, my license does not let me design in 2013, yet.

postsaurav

Hi jversusj,

I also tried to do it and was able to do it.

Please read the details from the link below and let me know if you have any issues.

http://saurav-nav.blogspot.in/2012/10/hyper-link-to-page-from-report.html

jversusj

thank you for the link, i'm going through it now.

postsaurav

let me know if u have any issues, will resolve them tomorrow for sure.

jversusj

postsaurav,

I gave up on trying the MSDN walkthrough and tried your blog example.

There is no report 1001 in my database, just as there is no report 111. I am using the US version of 2009R2. I attempted your exercise using the closest "Inventory Valuation" report I can find, ID 10139 in my db. I had to substitute ILE for VE in this example. I was successful in linking the page to the report.

One thing i noticed, is that you defined a DataSetFieldName, which was never mentioned in the MSDN walkthrough, which I revisited after success above. When i define this property on my report control, and adjust the URL string in the VS Layout from:

="dynamicsnav:////runpage?page=21&mode=edit&bookmark="+Fields!FORMAT_CustomerRecRef_RECORDID_0_10_.Value

to

="dynamicsnav:////runpage?page=21&mode=edit&bookmark="+FORMAT(Fields!Customer_Rec_Ref_Val.Value)

I can now compile the report in NAV and execute the report. Thank you!

Has anyone followed the MSDN article exactly, and experienced the expected results?