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!

Register Log in
  • Congratulations Chriss Miller 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. acentler

    Conditional Formatting in Cross-tab to compare across cells.

    So you mean have 13 seperate formulas in month order? When you have a moment can you give me a little more detail? Thanks for the response! ACE
  2. acentler

    Conditional Formatting in Cross-tab to compare across cells.

    Don't know if this is possible. Have a cross-tab report where I want to be able to change the color depending on how it compares to the previous entry. Similar to how one can do conditional formatting in excel ( if A2 > A1 then green). Here is what the cross-tab is setup. Rows = @Queue_Name...
  3. acentler

    GMT To EST datetime conversion help.

    Anyone have a good formula that will take a GMT datetime field and automatically convert it to EST? With the formula looking at each datetime entry to determine if its -4 or -5. I got one that can do one or the other I just need one that will change it from -5 hrs to -4 hrs on 03/09.
  4. acentler

    Follow Up Help - change the page header name depending on subreport?

    Sorry meant to say report header. But don't worry about it. I will just file it under Magic. Thank Again!!
  5. acentler

    Follow Up Help - change the page header name depending on subreport?

    Works like a champ. Thanks LB you've saved me tons of time. Out of curiosity how does this work with putting the False formula in the page header?
  6. acentler

    Follow Up Help - change the page header name depending on subreport?

    Thank You... I will give it a try this afternoon and let you know how it went. Thanks Again.
  7. acentler

    Follow Up Help - change the page header name depending on subreport?

    Not a problem at all... Been an issue with me since January.. I can wait.. Thank YOU!
  8. acentler

    Follow Up Help - change the page header name depending on subreport?

    OK.... Have one main report I am putting all my subreports in. I am putting them all in the main reports Report Footer. I am trying to change the main report page header to reflect what the subreport is showing. I have been able to accomplish this by putting a simple formula in the main report...
  9. acentler

    Follow Up Help - change the page header name depending on subreport?

    So I tried what you suggested a couple of ways and couldn't get it to work. I am more then likely doing it totally wrong. I am using just 1 page header for the whole report. I am just using the page formula above to title the headers.
  10. acentler

    Follow Up Help - change the page header name depending on subreport?

    OK I guess then I didnt understand what you suggested .. sorry ;-)
  11. acentler

    Follow Up Help - change the page header name depending on subreport?

    Yea i got something like that just doing it on page counts. Just some of the subreports will change page counts on me. So what was just a 1 page subreport is now 3 pages knocking all the page header names off. Anything you can think of is much appreciated master yoda :-)
  12. acentler

    Follow Up Help - change the page header name depending on subreport?

    I posted a message looking for help on creating pageheaders in the subreport to show up in the main report. I got the following response which worked great if the subreport was only 1 page long. --------------------------------------------------- The simplest solution would be to format your...
  13. acentler

    How can I change the page header name depending on subreport?

    OK.. But the subreports are just a bunch of charts and tables that are in the report footers. Adding a group won't help me there will it?
  14. acentler

    How can I change the page header name depending on subreport?

    They are located in the Report Footer (a-e) Thanks!!
  15. acentler

    How can I change the page header name depending on subreport?

    I got a report that has 5 subreports inside it. I want to be able to change the page header title depending on the subreport. I tried doing it using page numbers (see below) but sometimes one subreport is longer then the other and jacks that all up. There a way to do this formula using the...
  16. acentler

    Stacked chart sort order... Killin Me!

    OK so I am using Crystal 11 (does this in 10 as well) have a very simple stacked bar chart. It is forcing a sort order on the stack. Chart: On Change of 'Group', 'Category' with a Sum of tickets. It will not let me sort the category at all. Tried every variation of sort orders and TopN's I...

Part and Inventory Search

Back
Top