admin.vizexperts
Members-
Posts
18 -
Joined
-
Last visited
admin.vizexperts's Achievements
-
Dear All, I have to create a report having charts, tables, running text and subreports. i have to create table using json file. I have 4-5 json files. All are different. It might be possible that i have to add 1 json file 2 times or 3 times and the other one only 1 time. Not sure to add all json file also, but atleast one will be there. The same thing is with charting. For that also we have json/csv files. So can we add tables and charts at run time as per user requirement. I can do one thing that for every table and chart i can create a sub report. But in this case i need to add sub reports at run time. Same possibility is that 1 sub report can be add no of times or 0 time. Which subreport have to add it totally dependent at run time. I am calling jasper reports using REST API from Asp.Net Web application. Please provide me a solution for the same.
-
Hi all i have somehow solved the problem. I have added a property in my jrxml file: <property name="net.sf.jasperreports.json.source" value="http://localhost:port/jsonfilepath"/> In which i have passed remote JSON file url. by this report is working fine. Now, i want to change/pass this(my json file url) value from webapplication at run time. can i use a parameter field for this(if yes how), or there is something else what i am missing.
- 6 replies
-
- ireport designer
- datasource
- (and 4 more)
-
As a progress i have added a parameter for json file url, which is on remote server. After that i have deployed this report into jasperreport server without passing any datasource. Now i am passing the remote json file url to that parameter. It is showing blank report. I am trying to make it work like remote xml datasource. Guys help me to tell where i am doing wrong.
- 6 replies
-
- ireport designer
- datasource
- (and 4 more)
-
How to change DataSourceReference at run time using REST API
admin.vizexperts replied to admin.vizexperts's topic in Products
I am to parameterize the queryString, but not found any info for dataSourceReference. That we need to define at the time of deployment of report into jasperserver. In addition i have not added any datasource at the time of deployment. I have taken a parameter for datasource. From my web application I have passed the already added database(in jasperserver) reference to my xmlstring. But it is showing blank report.- 4 replies
-
- datasource
- jasperreports server
-
(and 2 more)
Tagged with:
-
How to change DataSourceReference at run time using REST API
admin.vizexperts replied to admin.vizexperts's topic in Products
Thanks hozawa for your prompt reply. I can do this, but our requirement is to call same template but with different data source as per requirement.- 4 replies
-
- datasource
- jasperreports server
-
(and 2 more)
Tagged with:
-
Hello All, I am beginner in jsasper reports. I have created a report using ireport 5.5.0 and deploy it in jasperserver 5.5.0. I am able to run from my web application using REST API. Now i have a requirement to chagne the datasource reference at run time. More specific: Currently i am using the PostgreSql as a database. There might be requirement that i need to use MySQL (at run time) having database with same name and schema. So, pleaes tell me how can i change the datasource reference using REST webservice. Thanks
- 4 replies
-
- datasource
- jasperreports server
-
(and 2 more)
Tagged with:
-
Hi Marianol, Now i am using the following call: string requestAllResult = httpClient.UploadString("http://localhost:8080/jasperserver/rest_v2/reports/reports/samples/testreport.pdf", requestXml); but it is showing me "(400) Bad Request."
- 8 replies
-
- apis
- jasperreports server
-
(and 2 more)
Tagged with:
-
Hello everyone, I am browsing the jasperserver sample report from my web application. There it is showing the report, but not displaying the charts. For chart it is showing the blank image. In browser console it is showing 404 error. It is taking reference from my webapp url like: http://localhost:4710/<Websitename>/Reports/images/img_0_6_0 and showing this 404 error It is because the file is not there and it is true. While i am browsing same report from jasperserver gui it is showing the report with charts. I am using the rest api. My code is: string fileName = "StandardChartsAegeanReport.html"; var responseValue = string.Empty; WebClient httpClient = new WebClient(); httpClient.Credentials = new NetworkCredential("jasperadmin", "jasperadmin"); httpClient.Headers.Add("Content-Type", "application/x-www-form-urlencoded"); // Build resourceDescriptor string requestXml = ""; requestXml = "<resourceDescriptor name="StandardChartsAegeanReport" wsType="reportUnit" uriString="/reports/samples/StandardChartsAegeanReport""; requestXml += " isNew="false">"; requestXml += "<dataSourceReference><uri>/datasources/JServerJNDIDS</uri></dataSourceReference>"; requestXml += "<resources>"; requestXml += "<resource>"; requestXml += "<fileReference>"; requestXml += "<uri>/reports/samples/StandardChartsAegeanReport_files/standardCharts.properties</uri>"; requestXml += "</fileReference>"; requestXml += "<name>standardCharts.properties</name>"; requestXml += "</resource>"; requestXml += "<resource>"; requestXml += "<fileReference>"; requestXml += "<uri>/reports/samples/StandardChartsAegeanReport_files/standardCharts_ro.properties</uri>"; requestXml += "</fileReference>"; requestXml += "<name>standardCharts_ro.properties</name>"; requestXml += "</resource>"; requestXml += "</resources>"; requestXml += "<jrxmlFileReference><uri>/reports/samples/StandardChartsAegeanReport_files/StandardChartsAegeanReport</uri></jrxmlFileReference>"; requestXml += "</resourceDescriptor>"; // Send PUT, the requestAllResult contains the above <report>... string requestAllResult = httpClient.UploadString("http://localhost:8080/jasperserver/rest/report/reports/samples/StandardChartsAegeanReport?RUN_OUTPUT_FORMAT=HTML", "PUT", requestXml); // Extract uuid and file System.Xml.XmlDocument doc = new System.Xml.XmlDocument(); doc.LoadXml(requestAllResult); XmlNode node = doc.DocumentElement.SelectSingleNode("uuid"); string uuid = node.InnerText; //Build GET URL 1ac3fabf-5d55-4e3c-b517-0ef538b7da27 string reportUrl = "http://localhost:8080/jasperserver/rest/report/"; reportUrl += uuid; reportUrl += "?file=report"; // Get session cookie string session = httpClient.ResponseHeaders.Get("Set-Cookie"); // Set session cookie httpClient.Headers.Add("Cookie", session); var reportdata = httpClient.DownloadData(reportUrl); string folder = Server.MapPath(Request.ApplicationPath + @"Reports" + fileName); System.IO.File.WriteAllBytes(folder, reportdata); Response.Redirect("Reports/" + fileName);Please suggest me how to retrieve charts from jasperreport using rest api. thanks
-
Hello Everyone, I am trying to generate a report using json file as datasource. I have successfully created the report and able to see the report with values from json file using iReport. Now i want to deploy this report to JasperServer. I know to deploy reports to jasperserver with other data source like with postgresql but not able to deploy this report to jasperserver with json datasource. I am using iReport 5.5.0 and Jasperserver 5.5.0. Please help me.
- 6 replies
-
- ireport designer
- datasource
- (and 4 more)