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 just don't understand how it could work with just the next function. I am currently using the next function in my suppression formula. If this report were on one continuous page it would work perfectly. If I don't know the last record of the page, what is stopping the suppression formula from...
Are you sure yours is working correctly? The reason I ask is because it has to be the perfect situation where a new relationship starts at the very top of the page, where this problem exists. In the report I run which is 60 pages that only happens 1 time. I appreciate your help with this. So as...
If you look at the screenshot I titled full report, you can see that the line (Db) is attempting to box in a relationship (It starts where subname says "cashflow" and has null val001's and ends after the last line that starts with "rem". Mixed in are other records that should not be boxed in. If...
I modified the formula and it seems to work:
onlastrecord or
not
(
(
{TempBatchData.SubName}[1]=" " and
next({TempBatchData.SubName})[1]<>" "
) or
(
next({TempBatchData.SubName})[1]<>" " and
nextisnull({TempBatchData.Val001})
)
)
However, the line (Db) is still showing up if its the last...
I don't believe that formula accounts for this portion of my original formula:
((nextisnull({TempBatchData.Val001}) and left(next({TempBatchData.SubName}),1) <> " ")=false)
I posted a screenshot of how it looks with your formula in there. The red lines represent lines that do not appear but...
Wow, that works great. I never realized that the PH reads the first record, something to remember next time. How can I go about suppressing Db if its the last record on a page? For instance in my first group of screen shots, there should not be a line under "Other Liabilities". Thanks again for...
Design Mode (Db is right below Da with a gray line in it):
Full Report:
Subname is the bold field. I apologize about being vague I am just trying to dumb it down to make the problem easier to solve. Hopefully you can figure out when I start and end the box based on my suppression formula...
There is just one suppression formula and that is for Details B (which contains the gray horizontal line):
onlastrecord or
((nextisnull({TempBatchData.Val001}) and left(next({TempBatchData.SubName}),1) <> " ")=false) and
(((left({TempBatchData.SubName},1)) = " " and...
LB, I've tried that as well and have not produced the results I am looking for. Maybe you can think of a better way of doing this then how I am currently going about it. I have no groups. I am trying to box in any record where val1= "cashflow" and have a flag field= 1.
So right now I have...
The reason I am not using a page header is because from my understanding I would not be able to conditionally suppress the page header based on the first details record on the page.
I made the changes you suggested and it still does not work. If the next page starts with details section b...
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.
That is not the problem. When I expand the field the number is returned, but not on the next line. It appears that it is pushing the text the value to right the within the cell rather than returning it on the next line.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.