Home » Forums » Reports & Documents

Can we create a conditional Freeform SQL

Thu, 2011-09-29 00:21

I would like to create a FreeForm SQL which based on prompt answer can use a different table in the FROM. For ex:

if the prompt answer is DAILY the select should look like SELECT a, b, c FROM A_DAILY WHERE ...
if the prompt answer is MONTHLY then the select should look like SELECT a, b, c FROM A_MONTHLY WHERE...

Any help is greatly appreciated.

Thanks,

I need to display week to date in report ›
  • Login or register to post comments
  • Share this
gj on Thu, 2011-09-29 16:53
Title: Currently I have created a

Currently I have created a Element prompt where user selects either Daily / Monthly. Is there a way I can pass this value to the Value prompt? I tried creating just the value prompt and it seems to be working. The risk here is if the user enters an incorrect value then the report will break. There is no way for us to validate the value entered.

thanks,

mike_s on Thu, 2011-09-29 03:16
Title: I know we can have a value

I know we can have a value prompt for the table name. What is the prompt which will allow users to select "Daily" or "Monthly"? Some how if we can pass a value to the value prompt which can be used in from cause, we might be good.