Export does not include drilldown report

Replies to This Discussion

Permalink Reply by Stephen Coull on October 27, 2010 at 1:26pm

Peter, this is not currently supporetd in Alchemex or powered by Alchemex products.

So you will need to ensure that any drill down reports that are associated with a report, get exported separately and alos get imported into the target system.

ALl union reports get exported as part of the parent report, so need to worry about that.

Hope this helps!

• ▶ Reply

Permalink Reply by Peter Kipps on October 28, 2010 at 6:36am

Many thanks Stephen.
One small point.
This solution may be mass distributed and hopefully we won't have to do customisation on each site.
The drildown tool references the required drilldown report identified by the report number.
This number is unchanged in the drilldown tool after export and import on another site.
The exported exported drilldown report will (I presume) import and keep the same number?
Any idea what happens if that report number already exists on the client's machine?

• ▶ Reply

Permalink Reply by Glynnis on October 29, 2010 at 10:07am

Hi Peter

When setting up the drilldown using the drilldown tool, one should not use the report id as a reference in the "Report ID/Code" section as this will vary on each users system. It is advisable to use a Report code. This is set up on the report in the Report Manager and remains constant. Hope this helps you.

• ▶ Reply

Permalink Reply by Peter Kipps on November 3, 2010 at 2:24am

Thanks Glynnis. This has resolved the problem.

One other connected matter. Am I correct is saying that the report used to show the drilldown transactions can not itself be a union report? I tried a union of 2 reports (running into the same sheet) but on drilling down it produced 2 separate workbooks.

• ▶ Reply

Permalink Reply by Allison Wigman on December 18, 2011 at 10:20am

Hi Stephen, Glynnis,

Can you please tell me how to get the report code?  Some reports seem to have them and others don't?  Unfortunately our drill down report does not have a code next to it, just an ID and for the reasons below we would want to use the report code not report ID.  Any suggestions would be much appreciated to save a lot of time.

• ▶ Reply

Permalink Reply by Glynnis on December 20, 2011 at 10:12am

Hi Allison

I'm not quite sure if you are needing assistance adding the report code in the Report Manager or in the actual Drill Down Definition.  I've attached a short, informal document that I hope will assist you in what you are trying to achieve.  The document explains how to add the report code to the report in the Report Manager and then to add the code in the Drill Down Definition.

Hope this helps

Regards

Glynnis

 

Attachments:

• Adding a Report code to a report and using the code in a drill down report.doc, 79 KB

• ▶ Reply

Permalink Reply by Allison Wigman on January 20, 2012 at 6:43am

Hi Glynnis,

Thank you for your reply.  Just a quick tip - the report code is not visible in Alchemex 7SR under normal installation.  To enable this you need to go to the Alchemex.ini file and change the ShowReportCode from 0 to 1 and this enables you to see the Report Code field in the advance section.

Full credit to Chris Milllar for finding this out! :o)

Cheers

Allsion

• ▶ Reply