Running two REPORT.dics for users to select from

(0) Share

Report

Posted on by Community Member

We currently have two Report.dics located in our shared network resource location.

Reports.dic is the standard dictionary and the other is called Reports_HATB.dic which points to a specially modified HATB report that has all header level detail removed so that detail only is exhibited.

In our current environment we publish DGP through Citrix. On our Citrix server for DGP we have two shortcuts that point the the respective set files which are mapped to either the Reports .dic or the Reports_HATB. I am now being asked about having both reports within one DGP session.

IS this possible? Is there any risk?

I have seen that I can import the REPORTS_HATB however then I am setting the report to use a modfied form which will nto work as the users also need the unmodified version. Is there a workaround or any other way for the users to run a true HATB report? We are currently working through our TEST upgrade of DGP 2016R2.

Thank you

Mark

*This post is locked for comments

All responses (4)

Answers (0)

Tim W 2,925 on at

Like (1)

Report

RE: Running two REPORT.dics for users to select from

I know the SSRS report exists at least, how well (or if) it works I just don't know. We use SSRS for some controlled reporting but tend not to have our users in it too much. For me, it's a bit of a pain to administer the security effectively.

I see it on the list:

But I am concerned that I don't see the Age of Date as a parameter even though it clearly calls itself 'Aged'. Hopefully someone in the Community has experience with this report.

I built the Dex program a while ago for a GP10 instance at a prior stop. I have it running now as part of our custom logic on 2015R2. It wasn't so much because of the Excel feature as much as it was the need for a couple additional fields on the report from third party tables. Our prior solution was much like yours, drop the HATB report headers and footers and push it to CSV, then team needed to V-lookup other data to complete aging. AP saw it, got enthused and so I have AP and AR HATB's going to Excel.

Challenging from a Dex standpoint but can be done, you need to reverse engineer the GP stored procedure calls, understand how to use and reference GP created temp tables in your scripts and build a dump to Excel. One of my favorite projects ever.

Slowish... but faster than HATB to Report Writer.
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Running two REPORT.dics for users to select from

I agree with Tim,

this sounds like a little condandrum (is that right ?) .. as you want the users to be able to access either version of the HATB (regular & modified version).. you're going to have a hard time doing this, unless using a different GP login to assign a different Modifier Reports & Forms security. You could keep only one shortcut on your Citrix to start with the REPORTS_HATB.DIC, but that doesn't resolve the issue with the alternate version.

On the other hand there is also the SSRS option too..
Community Member on at

Like (0)

Report

RE: Running two REPORT.dics for users to select from

I would try SSRS if that in fact worked. What is the custom Dexterity program you use, who developed it, that sounds pretty slick.
Tim W 2,925 on at

Like (1)

Report

RE: Running two REPORT.dics for users to select from

No elegant solution that I know of to your request. If you have not (sound like you have though) modified the original HATB then you could control it through having two Alternate Modified Forms/Reports profiles but you'd have to switch between them and seems easier to just have the two login shortcuts instead. If you have modified the report twice then you can't have both in the same dictionary so that itself wont work.

Wanted to respond because you might be able to use the SSRS reports as I think that does have a HATB, someone here can confirm if that's an option and if it works. I see it in the report list but have never evaluated it. We use a custom Dexterity program that runs the HATB logic and dumps the results directly to Excel so I've never spent time on the SSRS report. Might be worth checking out though.