I'm getting an error when trying to do a drill down:

"The drilldown report Report Designer Add-In-GL Transactions 1-0 required to perform the drilldown doesn't exist"

I'm using Sage 50 US 2016.  I called Sage and they couldn't help me so I'm hoping someone here might have a solution.

Views: 204

Reply to This

Replies to This Discussion

Hi Ginny.

Import the attached report into the same folder as your Report Designer and give the drill down a try.

Attachments:

Peter,

Thank you so much!  It works like a charm now.

Hi, Peter. I am having this same issue but with Sage 100 v2018.  Will this file work for me, also? Where should I save it?

Thanks!

Hi Dawn.

It won't work.  Please tell me the name of the report you're trying to drill down from and the specific error message that you get.

It's a custom report I created for ABC company. I've attached the exported report.  I want to be able to drill down and see the transaction detail behind the PTD activity. The report executes but when I try to drill down on the PTD actual amount, I get this error.  I have confirmed that this file does exist in the Container.  Thanks!  

Attachments:

Dawn - How are you "Drilling" down on the PTD Amounts?

I ask because I imported your report and ran it with the ABC company. The report ran showing the PTD & YTD Values. I Right Click on cell F6 PTD Sales and the Drill down worked?

Attachments:

Interesting.  That must mean there is a problem with the install on my machine.  I did exactly the same thing as you and got the error that I provided. Great. Guess I'm doing some uninstall/reinstalls.  At least I know it works! Thanks Doug!!

Maybe try setting up a new shared SMI folder first.

When you setup a new empty folder and use the Change Metadata Repository and point to it the Report Manager will refresh all of the "canned" reports.

I'll give that a shot!

Attached is the file.  This file is usually a hidden file, so if you try the above you can try view it by showing hidden files.  Otherwise you can import this.

Attachments:

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service