Grabbing Report field in Macro 1

[FossRock]

I am trying to grab a value from the BO report to use as the filename that I am saving my report under. For example if the report had a field called "invoice number" with a value of 11111 then my file would be 11111.pdf. I have everything but the command that returns the value of a field.

 

[Sridharan]

If Invoice Number is a variable in the report catch hold off that Variable using the Macro and use it for saving the file appropriately.

Sri

 

[FossRock]

I am using a macro. I need to be able to grab the values of specific fields to use in the macro to save the report as.

 

[Subhashab]

Are you displaying details of only one invoice number in the report. in that case i would suggest you make a variable max_invoicenumber with the following formula
=max(Invoice Number)

then in the macro

dim var as DocumentVariable

var = ActitiveDocument.DocumentVariable.item.value

in your case n is the variable number in the report. To find this number go to the add variable dialog box and count from the top to bottom until u reach your variable.

this will give the value inside the variable