Print report name and path

  • Thread starter Thread starter dawn
  • Start date Start date
D

dawn

Hello,

How to I get the report name and path to print on each
page of the report in the page footer.

Thanks
 
For the report name, put this in the Control Source of a text box:
=[Report].Name

For path, did you mean the full name and path of the current database?
If so:
=dbEngine.Workspaces(0).Databases(0).Name
 
dawn said:
Hello,

How to I get the report name and path to print on each
page of the report in the page footer.

Thanks
Click to expand...

The page footer will print on each page (unless you specify otherwise),
so that part was easy.

Report name: have a textbox with controlsource
=me.name

What do you mean by report path?
 
yes

Thanks
-----Original Message-----
For the report name, put this in the Control Source of a text box:
=[Report].Name

For path, did you mean the full name and path of the current database?
If so:
=dbEngine.Workspaces(0).Databases(0).Name

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hello,

How to I get the report name and path to print on each
page of the report in the page footer.

Thanks
Click to expand...


.
Click to expand...
 
Dawn said:
The path would be something like
c:\databaseName\reportname
Click to expand...

Ah, that is in currentdb.name.

But! that is not the path of that specific report, of course, ar, that's
why you include the report name, right?

Maybe you want this too?

=[page] & " of " & [pages]
 
Back
Top