Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to pass group key value to a SQL statement
Andrew, using parameter is not a solution. There is a master SQL statement that drives a number of grouped reports, say reports by months, such as Jan, Feb and so on. So month here is the group key. Within one month group I added a section with its own data source. The "where" clause...- jrcai
- Post #3
- Forum: Actuate Reporting Solutions
-
How to pass group key value to a SQL statement
Anyone knows how to pass getGroupKey() value to a SQL statement under the group. I tried this in Function ObtainSelectStatement() As String: ObtainSelectStatement = "SELECT order from orders where order_date = '" & getGroupKey() & "'" where getGroupKey() is date type. I got...- jrcai
- Thread
- Replies: 2
- Forum: Actuate Reporting Solutions
