Focal Point
Unique identifier for reports

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4671099802

January 23, 2007, 12:46 AM
sathyanveshi
Unique identifier for reports
Hi,

Are the report hrefs the unique identifiers for the reports?

When I look into the properties of a report, I could see the filename app/test.fex

Apart from this, is there any other unique identifiers for the reports ...something like a Report Id?

If so, how can we access them and use them?\


Cheers,
Mohan
January 23, 2007, 05:09 AM
Tony A
Mohan,

You are refering to MRE type reports. How do you intend to use the reference? To execute the report? If so then you need to build your URL to include several other IB specific variables, such as IBIMR_fex, IBIMR_domain, IBIMR_action, IBIMR_subaction, IBIMR_folder.

For a fex that is held in a standard reports group -

IBIMR_fex is the report (fex) "href"
IBIMR_domain is the "href" of the domain within which the program resides
IBIMR_action = MR_RUN_FEX
IBIMR_subaction = MR_STD_REPORT
IBIMR_folder is the "href" of the reporting group "virtual" folder

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 23, 2007, 09:31 AM
<JJI>
Hi Mohan,
Yes, to my knowledge the href is the unique identifier within the domain.
Can you please tell us a bit more on what you're trying to do?
Drill down on MRE reports or calling a MRE report from a custom html page,...etc?

If Drill down is your thing then don't worry. You can use the Dev. Studio or you can manualy code your drill down. In DS you can make your drill down ,within the mre,the same way you make your drill down in the projects folder. Or you can code it yourself:

Here is an example that I used in MRE to drill down from one MRE standard report to another:

In your stylesheet put the following:

TYPE=DATA,
COLUMN=N1,
FOCEXEC=app/gt015d.fex(Entity=N1 Departement=&Dept.QUOTEDSTRING);

where
COLUMN = The name or the id of the column you want the drill down to execute from.
FOCEXEC= Is the fex or procedure you want to execute if the hyperlink is clicked. gt015d.fex is the uniqe name of the procedure and not necessarily the name of the report that you see in your domains. To find the reale name of the report, just rightclick it and choose properties from the menu.


Hope this helps,

Dirk JJI
January 24, 2007, 11:36 AM
sathyanveshi
Hi,

Thanks for the responses.

Every report that is being created should go into this consolidated table for some audit reasons.

We would like to store the report names and its unique identifiers in a database table. There are other items which go into this table and they have their own ids.

Hence, for consistency reasons, I was looking whether the WF MR reports too have any unique identifiers besides the href.

Cheers,
Mohan
January 24, 2007, 02:00 PM
RichH
Hi Mohan,
Check on the reporting server console under Procedures -> Reports -> Impact Analysis
There are reports that can be run against the application directories that offer a breakdown
which you may find useful for audit purposes...
Rich


WebFOCUS 8202 Win 2012
Test - WebFOCUS 8203 on Win 2012