SQL File as source for report

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8611066662

January 17, 2008, 04:34 PM

Rao Casturi

SQL File as source for report

Hi,
I tried using a SQL file as my soure to generate a report.
I have define variables etc in the SQL file.
Can anyone help how to use SQL file?
It is more than 100 lines and has #tables.
Thanks,
Rao

7.6.1 I believe
All formats, HTML,PDF,EXCEL

January 17, 2008, 04:44 PM

FrankDutch

You can create a master based on the SQL view and then build some reports.

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

January 18, 2008, 09:11 AM

Jessica Bottone

If you've generated reports against other RDBMS data sources, then the process is the same. If this is your first report, you should get with your management and look into training.

Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows

January 18, 2008, 11:08 AM

PBrightwell

If you are extracting the data using a SQL passthru all you have to do is TABLE FILE SQLOUT and use the fieldnames defined in your SQL code

Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes