amit.barkai Posted May 8, 2013 Share Posted May 8, 2013 I tried without any success so far to understand to IReport logic i have a stored procedure with 2 parameters , all i want is to display the procedurte result in a simple tablei am using IReport 5.0.0 with sql server 2008 R2can somone tell me what am i doing wronge1. i create 2 parameters ( the procedure paramters) on the report2.create 2 parameters for the procedure dataset 3.create a table object and conected it to the dataset3.edit the table dataset =>go to the parameters tab and mapped the report parameters to the dataset paramers 4.complied the reportwhile tring to generate the report the user is asked to enter the parametersand noting happen ( the procedure is not executed at all)thanks Link to comment Share on other sites More sharing options...
aseel.bahaziq Posted May 8, 2013 Share Posted May 8, 2013 I've had this hassle before till I gave up on Stored Procedures. The way I'm doing it now is to call the procedure from java and create JavaBeans, then use the JavaBeans to populate the report. Link to comment Share on other sites More sharing options...
aseel.bahaziq Posted May 8, 2013 Share Posted May 8, 2013 . Link to comment Share on other sites More sharing options...
amit.barkai Posted May 8, 2013 Author Share Posted May 8, 2013 the only way i could generate a report is with single query meaning there is only one dataset ( create from the report query) drag the wanted fields to the report ( or chart in my case) and then the report could be generated another wired problem is when i created a report with parameters and upload the report to the server i still had to manually add the reports parameters (contorls) to the report 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