Displaying Virtual Field in Tabular Report

[TMCGINN1]

Hi,

I am attempting to use Virtual Fields to allow a user to specify some input that must appear on each line of a tabular report. The report requires the person who exports it to provide some contact information, and I do not want to hard-code this information.

I have set up a Virtual Field as a search field, and set it to "pass as parameter" called [@Virtual1]. In my report body, I would like to display the value of the Virtual Field variable. I have attempted to use a calculated field and just put [@Virtual1] as the value, but I get an "Error in forumla." when I attempt to run the report.  Per this post, I also tried [@cbParameterVirtual1] in a calculated field, but that results in the same error. I have tried a few Javascript solutions, but can't seem to find the right reference to the Virtual Field variable.

I can't seem to find a clear answer on how to reference virtual fields within the datapage they are created (or if it's even possible). I've posted some screenshots of my setup below, any help is greatly appreciated!

 

 

[cheonsa]

Hi @TMCGINN1,

You need to wrap the parameter in a single quote. For example '[@Virtual1]'. This way you will be able to use parameter in  SQL query. You can also use HTML Block instead. 

 

-LittleMsGinger

[TMCGINN1]

Thank you so much! That solved my issue! My calculated field is now just '[@Virtual1]' and it displays properly

[davblo]

On 1/19/2020 at 5:35 AM, LittleMsGinger said:

Hi @TMCGINN1,

You need to wrap the parameter in a single quote. For example '[@Virtual1]'. This way you will be able to use parameter in  SQL query. You can also use HTML Block instead. 

-LittleMsGinger

I've been struggling with the exact same problem for some time and just managed to find this solution.

Thanks LittleMsGinger!

I didn't see this need for single quotes documented anywhere - it seems very important!

/David