Is there a way to have a UserID added to the report filename (the html file) that is generated when a report is run?

Most of my reports are run via command buttons, and all the reports that I would need this for are done this way.

Here is the code I am using for my "Monthly Billed" button:

// Prints the expanded Monthly Billing report for this month

Var vPrintTheReport as string

IF NOT @Mode() = 0
THEN
	{
	vPrintTheReport = @PrintAReport(".     Monthly Billed, this month", REPORT_MODE_HTML_PREVIEW, PRINT_ORIENTATION_PORTRAIT, 0, -1, -1, -1, -1, -1, -1)
	}
ELSE @MSGBOX("Reports can only be run in Update mode", "Please switch to Update and", "select the records you wish to run the report on.") 

Looking at the book, page 330, it seems like I would have to do something with vFilename, but I'm not sure what.  Thanks for your help Erika.

Hmmm.  OK.  All I need is a simple Rename command.  My @PrintAReport code creates the filename as vPrintTheReport, and in Global code I've set a static variable sUserID = @UserID.  So the command would be something like

REN F:\Sesame\Reports\vPrintTheReport vPrintTheReport+"_"+sUserID 

I don't think CreateAProcess is the way to go, probably @Shell.  I'm not sure how I can wrap the quotes into it, though.  OK, so maybe use another variable that adds them.  So I've got:

var vUnderline as string
vUnderline = "_" 

So then it becomes

REN F:\Sesame\Reports\vPrintTheReport vPrintTheReport+vUnderline+sUserID 

Would this work?

var vRenameTheFile as Int

vRenameTheFile = @Shell("REN F:\Sesame\Reports\vPrintTheReport vPrintTheReport+vUnderline+sUserID") 

I'll give it a try.  In the meantime, if you see something glaringly wrong please hit me with a clue-by-four.  Thanks!

D'oh!

Trying this:

// Prints the Over 30 Days by Customer report

Var vPrintTheReport as string

// Testing file rename procedure
Var vUnderline as String
var vRenameTheFile as Int
// Testing

IF NOT @Mode() = 0
THEN
	{
	vPrintTheReport = @PrintAReport(". Over 30 Days, sorted by Customer", REPORT_MODE_HTML_PREVIEW, PRINT_ORIENTATION_PORTRAIT, 0, -1, -1, -1, -1, -1, -1)
	}
ELSE @MSGBOX("This Report can only be run in Update mode",
		"Please switch to Search/Update and try again",
		"")

// Testing file rename procedure
vUnderline = "_"

vRenameTheFile = @Shell("REN F:\Sesame\Reports\vPrintTheReport F:\Sesame\Reports\sUserID+vUnderline+vPrintTheReport")
//Testing
 

The command box flashes by pretty quickly, but I think it's telling me "cannot find file specified".

Erika,

That works like a champ!  I'm going to have to study it for a while to understand what you've done, dissecting the filename and all that, but thank you so much!

My next goal is to make it a subroutine.  WOO HOO!

Would using CreateAProcess instead of @Shell eliminate the flash of the command window?

Nope, still flashes, but that's OK as it's very quick.  I can live with it, and I'll go back to using @Shell.

It's resisting my attempts at a functioning subroutine, however.  I think it has something to do with the variables.  Still working on it.

Yep.  Thanks for your help.  I'm going to work on the subroutine some more tomorrow.  If I can get it to work I'll tag it onto all my report-generating buttons.

Infinity wrote on Feb 5^th, 2008 at 2:38pm:

Not without seeing what you've got. Can you show me the code?