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

    Multiple Data Sources In One Query

    I currently create reports using multiple ODBC connectors to several different databases & types (MSSQL, postgre, DB2, MySQL). This has worked OK so far but I'd like to get to a point to where I don't have to have 18-20 different table nodes & names w/ 1 - 30 items in each node. Is there a...
  2. patryn150

    Single Axis Graph

    Sweet, that works! Thank you for your help.
  3. patryn150

    Single Axis Graph

    Two separate running totals. The report is grouped like this: UniqueCallID1 Question 1: Answer Question 2: Answer End Group UniqueCallID2 Question 1: Answer Question 2: Answer End Group ... The running totals only evaluate on their proper question, so: Running Total#1 = Average response...
  4. patryn150

    Single Axis Graph

    What I'm ultimately trying to do is something like this (sorry for my horribad design in text) ID Value A 4.5 B 7.67 A B |---|---|---|---|---|---|---|---|---| 1 2 3 4 5 6 7 8 9 10 Looking at Line/Scatter, from the work I've had with...
  5. patryn150

    Single Axis Graph

    I've been tasked with charting out responses for a survey of ours. One of the charts that I need to so is to plot out 2 single points of data on a scale of 1 - 10. I've searched through the topics here to see if any one has posted anything similarly and I cannot find anyone who has. Can...
  6. patryn150

    Data Retrieval

    LB - Yes, being a beast is a good thing in this context. :) Trying your solution will likely work for the aspect of getting the information of the last person to touch the account, however, I will lose all the running totals of the rest of my information. Two of them I can get back as I can...
  7. patryn150

    Data Retrieval

    Yeah, I wasn't paying attention to that. I can make it so that SQL expressions 'are' available, but then I start getting people that are outside of our department, and there's no flag in the billing system as to what department there is. Thus the extra database to give us just our department...
  8. patryn150

    Data Retrieval

    LB - Thank you for the SQL info, however, that won't work for what I need to do. Also, I did run into something else while working on this, I'm using 2 sets of databases. 1 for our billing system, 1 for our employees, so the "SQL Expression" option available in Crystal isn't allowed, unless...
  9. patryn150

    Data Retrieval

    Yes, SQL is available to me. You are correct on the second statement, only the last contact by rep. I've banged my head against a wall for 2 days off and on trying to think of different ways to do this, none of which have been successful.
  10. patryn150

    Data Retrieval

    Crystal Reports XI, reporting off of an AS/400 I am reporting how many times our customers accounts have been touched, how many unique accounts, how many unique touches, etc... to try to figure out how many times our customers make contact with us a single time in a rolling 30 days. The...
  11. patryn150

    Charting on Formula By Group

    I've read the forum posts and the document at http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_charting_print_time_formulas.pdf however, for whatever reason, I cannot figure out how to make this work. So, basic rundown: I have report that is grouped by Day and then by Time on...
  12. patryn150

    Running Total Quandry

    Debugged it. Was an error in that hugely long Adherence5 formula that was causing it, forgot to put in a previousisnull reference thus it was returning a detail that was not summable. Thanks for the ONFIRSTRECORD info though, didn't know about that command :) Thanks!
  13. patryn150

    Running Total Quandry

    This is the formula I'm having trouble with currently (as detailed above): Details: -{@adherence1} --whileprintingrecords; --numbervar adherence; --adherence:=adherence + {@adherence3} + {@adherence4} + {@adherence5} The references to adherence3 - adherence 5 are as such: {@adherence3} -if...
  14. patryn150

    Running Total Quandry

    Robbie - Sorry for the delay. I do have that function in there, I just forgot to copy it over when I was cutting and pasting my formulas. lbass - The only time I use a previous command is to reference whether the previous login was a null value (aka, that person was the first to log in), or...
  15. patryn150

    Running Total Quandry

    I'm new here, so go easy on me (yes, some of the formulas are a bit bulky, still learning) :) I found a thread on here that helped me get an alternate way of accumulating a running total since the actual RT would not accept my formulas as a way to summarize. What I'm having a problem with now...

Part and Inventory Search

Back
Top