Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Parmetrized SQL Report		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

naseer78

Pakistan
19 Posts
Posted - 11/05/2009 :  22:56:56  Show Profile  Reply with Quote
Hello!

I developed Action URL in which I called SQL Report.
I want to passed parameter from OLAP action to SQL Report. How I defined variable or variables in SQL Report, they received value or values from OLAP URL Action.
And these variable or variables are used in WHERE CLAUSE IN SQL QUERY.

without Parameters SQL Report working fine

Thanks in Advance for helping

admin

1637 Posts
Posted - 11/06/2009 :  10:14:00  Show Profile  Reply with Quote
Please take a look at this tutorial: http://www.reportportal.com/Flash/sql.html

Documentation: http://www.reportportal.com/help/sql/filterUse.htm

Usage reports provide a good example. Go to Admin > Settings > Log Usage > Create Reports to create them.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page