Search results for query: *

I am not sure if I can accomplish this with CR, given the way the table is structured but... Group 1 | Group 2 | Group Value 1 | Group Value 2 ---------------------------------------------------- A | B | 15 | 20 B | A | 60 | 80 I...

I created a report in CR 11.5 a year ago and it looks perfect when i export it to RTF and bring it up in Word 2010. We have just recently upgraded to CR 2011, and when I export the same report Word has a hard time interpreting it. In addition it is placing random page breaks throughout the...

I am going to simplify my problem so its easier to understand... I have details section a and b. My section A is just a solid horizontal line, my section b is a record. I am trying to suppress the solid line unless its first record on the page and fieldA = "first". I have created: @counter...

I have created a line graph that has 7 values in it, but whenever I add more than the 4 values, I can not select the connecting line and change the color. Any ways around this? I am using CR XI vr. 2.

I am trying to get a value vertically aligned within a crosstab. I am using this formula in the Display String formula under format field: replicatestring(chr(13),1) + cstr(currentfieldvalue) This works fine when the value is a string, but when it is a number its is returning ######### Any ideas?

I posted this in the Other Topics with no answer so I was hoping it may get answered here because it would save me a ton of time! Hypothetically, lets assume I have 3 fields: Date1, String1, Value1. I am grouping by String1, and I have an area graph that is showing: On change of: Date 1Show...

Hypothetically, lets assume I have 3 fields: Date1, String1, Value1. I am grouping by String1, and I have an area graph that is showing: On change of: Date 1 Show Value: Value1 I am placing the graph in Group Header 1. I want the series color (color of the area graph) to change depending on...

I am running into a little trouble getting the weighted average of a formula. My report is grouped by command.date. I am placing the following formula(@SQM) in GH1. IF (sum({@OLDBALNULL 36},{Command.date})-sum({@Quarterly Expected Payment 36},{Command.date})) = 0 then 0 else if sum({@Gross...

I want to make a stacked bar chart that is also grouped, similar to this: Is this possible?

I have a very simple graph that has two summarized fields balance and rate on change of date. The problem is that the dataset has data for rates on a daily basis and balance on a monthly basis: Date Balance Rate 6/30/2010 4250 4.63 6/29/2010 0 4.54...

I am having trouble designing a bar graph with a data series appearing as a line. If I set the chart type to bar and then set the particular series to appear as a line I can not remove the series markers (which is required). If I set the chart type to line, and make the other data series bars...

I know there have been a bunch of threads addressing this question, but I can't find an answer that works. I have a very simple crosstab in CR XI. Rows: Trends.SrcName Column: Trends.Dates Summarized Field: Average of Trends.Trend I want every other row to be shaded. The crosstab is in Report...

I am using Crystal XI and am trying to insert a picture field (BLOB) into a report from a database based on the company logo we are runnign the report for. The picture is dynamic and it's dimensions are not always the same. When the report is run, the picture is resized to the size of the box...

I have a report set up so with two columns, data from one Date and Data from a second date. This report has a number of groups as well. For each date there are 2 summaries, balance and weighted average rate. I am running into a problem with the summaries. If the balance is 0 (only in the...

Is there a way to use a parameter to set a charts data axis min or max? I have a bar chart that is on the group level, but if I set the data axis to auto range the charts are not on the same scale when I compare them to one another. The problem is the range is not always going to be the same for...

I have a bar graph that's x axis is dynamic. There could be anywhere from 2 to 12 periods. I wanted to have a data table below it that lines up with each bar that shows the data that is driving the graph. For the time being I used a cross-tab but it does not line up when I am using anything less...

I am building a Bar Graph with 2 Lines overlaying it. The X-Axis is numbers 1-12. The table is set up so there are Fields 1-12 that represent each bar going across. This is fine, but the lines on the graph are built off of parameters. The first line is the Values/Parameter1, and the second line...

I have two fields in GH5 of my report that are weighted averages of two formula fields. Field 1 = Weightedaverage(@formula1,@forumla2,GH5) Field 2 = Weightedaverage(@formula1,@formula3, GH5) formula1 = If field.NA = "Y" then 0 else field.rate formula2 = If field.date = 9/30/2009 then 0 else...

I have a report with five group levels. Some of these groups are conditionally suppressed depending on the data that makes them up. The data is made up of individual accounts, and I want to be able to drill down all the way to the details section. Unfortunately, I can drill down to GH4, but if...

I am attempting to pass a message from a few subreports into the page footer of my main report. The subreports are placed in the report footers of the main report. The formula that is placed in the group header of the subreport is: whileprintingrecords; shared stringvar message; message :=...