Drill Down Reports

fgudelj

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

geronimo

have you checked your printer selection table?

fgudelj

Yes I have and till cann't get drill down feature... :-(

clausl

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

navuser1

How to apply a filter ON a Integer DataItem ?