ReportServer Forum

wonky

Member

Registered: 2016-03-01

Report Configuration via URL

We are trying to execute reports like this : http://reportserverurl/reportserver/reportserver/httpauthexport?id=1234&user=asc&apikey=x2ex&format=pdf&download=false&p_1=1&p_2=2&p_3=3

I would like to allow users the freedom to filter or sort any field as they wish.  Using JRXML, we can parse the field list and the data types in order to populate the appropriate controls, so don't worry about that.

Is there ANY workaround to being able to pass an arbitrary query via the URL?  Possibly, including sorting and grouping?

I am actually considering that we might construct the query, and create a new report or report variant by writing the modified JRXML back to the database, then execute that.

At http://community.jaspersoft.com/wiki/ja … y-tutorial - "There are two flavours of the fill methods in this façade class. Some receive a java.sql.Connection object as the third parameter, and the others receive a JRDataSource object instead."  and "Sometimes is useful to use parameters to dynamically modify portions of the SQL query or to pass the entire SQL query as a parameter to the report filling routines. In such a case, the syntax differs a little, like in the following example: SELECT * FROM Orders ORDER BY $P!{OrderByClause}" - suggest that there is hope for more freeform report configuration.

Last edited by wonky (2017-02-08 14:29:03)