jcrozier

We often write .jrxml reports that we upload and run from a website called Oncore. I'd love to have a report that displays data that its getting through an API that connects to "Redcap". It seems like it should be possible but I'm struggling. I'll tell you what I've done so far: First I went down this rabbit hole in this article here: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/connecting-web-service-using-json-data-adapter Redcap has pretty good documentation about everything you'd put into a post command here on a page like this: but A- I didn't really know how to plug it in, I tried stuff like this and it didn't work: (just said 403 forbidden) And B- even if I created a data adapter.... we'd still be missing a piece. My understanding is that data adapter would just connect my pc running jaspersoft to the API, but the second I've uploaded the jrxml to our Oncore website, it wont be able to connect. So.... how do I tell my report that when its online, it'll query that API and download the necessary data? Did I explain that well?

@erikmarbad in relation to your answer, I dont see in the documentation how to prevent that grouping. I followed the documentation in order to figure out how to group at all. Please point me to where it discusses another way to fix this.

Turns out I could control it on the SQL end. If I ended the sql query with "order by department_name" it put them all together. Curious if it could have been controlled on the jasper side though

Hello, first time asking a question so hopefully I'm phrasing it all right/providing the right info, etc.. I have a report with a few hundred rows of studies. One of the pieces of information I have about each row (a column in the sql query) is department name. I'd like to create groups based on department_name so that I had a report like this: Cancer Department -One cancer department study -Another cancer department study -Another, etc.. etc... (i.e. all o the cancer department studies) Pediatric Department -Pediatric study 1 -Pediatric Study 2 -Pediatric Study 3 -etc,etc Instead I am getting Cancer Department -A cancer department study -Cancer study 2 Pediatric Department -Pediatric study 1 Cancer Department -Cancer study 3 Pediatric Department -Pediatric Study 2 -Pediatric Study 3 I.e. they're being organized under their correct department, but its being broken up a bunch of times for some reason. Any idea why? I could provide the jasper file if helpful.