ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Parmetrized SQL Report

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
naseer78 Posted - 11/05/2009 : 22:56:56
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
1   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 11/06/2009 : 10:14:00
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.



ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page