Drill Down Reports

fgudeljfgudelj Member Posts: 29
edited 2014-08-27 in NAV Three Tier
Hello everyody..
I have problem with Drill-Down reports.

I have created drill down report which calls another report through sum field - Trial balance > GL Account Card Trial Balance Report.
And have some rather strange problem. When i try to test this report on Demo database (Cronus) my report runs as it should, but when i try to run it on my PROD database then when I try to call drill down report (GL Account Card Trial Balance Report) NAV sends something to printer - problably this report.. I just cann't get it to show in window... And when I try to export it and import it back to Cronus it works well :(((

I've exported all relevant reports and imported them into PROD, but same problem :((

Here's jump to URL string from VisualStudio.. Maybe it's problem in it:

=Iif(Fields!G_L_Account_Totaling.Value = "",
"",
"DynamicsNAV:////runreport?report=4&Filter=G/L Account.%22No.%22:"+Fields!G_L_Account_Totaling.Value+"&Filter=G/L Account.%22Date Filter%22:"+Fields!RecDate__Period_Filter.Value)


Please help!!

Best regards,

Filip
Filip Gudelj | Dynamics NAV Consultant | http://bsinsight.wordpress.com/

Comments

  • geronimogeronimo Member Posts: 90
    have you checked your printer selection table?
  • fgudeljfgudelj Member Posts: 29
    Yes I have and till cann't get drill down feature... :-(
    Filip Gudelj | Dynamics NAV Consultant | http://bsinsight.wordpress.com/
  • clauslclausl Member Posts: 455
    Try to take this value an copy into a new textbox on your report:
    =Iif(Fields!G_L_Account_Totaling.Value = "",
    "",
    "DynamicsNAV:////runreport?report=4&Filter=G/L Account.%22No.%22:"+Fields!G_L_Account_Totaling.Value+"&Filter=G/L Account.%22Date Filter%22:"+Fields!RecDate__Period_Filter.Value)
    
    Then save, compile and run report.

    Now the value(url) in your new textbox is this correct? If yes try to run it from "Start / Run"

    /Claus
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • navuser1navuser1 Member Posts: 1,329
    How to apply a filter ON a Integer DataItem ?
    Now or Never
Sign In or Register to comment.