Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
How to pass SQL queries to simple Birt Report
RSP
Hi All,
Please guide me.I am using Birt 2.2.1,and i want to insert a SQl queries to simple Report .Please give me the steps,how i can i do that.
Thanks,
Sam
Find more posts tagged with
Comments
mwilliams
Hi Sam,
Can you explain a little more about what you're trying to do? Are you just wanting to know how to run a simple query and place the results in a report? Or something different? Let me know.
RSP
Hi Michael,
I want to pass simple query and place results in report.and the values should be dynamic comes to report by taking one column report parameter and i want values should be dynamic by using ? in query .
Thanks,
Sam.
SailRCG
Sam,
Are you saying that you'd like to create parameter which takes a query? and pass the values of the parameter (in this case a query) into the report to effect the base query used by the report?
mwilliams
Sam,
Here's a simple report that uses a parameter dataSet to dynamically display all the customers for the user to choose from, then their choice limits the report dataSet by use of a ? in the query. Is this what you're trying to do?