vipatil

Hello, I have created a sample report to fetch few columns using the query SELECT * FROM dbo.XYZ WHERE RetailerID = $P{Attribute_RetailerID} I have created a server attribute as RetailerID on jasperserver and when I execute the report, I just get a blank sheet. Please help.

Hi, I have created a simple report on jasper studio which has 3 columns. Select a,b,c from dbo.[XYZ] where B= $P{Attribute_B} I have created paramter Attibute_B on main and table data set level and also have defined it on jasper server. But when I publish and run the report on Jasper server, the report gives me a blank output. Could not understand what am I missing here

The link that you have shared is about scheduling a report in simple recurrence and calender. I am choosing to run the report with an option "Immediately". But when I do that the report remains in the scheduled list and the State is "Normal" and not "Executing" help needed to understand what is wrong

The link that you have shared is about scheduling a report in simple recurrence and calender. I am choosing to run the report with an option "Immediately". But when I do that the report remains in the scheduled list and the State is "Normal" and not "Executing"

Hello, I am using 6.3.1 Jasper server. I tried the scheduling of one report which is published on jasperserver using Jasper studio. It continues to remain in normal state, and the status does not refresh apart from the time. I chose to ran the report immediately. what can be the reason for the same.

Hello Mariano, I have been through the article you have shared. I am stuck in the part where I have to edit the query. I have created a report out of MSSQL store procedure by the follwing way; [reporting].[xyzproc] $P{param1},$P{param2}, $P{param3} --This is a way of calling store proc in Studio Now the article you have shared, asks us to use $X{IN,dbfieldName,CascadingParameter}, I am not able to understand how do I edit the [reporting].[xyzproc] $P{param1},$P{param2}, $P{param3} and use the multilist parameter

@Hozawa Thanks for the reply. I am aware that in the preview mode, there is a feature to allow parameters to be entered. But what do I have to do if I have I want to select specific value from the parameter selected. For example, If the parameter in preview mode is City, and I need a drop down list for that parameter where I could select the cities I want from the list.

In JasperStudio, there is an option of Repository Explorer under which you could find a section of servers. Create a new server and put the details like the JasperServer url and your user credentials and check by testing the connetion. If the connection has passed, Goto design window and you could find an icon option before setting to publish the report to the JasperServer. Let me know if this helps

In JasperStudio, there is an option of Repository Explorer under which you could find a section of servers. Create a new server and put the details like the JasperServer url and your user credentials and check by testing the connetion. If the connection has passed, Goto design window and you could find an icon option before setting to publish the report to the JasperServer. Let me know if this helps.

Hello, I have created a report in Jasper Studio by using a store procedure which is created in MSSQL. The report has been created by passing the query and parameters in DataSet and Query Dialog box. For example; [reporting].[xyzproc] 'UniqueIndentifier, $x, $y, $z $x and $y are ReportStartDate and ReportEndDate while for $z I have made it hardcode that is I pass NULL, it will select the by default values under it. What I want to achieve is when I hit the preview button, I want the user to select StartDate and EndDate which is actually happening already, but I also want now that $z should be drop down list and the user must be able to select the values in the list so that they get a filetered data for which they want the report. Looking for a solution or reference to achieve it.

I have created a report using Jaspersoft studio using the sql store proc. The reports runs fine, but whne I download it in .csv format it throws an extra blank column after the first column. What would be the reason for the same?