avernekar

I am trying to add the parameters to the Crosstab. And everytime i try to do so , I get this error- An error has occurred. See error log for more details. net.sf.jasperreports.crosstabs.design.JRDesignCrosstab cannot be cast to net.sf.jasperreports.engine.design.JRDesignDataset Can you suggest how to resolve this?

Where should I use that stored procedure?I certainly don't want to use as subdataset since I can't call it in page header.

Thats what I do. Its doable If i have one query to refer to. But I have reports where there are 12 parameters. In page header, I can't call the values from subdatasets. That's the part I dont like about Jaspersoft. There has to be some way to achieve this.

I have a report where i have configured input control using Single Select Query . select code,description from code_lookup where table_name ='folder_type' In this query, I have set up code as Value name and description as visible column Here is the sample data - code . description DMV . Domestic Violense HATE . hate crme If the user selects Domestic Violence, then I want to display in report header and not DMV. How can I achieve this? I have seen multiple solutions on this but none work.

I could add various lookup datasets . But i cant use them in the page header. I am in a transition phase from SSRS where you can call the values stored in any dataset from anywhere. I will give an example. Lets say I have parameter call type , folder type, crime type . The application sends me value for parameters not the corresponding labels. It is all stored in the database.

Hi all, I have bunch of reports designed for client. The requirement is I need to show all the parameters being passed in the header . The problem is the parameters sent by system are codes- like VA, CT etc. I want to show the values in the header. If nothing is being passed, then I should show " All records" . There are various datasets in some reports. I could add a lookup query in one report but I can only add one query. How can I resolve this?

Hello, How do I change the format of numbers or intervals of either x axis or y axis? I want to show only integers on the axis and not the decimals. I tried changing xaxis.allowdecimals and yaxisallowdecimals to false. But I have no luck. Can you please assist?

Thats looks time consuming. Question is will it overwrite the changes on the server or will it just create duplicate copy of reports? I was thinking feature similar to SSRS where the user can deploy reports right from the studio.

I am using Jaspersoftstudio 6.4.2. We have over 200 reports being built. The main problem is its pain to deploy each report to server one by one manually. Is there anyway we can push all the reports to server in one swoop instead of individual deployment?

Hello, I have a dashboard that I created in jasper studio. In one of my line charts, I have hyperlink configured . It looks like the parameter is being captured in hyperlink but the second report is not able to read the parameter. It gives me all the records instead of filtering based on parameter passed from main report. Here is what the hyperlink looks like http://localhost:8080/jasperserver-pro/flow.html?_flowId=viewReportFlow&_flowId=viewReportFlow&ParentFolderUri=%2Forganizations%2FLeedsDev1&reportUnit=%2Forganizations%2FLeedsDev1%2Frpt_lead_intake_period&standAlone=true?leaddate=2016-04-08%2016:36:30.703&Personnel_ID=1 I am passing the date and ID from main report to the second report which is just plain table. The second report isnt capturing the parameter being passed. Please help.

Hi, I have a line chart in my main report . I should be able to click on the values on line chart and drilldown to another tabular report. I have tried using reference method but i have no luck. "/jasperserver-pro/flow.html?_flowId=viewReportFlow&_flowId=viewReportFlow&ParentFolderUri=%2Forganizations%2FLeedsDev1&reportUnit=%2Forganizations%2FLeedsDev1%2Frpt_lead_intake_period&standAlone=true?leaddate=" + $F{TakenDate} + "&Personnel_ID=" + $P{Personnel_ID} + " " It takes me to the report but its not taking any parameters. Instead it brings up the parameter promt. How do I solve this?