Forum

This content is now out of date.

Visit Our Community

Add filter values to repor URL that is access externally

Hi David,

We are trying to dynamic link to a report on a webpage, but at the moment the link given by a report is in this pattern;
http://localhost/RunReport.i4?Report=39265&Org=1&ClientOrg=1.

Is there any way to have the filter values embedded in the URL as well,
i.e.
http://localhost/RunReport.i4?Report=39265&Org=1&ClientOrg=1&filter1=value1&filter2=value2, etc.

Thanks.

Kind regards,
Stephen
Hi Stephen,

In Yellowfin 6.1, the share menu brings up a dialogue box with the report URL, this url will contain any filters used in the report (as long as you have applied the filter and then run the report);

E.g.
http://localhost/RunReport.i4?reportUUID=5341299b-db05-4bdd-bfcf-ca0a81f84252&primaryOrg=1&clientOrg=1&filter55957=Asia

Forum image


Please let me know if you have any issues with this.

Regards,
David
Thanks David. Can this be done on 5.2?
This cannot be done in 5.2, it will only be available in 6.1 + releases.

How add Embed filers to script in 6.1 version

Except result:
---------------


but
Actual result
-------------:
http://localhost/RunReport.i4?reportUUID=8f076e5e-d0be-4801-a83e-e551d3b23bae&primaryOrg=1&clientOrg=1&filter46910=1&filter46911=1
Hi,

What type of report are you using? It looks like your filter values are omitted?

Can you please provide information as to how your report has been built?
Screenshots of the report builder and report output would be very useful.

Thanks,
David

Thank for replay Divid
i am getting Report Url

http://localhost/RunReport.i4?reportUUID=8f076e5e-d0be-4801-a83e-e551d3b23bae&primaryOrg=1&clientOrg=1&filter46910=1&filter46911=1

in my jsp call report on dynamic filter values while loading
direct url calls ay jsp iframe getting header an dother jsp information

as this concept
in my jsp report include between div through passing dynamic filer values while loading report to embed script
like that

loading report through passing filers as dynamic values from action

Hi!
How to do

A web service call report using filer

i am giving
input values:
-------------
reportId ,filertvalue login credentials
output:
------
report data

where identifies list of services
Hi,

What type of report are you using? It looks like your filter values are omitted?

Can you please provide information as to how your report has been built?
Screenshots of the report builder and report output would be very useful.

Regards,
David
Using Iframe
------------

Reports Depends on filter
report builer screenshot attached

In webapplication iframe dynamically appends filter values and load report

web application screenshot attached

http://localhost/RunReport.i4?reportUUID=0b911f62-d28c-4ebd-a7ce-84dc010a50a9&primaryOrg=1&clientOrg=1&filter47039=42&filter47040=1

Using Webservice another using web service
-----------------------------------------
single signIn
http://localohost:8080/logon.i4?LoginWebserviceId=70b96a676907b4a3b31e90be7ffac82f
Getting reportList by following code
public void reportList() {
String host = "50.62.142.50";
int port = 8080;
String User = "ganapathi.pudi@asmansoft.com";
String Password = "admin";
String baseURL = "/services/";

ReportServiceClient rsc = null;
AdministrationServiceClient asc = null;

try {

// / SERVICE LOCATION

rsc = new ReportServiceClient(host, port, User, Password, baseURL
+ "ReportService");
asc = new AdministrationServiceClient(host, port, User, Password,
baseURL + "AdministrationService");

} catch (Exception e) {

e.printStackTrace();

}

AdministrationPerson ap = new AdministrationPerson();
ap.setUserId(User);
ap.setPassword(Password);

AdministrationReport[] reportlist = asc.listReportsForUser(ap);
<-- fail to get reports
for (int i = 0; i < reportlist.length; i++) {

AdministrationReport ar = reportlist[i];

i4Report report = rsc.loadReportForUser(ar.getExecutionObject(),
ap.getUserId(), ap.getPassword(), null);

if (report == null) {

System.out.println("
Error Loading Report ("
+ ar.getExecutionObject() + ")for user.");

} else {

System.out.println("

Report: "
+ report.getReportName() + " ("
+ report.getExecutionObject() + ")


");

System.out.println("Columns:
");

ReportSchema[] columns = rsc.getRs().getColumns();

for (int y = 0; y < columns.length; y++) {
System.out.println("
Column: " + y + ", "
+ columns[y].getColumnName()
+ " Data Type: " + columns[y].getDataType()
+ " Display Name: "
+ columns[y].getDisplayName());
}

System.out.println("

Filters:
");

for (int y = 0; y < report.getFilterColumns().length; y++) {
System.out
.println("
Filter: "
+ y
+ ", "
+ report.getFilterColumns()[y]
+ " Filter Type: "
+ report.getFilterType(report
.getFilterColumns()[y])
+ " Column Type: "
+ report.getColumnType(report
.getFilterColumns()[y]));
}
if (report.getFilterColumns().length == 0)
System.out.println("None");

}

}
}
Hi,

Thanks for the screenshots.

Since you are calling reports via web-services you will need to call the filters in your web-service calls.

More information on this can be found in the web service guide ,look under the 'ReportFilter object definition' section.
This guide can be downloaded via the following post :Integrating & Emdedding Yellowfin into a custom application or webpage - Overview (see option 3).

Regards,
David