Galileo Posted April 25 Share Posted April 25 Hello. Can I use several SQL queries in one report? In "Dataset and Query Dialog" only one. Link to comment Share on other sites More sharing options...
Tom C Posted April 25 Share Posted April 25 Yes. You can use sub dataset to run difference query from the main query in the report. Please refer to: Link to comment Share on other sites More sharing options...
shreekrishna.shankhwar Posted April 26 Share Posted April 26 You can create a sub report , Tables and Cross tab to Utilize those Subset 🙂 Link to comment Share on other sites More sharing options...
Galileo Posted April 26 Author Share Posted April 26 How can I binding between the main dataset object with the subdataset parameter? Link to comment Share on other sites More sharing options...
Galileo Posted April 26 Author Share Posted April 26 How can I binding between the main dataset parameter with the subdataset parameter? Link to comment Share on other sites More sharing options...
shreekrishna.shankhwar Posted April 26 Share Posted April 26 Its Called Parameter Mapping. 5 hours ago, Galileo said: How can I binding between the main dataset parameter with the subdataset parameter? Its Called Parameter Mapping. You can pass the parameter. Link to comment Share on other sites More sharing options...
shreekrishna.shankhwar Posted April 26 Share Posted April 26 Link to comment Share on other sites More sharing options...
shreekrishna.shankhwar Posted April 26 Share Posted April 26 https://www.youtube.com/watch?v=BbOLecOfaGM This Video link explain you main data set and Sub data set Link to comment Share on other sites More sharing options...
Solution Galileo Posted April 29 Author Solution Share Posted April 29 Thank you! Link to comment Share on other sites More sharing options...
Galileo Posted April 30 Author Share Posted April 30 But I have another problem. I want to create a query with a parameter. I must set this parameter manually. Thus, it must be prompted. However, only parameters from the main dataset can be prompted. SELECT ts, innenraumtemperatur, temp_verdampfer FROM `BUR_PDA`.`Galileo-PDA_York_Froster`.ts > $P{Von1} Link to comment Share on other sites More sharing options...
shreekrishna.shankhwar Posted April 30 Share Posted April 30 Only Main Dataset Parameter are Prompted thus you have to make all the parameter to main dataset then you can map to sub dataset required parameter . Link to comment Share on other sites More sharing options...
Galileo Posted May 2 Author Share Posted May 2 How can I map to subdataset them? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now