Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hoagieryder

    Summarizing Distinct Values Across Multiple Columns

    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...
  2. hoagieryder

    Exported Report in RTF: CR 2011 vs. CR 11.5

    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...
  3. hoagieryder

    Suppressing First Record on Each Page

    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...
  4. hoagieryder

    Suppressing First Record on Each Page

    Yea, that is what I was afraid of. I can't do that because the fields can grow so it would not look consistent. Either way, thanks for the help!
  5. hoagieryder

    Suppressing First Record on Each Page

    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...
  6. hoagieryder

    Suppressing First Record on Each Page

    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...
  7. hoagieryder

    Suppressing First Record on Each Page

    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...
  8. hoagieryder

    Suppressing First Record on Each Page

    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...
  9. hoagieryder

    Suppressing First Record on Each Page

    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...
  10. hoagieryder

    Suppressing First Record on Each Page

    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...
  11. hoagieryder

    Suppressing First Record on Each Page

    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...
  12. hoagieryder

    Suppressing First Record on Each Page

    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...
  13. hoagieryder

    Suppressing First Record on Each Page

    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...
  14. hoagieryder

    Suppressing First Record on Each Page

    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...
  15. hoagieryder

    Formatting Line Graph Colors when More than 4 Values

    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.
  16. hoagieryder

    Vertical Alignment in Crosstab

    Adding an additional summary worked great, thanks LB.
  17. hoagieryder

    Vertical Alignment in Crosstab

    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.
  18. hoagieryder

    Vertical Alignment in Crosstab

    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?
  19. hoagieryder

    Chart Color Changes by Group

    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...
  20. hoagieryder

    Graph Color Changes on Group

    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...

Part and Inventory Search

Back
Top