I’m looking to change a tablename in a free-hand SQL report when the user runs the query. I’ve tried @variable and @prompt but it doesn’t like it because I have it in the FROM clause and not the WHERE clause.
The user has the ability to create a temporary table and that can be used in the query, therefore we are looking to prompt them for the tablename when they run it since it could change daily.
Any ideas?
Teradata
BO 4.1.5
Thanks,
Shawn Leven
Southwestern Bell Telephone
SBC Communications SL7699@SBC.COM
I’m looking to change a tablename in a free-hand SQL report when the user
runs the query.
You could do with a script - programatically change the DataProvider’s SQL string. Before refreshing it. You could put the script in the document’s Document_BeforeRefresh or Document_Open event.
How to save / print the universe parameters to another file extension (such as PDF) ?
**** PROBLEM ****
In the Designer module, you can use File - Print and print the definition of the universe to your printer.
This is done according to the options that have been set in the menu Tools - Options - Print tab
*** RESOLUTION ****
If you install Acrobat Distiller on your machine then in the list of printers, you can select “Acrobat distiller” and you will produce a .PDF file this way
Try to use the @prompt function, but define the data type of the prompt result to be ‘N’ (numeric) which
will fool busobj into not generating single quotes around the text you enter.
E.g.: @prompt(‘Table?’,‘N’,{‘XXX_1’,‘XXX_2’},constrained) as the table name should allow the user to select between the two tables ‘XXX_1’ and ‘XXX_2’
hopw this helps
Walter
“LEVEN, SHAWN L (SBCSI)” wrote:
Listers:
I’m looking to change a tablename in a free-hand SQL report when the user runs the query. I’ve tried @variable and @prompt but it doesn’t like it because I have it in the FROM clause and not the WHERE clause.
The user has the ability to create a temporary table and that can be used in the query, therefore we are looking to prompt them for the tablename when they run it since it could change daily.
Any ideas?
Teradata
BO 4.1.5
Thanks,
Shawn Leven
Southwestern Bell Telephone
SBC Communications SL7699@SBC.COM
–
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-450 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at