Getting the system date in the Header of a report using Bex query designer

[Former Member]

Hi friends,

We have a Requirement as follows:

| Completed date : <report run date> | Field 1 | Field 2 | Field 3 | KF1 | KF2 |

Here field 1, 2 3 are some rows and KF1 and 2 are columns.

So in the header we need to get the report run date every time the report is run.

We do not need the report run date against every record, but only in the header.

Kindly suggest how do we proceed with this requirement. Please also suggest some walk around if any.

Thanks in advance.

Rahul

Edited by: RahulM on Feb 25, 2010 8:23 PM

[Former Member · Accepted solution]

Hi,

try this: in bex menu, use add text element -> select all. you will get a row with last refresh date and time, this is the run date and time you need.

hope it helps.

[Former Member · Accepted solution]

Hi,

I would suggest that you display the runtime in your Query Description which is shown at the top of the report.

For example something like

Report Header [RunDate: 24-Feb-2010]

To make this happen, navigate to your Query Properties and for the Description use the text variable from the available ones. There is one for date there. Alternately you can also create your own text variable.

Regards

Anujit Ghosh

[Former Member · Accepted solution]

@ Anujit - Nice suggestion, but we do not want to deal with change of description, the client is very specific about the name.

can u suggest some other walk around?

@ Anass - I did not quite understand your suggestion, can you please elaborate a bit?

Thanks.

Rahul

[Former Member · Accepted solution]

Hi Rahul,

here is a link that give more details about text elements.

[http://help.sap.com/saphelp_nw04/Helpdata/EN/9f/4e9d39d44cd45ee10000000a11402f/frameset.htm|http://help.sap.com/saphelp_nw04/Helpdata/EN/9f/4e9d39d44cd45ee10000000a11402f/frameset.htm]

[Former Member · Accepted solution]

It's recommened to use Workbook in that case where you have more control on Formatting and use customised header?

Alternately use WAD.

Regards

Anujit Ghosh

[Former Member · Accepted solution]

Hi Anujit,

We added a text variable in the description of the report since that was the only reasonable solution using query designer.

Thanks,

rahul