markwilliamson101

Hi, Just wondering can one switch or choose the JDBC datasource a report uses to generate data based on query params? I have a use case where one single report template is requried, but coud point at several datasources. I would like to be able to do the report without having to make several copies of the same template hardcoded to use a speciific data source. Best, Mark

So the accpeted answer does work, just beware trying to use it for multiple columns of diffeent data types. You many have to do parsing etc. Have to investiagte more.

Hi, So I got a Report working utilising parameters. Said parameters are used in the reports sql query e.g SELECT * FROM table WHERE paramter_column = $P{url_parameter1} Now, does anyone know if it is possible to also utilise a paramter in subsitute of a hard coded sql query column in the form of paramter_column. E.g SELECT * FROM table WHERE $P{url_parameter1} = $P{url_parameter2} Would make the report I am trying to make a alot more dynamic and adapatable, one template to suit multiple report types instead of having several report tamplates hard coded. So far when i try the above, the report throws an error. Any help appreciated. best, Mark

Ok so discovered the name of the file is not needed in the url. From Jasper Server, when you navigate to reports, then right click report to get its properties, there it wil show the path e.g /reports/folder/ReportName I just use this as the end of the url e.g http://localhost:8080/jasperserver/rest_v2/reports/reports/folder/ReportName If you now want said report back in PDF or CSV just add that extension.... http://localhost:8080/jasperserver/rest_v2/reports/reports/folder/ReportName.pdf URL Query Params also work, these have to be created both as parameters in the report, which are used in the SQL query, and also taken in as a Controls & Resources input control params on the server side. You can do this by editing the report within the server,

Hi All, Based on a previous questions anser, I created a report in Jaspersoft Studio and uploaded it to the server. I can see the report and report data now which is a great start for me. However, I am trying to test the REST API now but I am only getting a repsonse "resource not found". WIthin the server I can see on the left menu a folder called Reports, just above the themes folder. In Reports, I can see my sample report, called Simple_Blue. And when I created the report in Jaspersoft Studio, I named the file main_jrxml. So when I was trying to test the REST call, in the hope of getting the data back in pdf or csv I tried adding said extension to the end of the url, like... http://localhost:8080/jasperserver/rest_v2/reports/reports/simple_blue/main_jrxml.pdf However, I can not get it to work. I also tried http://localhost:8080/jasperserver/rest_v2/reports/simple_blue/main_jrxml.pdf dropping one of the reports arguments. Does the REST API work in the community edition? If so, can the REST API return back the reports content in various forms or files? Also, if that is possible could the report page itself as well as the REST calls be set up with configurable authentication, date filters or optional paramaters. Ultimatley I would like to make a REST call passing in start dates and end dates along with a optional param and get back a file such as a csv or pdf. Any help appreciated. Best, Mark

Hi All, Hope all are well. Just looking for some help. So I installed jasperreports-server-cp-6.3.0 on Mac OSX. I used teh default options of embedded Tomcat and postgresql. It launches up fine and I can log into the admin panel where I can create users etc. Looking at the server user guide, there should be a menu item called create beside the manage button. The create button should offer.... Ad Hoc View – Launches the Ad Hoc Editor for designing views interactively. Report – Launches the Create Report dialog for creating a report based on an Ad Hoc view and a report template. Dashboard – Launches the Dashboard Designer for laying out multiple reports with input controls, labels, and images. Domain – Launches the Domain Designer for setting up a Domain. Data Source – Launches the New Data Source page for specifying the attributes of the new data source. However, this option is not there. There is no button. Just wonder is this correct, or can it be added? I am trying to configure JasperServer to connect to my local postgresql application DB so I can query tables, data and build reports etc. Then to use REST to do report download in CSV and or PDF or even asynchonously build a PDF and have it emailed to me. Any help or guidance appreciated. Thanks. Mark