Jump to content
We've recently updated our Privacy Statement, available here ×

sjoerd.jump

Members
  • Posts

    74
  • Joined

  • Last visited

sjoerd.jump's Achievements

  1. For your calculation question, yes thats possible. Add a Measure to Measures in your Crosstab. Adjust the width of the column you want to add the "totalMeasure" too. Add a textfield and link your new Variable. To set up the variable, add a variable in your report. Do the calculations $V{Var1}+$V{Var2} Only if you set Groovy as language of your report (in the property sheet) Otherwise, depending by the value of your variables, you should use something like: new Double( $V{Var1}.doubleValue() + $V{Var2}.doubleValue() ) Where Var are the columns from your database. This should do the trick! Regards, Sjoerd link to the calculation answer:
  2. Why not change your variable that is passed from jaspersoft to String (or the variable in Java to BigDecimal)? It's my experience that thats a major problem causer :-)
  3. Bulk data: You can use the main dataset for the bulk of your data. For your charts: Navigate to "Report Inspector" -> Right click on you report and "Add Dataset" This dataset you can use to fill your charts based on another source.
  4. BTW, i use PHP to generate my report-links. I store the last bit in a database and generate them using the following code: define('URL_BASE', 'http://traject-pc:8080/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=');[/code] $final_url = URL_BASE . $link;[/code] $link = $line['link'];$name = $line['naam'];$click = LINK_ONCLICK;$final_url = URL_BASE . $link;{echo "tt<td>$name</td><td><a target="report"href="$final_url"$click">$name</a></td>n";[/code]
  5. It seems that Excel is destroying your link, according to a Windows forumpost. I would try to backtrack the error using jasperserver debug, although i'm not sure if the log shows what URL is being send to the server. http://answers.microsoft.com/en-us/office/forum/office_2003-excel/hyperlink-does-not-resolve-correctly/188c9cb0-bf88-4495-ae27-6d18b3df11e8
  6. Hi Camilio I use the following link to my reports: http://traject-pc:8080/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=%2Freports%2Fmy_report The bold text is different from your URL. Hope this helps!
  7. Let me put it this way :) I have 2 crosstabs in 2 reports in report 1 crosstab the height is fixed to 150 px. So i know where to place crosstab 2 (+150px) In report 2 crosstab 1 is 175 pixels. So placing crosstab 2 @ + 150 px will print the lines over each other. Thats what i'm struggeling with :-)
  8. hmm, thats too bad :) I have in different reports the same crosstab, but not every cross tab has the same amounth of rows. So the layout of report 1 wont work on report 2 :(
  9. Working on a set of reports I notced thats its not possible to adjust the height of a crosstab Dynamicly. i have to generate a bunch of different reports but all with the same number of crosstabs. But not al these crosstabs have the same number of lines. To improve the reports' maintainability i would like to adjust the height of the crosstab dynamicly. The following does NOT work: Paste a Variable into the height field: Paste the variable into the xml. <reportElement uuid="xxx" x="0" y="600" width="1703" height="<![CDATA[$F{ct_1}]]>" /> anyone has an idea?
  10. You might try to create a Parameter with variable expresssion $V{value1+2} then, in your query select * from table where var1 = $P{parameter1} This you export to jasperserver.
  11. Hi, can you be more specfic? For instance, is your report dependent on a datasource (like a database) or are there Parameters involved?
×
×
  • Create New...