emmanuelpaul70 Posted June 25, 2010 Share Posted June 25, 2010 Hello,I am an absolute beginner in Jasper Server and i'm having the problemI have a report published on my JasperServer installationIt has the following input controlName = ParcelType = Multi-select query [/code]When I'm running my report from I-Reports or from my JasperServer portal, it runs succesffuly.The point is that i would like to run it using an url and pass the parameter in itHere is my parameter in the reportParcel, type = Java.util.CollectionDefault value expression : new ArrayList(Arrays.asList(new String[] {"ZK0040"}))[/code]Here is my query using this parameter :select a.id_parcel, b.nom_prop, b.adress from parcel a, prop bwhere a.id_parcel=b.id_parceland $X{IN,a.id_parcel,Parcel}order by b.nom_prop[/code]When i'm passing one value for the Parcel parameter, it runs succesfully : http://server:8080/jasperserver/flow.html?_flowId=viewReportFlow&ParentFolderUri=%2FDBASE%2FRapports&ndefined=&standAlone=true&reportUnit=%2FGEOPARCEL%2FRapports%2FConv&j_username=jasperadmin&j_password=jasperadmin&Parcel=ZN0202[/code]But I would like to pass several values for my Parcel parameter (ex : ZN0202, AB125, AA321)I tried that : http://server:8080/jasperserver/flow.html?_flowId=viewReportFlow&ParentFolderUri=%2FDBASE%2FRapports&ndefined=&standAlone=true&reportUnit=%2FGEOPARCEL%2FRapports%2FConv&j_username=jasperadmin&j_password=jasperadmin&Parcel=ZN0202&Parcel=ZN0203[/code]The result is that only my first value for parameter is used.I tried using these expressions :Parcel=ZN0202,ZN0203 Parcel=(ZN0202,ZN0203) Parcel=%28ZN0202%2CZN0203%29My report crashes.Does anybody have an idea?I'm using Jasper Server 3.7.0 under Windows 2003 R2 SP2 and I-Reports 3.7.3 Link to comment Share on other sites More sharing options...
lucianc Posted July 2, 2010 Share Posted July 2, 2010 Which JasperServer version are you using? &Parcel=ZN0202&Parcel=ZN0203 should work.Regards,Lucian Link to comment Share on other sites More sharing options...
emmanuelpaul70 Posted July 5, 2010 Author Share Posted July 5, 2010 Thanks Lucian for your answer.I'm using Jasper Server CE 3.7.0 and I-Reports 3.7.3 on Windows 2003 R2 SP2.I found a way to walk through my problem using a parameter defined as string and a single value input control (string type).I'm passing the parameter like this &Parcel=('ZN0202','ZN0203')I don't think it' the correct way but it seems to work fine.I woul prefer to pass the parameter the way I read it in Jasper Server user's guide as well as your explanation but it still doesn't work. Link to comment Share on other sites More sharing options...
lucianc Posted July 5, 2010 Share Posted July 5, 2010 emmanuelpaul70Wrote: I woul prefer to pass the parameter the way I read it in Jasper Server user's guide as well as your explanation but it still doesn't work. Log a bug for it. Include any information that could be used to reproduce the error.Regards,Lucian Link to comment Share on other sites More sharing options...
honeybakliwal Posted May 16, 2012 Share Posted May 16, 2012 hi emmanuelpaul70 Can u please explain this in detail how u came upto the solution 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