Search results for 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...

Sweet, that works! Thank you for your help.

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

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

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

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

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

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

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.

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

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

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!

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

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

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