Printing Report Execution Date and Time

[mstrNate]

Hi all,

Has anyone modified the printing capabilities of 7.2.2 so that in the CreateHeaderFooter.asp file one can have the option to print the time the report was executed? I mean when I'm printing from web, is there a way for me to bring up the print options page, go to the "Use Custom Settings" and click the "edit" link, and once in the "Header/Footer" editor page, I would like to create a button that allows me to add the report execution time to the header or footer.

For instance, MSTR out of the box does allow one to print the current date when printing a report in the header or footer, but I would like to print the date (and time) that the report was actually run on, which could have been a few days prior.

Any suggestions on what to try or where to look for answers?

Thanks,

Nate

 

[nlim]

the report execution date is part of the xml, that's why we can see it on the report grid itself...that leads me to think it should be easy to change the asp page to use report_execution date node of the xml...

so...if you find the report.asp code that generates the "Last Update" section, you can probably apply it to the createcustomheader.asp

Not the most helpful post, but a start hopefully.

 

[mstrNate]

Thanks for the tip nlim. It's better than I had (nothing). I'll start digging around there and let you know what I come up with.

Nate

 

[FLB]

Did you implement this? I am interested too!

Thanks,
FLB

 

[mstrNate]

Hi there,

I couldn't easily find how to modify the asp or xml to implement this. I'm not strong in the web programming arena. What I did end up doing was creating an attribute that grabs a system date -1 from the database (Oracle) when the report runs.

I called the attribute "Report Execution Date" and defined it as such:

ApplySimple("TO_CHAR(SYSDATE - 1,'MM/DD/YY')", [DAY_DT])

I mapped it to one table, a basic Time lookup table, and gave it a child of Day, which is the lowest attribute in our time dimension (hierarchy).

This is kind of crude, the opposite of elegant, but it sort of works, so ... let me know if you want to use that and it's not clear.

Nate