matthew.kellar
-
Posts
6 -
Joined
-
Last visited
matthew.kellar's Achievements
-
Aggregate Date / First Value / Multiple Values per Field
matthew.kellar replied to zgadson's topic in Products
Hi there, This should really be done in the SQL of the report to make the most sense. If you're able to edit the SQL, try implementing something like this: SELECT order_id, update_date FROM <table> WHERE (order_id, update_date) IN ( SELECT order_id, max(update_date) FROM <table> GROUP BY order_id ) This is a very simplified example, but the same principles should be easily applied to your case. -
Hello world, I need to somehow schedule a report multiple times using the jobs service, but I only want to make a single REST call. I'm trying to find out how to create multiple schedules while decreasing the load on the server that multiple REST calls would make. Any ideas? Thanks!
-
Separate PDFs for each report group element
matthew.kellar replied to matthew.kellar's topic in Products
@hozawa, thank you for the response, but it looks like that link is unrelated, do you have another link? -
Hello there! Ok, so I've got a tricky one. I've got a report that has multiple subreports. Each one of those subreports contains a report group that puts each data element onto a new page, then the master report compiles all of those into a single PDF. I need a way to instead generate a separate PDF file for each record, while still only making 1 rest call. I also need to be able to dynamically change the PDF names to match the data element value. Any ideas?
-
Job is not creating on JasperReportServer using REST call
matthew.kellar replied to mcgovardhan's topic in Products
Hi there, Based on the documentation about the Jobs service, the rest call should be made using the PUT method. -
Thank you for the responses. I ended up using a similar approach that reportdev suggested. Instead of using an ArrayList parameter, I just used a SQL query to find the parameter values I was looking for and passed those to a subreport in a report group to split them up. I couldn't get them all on separate PDFs though, they're all in one.
