can anyone help us by providing one sample report on the same
Hi good morning,
Thanks for your reply, but the problem is still there am not able to open this report its giving error.
Can you send a another sample report. And explain the steps, how you create that report, what are all the SQL queries needs to create that report. Will wait for your positive response.
Error snapshot that am getting while opening system availability report. :
What type of report are you looking for?
Such as :
NOTE: Report should be for all servers.(How to create these many reports by using MSSQL queries.)
Is it the SQL query or the report creation in iReport (or Jasperstudio) that is a problem?
In attachment a iReport example to produce a availability report for previous month. This is based on the qos view: V_QOS_NET_CONNECT.
Sorry, I posted a jrxml file compiled with Jasperstudio.
Here is the original .jasper file that you can use in both iReport and Jasperstudio.
Sorry again same problem not able to open or run the report.
error msg while running the report. :
Is there anyone that can help me to sort this issue.
just help me with suitable guideline , i want to create a disk utilization report of 5 server in iReport, an using MSSQL database, just suggest how can i create and what are all the SQL queries that are required to create this report.
And can anyone share a sample report on the same.
In the error screen that you included you also have:
If you use here the icon: you will receive:
From there you can copy the sql statements and use them in SQL Enterprise, and copy a modified version back if needed.
Did you use the sql procedure to create qos views? (see: QOS_Views MS SQL script (Feb 2016) )
Because the sql in this report uses V_QOS_NET_CONNECT.
Retrieving data ...