Search results for query: *

We have an application that runs on both Windows and on iSeries. We are using Crystal Reports to render our reports, and we always export them to PDF to display. When we render them on Windows, they look as expected. When we render them on iSeries, however, the fonts are arbitrarily...

I have a report where I am displaying an amount. It is formatted to 2 decimal places. However, the customer wants the negative amounts to show the minus sign on the right "sticking out" to the right of the number so that the decimal points are aligned. I have another report where they want...

I consolidated all of my data into a single table, and everything is coming up fine now. It does look like it was a one-to-many relationship problem, as I had two tables that interacted in a somewhat non-standard way. Once I put all the data into a single table, everything worked fine. Thanks...

Yes, all the fields are duplicated. And yes, there are 6 groups. I will do some messing around with my tables and see if it is a one-to-many relationship problem. Thanks for the tip! I will update when I have more info.

Hi, thanks for the post! I went and checked, and I did not. However, I checked it and saved, and it didn't appear to make any difference. The records still show correctly in the preview and 5 times each when running via the web application. I have checked the db table it is reading from as...

We have several reports in our web application, all of which go through the same java class to render the reports as PDF's in a web browser. One report is giving me trouble, however. It renders fine when I render it in crystal's preview mode. However, when I run the report in our app, I get 5...

Thank you SOOO much! That did the trick! :)

I have a somewhat complicated report where I need to sum sums, and CR does not seem to want to let me. Here is how it is set up: Group 1 = AARow Group 2 = Fund Details are not shown, as I only want to see totals for the fund. Depending on the value of the AARow and another field that is part of...

Guess I have another case of "post & solve".... Here's how I did it, for anyone searching in the future: Fields fields = (Fields)request.getAttribute("parameterList"); logger.debug("passed in param fields:"); for (int i = 0; i < fields.size(); i++) { ParameterField pf =...

I am trying to pass params to my report via a java servlet. It is exporting the report to a PDF. Everything works fine for "single" params, but when I try to pass params with multiple values, I am only getting the first one. Here is my code: Fields fields =...

I am trying to pass parameters to a report and export it to PDF. I am setting the parameters in the Fields object and then calling reportExportControl.setParameterFields(fields). The size of fields is 2. However, after setting, the size of reportExportControl.getParameterFields() is 0. The...

It is actually the X-axis that I am trying to format. The Y-axis has a tab for number that you can edit the number format, but the X-axis does not. I ended up making a formula that converts it to a string with 0 decimals and used that with a specified order instead of using the number. If...

This report renders fine if I use the ReportExportControl and render it as a PDF. Is the Crystal Reports viewer just that flaky that it randomly picks and chooses which reports it wants to render and which ones it doesn't?

I have determined that it is not possible to pass a parameter to a file, as Crystal Reports does not know what kind of file I am linking to, and files, as a general rule, don't take parameters. I have instead opted to use an internet location and serve up my next report using the ReportRenderer.

I have a chart in my report that shows data on change of month number. The field is a number. In the preview mode, it shows the way I want it to (i.e. 1 2 3, etc). However, when I view it on the web, served up with the ReportRenderer in java, the months display as 1.00 2.00 3.00, etc. I...

I have several reports that I have "linked" via hyperlinks to internet locations. I start with report 1. Depending on what was clicked, I pass that parameter to an action class (we are using Struts), which sends it to the ReportRenderer and serves up the next report. Report 2 comes up just...

Has anyone passed a parameter from one report to another - using a hyperlink off of a chart? It looks like it is possible, but BOBJ did not provide an example with their user guide. If so could you please post example syntax? I would like to pass the fund number from report A and open report B...

Thanks, I'll give it a try!

No; the only ones available in that one are Sum of BudgetRevenue.MonthAmt Sum of BudgetHistoricalRevenue.AveMonthAmt Sum of BudgetRevenue.AnnualBudget Sum of BudgetHistoricalRevenue.AveAnnualBudget

Here is the formula I would like to sort by: {@SumPercentVariance}-{@SumHistPctVariance} Here are those formulas: SumPercentVariance: If Sum ({BudgetRevenue.MonthAmt}, {BudgetRevenue.Element1Number}) =0 then 0 else if Sum ({BudgetRevenue.AnnualBudget}, {BudgetRevenue.Element1Number}) =0 then...