Portlight Posted July 19, 2011 Share Posted July 19, 2011 I have a report that I need to be able to utlilize by creating a side by side output but using two different time frames - any ideas?Right now I pass a startdate and an enddate - I am wondering if I could create a startdate2 and enddate2 as variables to populate a dataset? Link to comment Share on other sites More sharing options...
phantastes Posted July 19, 2011 Share Posted July 19, 2011 Yes you could create another set of parametes for the second daterange. You could either go with two different datasets, with for example the table element, or use subreports and pass the parameters to thouse.Magnus Link to comment Share on other sites More sharing options...
Portlight Posted July 19, 2011 Author Share Posted July 19, 2011 do you have a sample of how this is being done - it would use the same procedure but just different dates and i think that is where my confusion is coming in. Link to comment Share on other sites More sharing options...
phantastes Posted July 19, 2011 Share Posted July 19, 2011 Take a look at attached file. This one uses two table and two datasets. The parameters are being passed from main parameters to parameters in dataset. You will need to declare parameters in the datasets to receive the passed in params. You pass in the parameters in the table. The same goes for other types such as graphs. Subreports will function in a similar way only you do not create another dataset in the main report but rather use the query in the subreport.Hope that helps.Magnus Link to comment Share on other sites More sharing options...
Portlight Posted July 19, 2011 Author Share Posted July 19, 2011 actually it does help quite a bit - the part that is confusing me is HOW do I set up the second dataset and use the params passed in the main dataset....is it possible to provide a couple screen shots with this....I know it is asking a lot but I am a bit above my comfort level here! Link to comment Share on other sites More sharing options...
Portlight Posted July 19, 2011 Author Share Posted July 19, 2011 Okay, I have the dataset added by using the create empty datasource - but what i really need is to use the same stored procedure that is used in the main report....is that possible - seems like everytime i try to add the stored procedure as the query it hangs up. Link to comment Share on other sites More sharing options...
phantastes Posted July 19, 2011 Share Posted July 19, 2011 Hmm,try this:Make sure you have the connection set in the table. Right click table, edit table datasource, use connection expression. Link to comment Share on other sites More sharing options...
Portlight Posted July 20, 2011 Author Share Posted July 20, 2011 Do you know if there is any further documentation on this feature - I can activate it and it seems to allow me to use the new params but would ike to learn a little more about this. Link to comment Share on other sites More sharing options...
phantastes Posted July 20, 2011 Share Posted July 20, 2011 You could always take a look at iReport Ultimate Guide. Other than that, google is your friend. Link to comment Share on other sites More sharing options...
Portlight Posted July 20, 2011 Author Share Posted July 20, 2011 lol. yep true that! 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