I am creating a report that takes data from a MySQL view. The report itself accurately shows the times for a call.
Such as 26:11, 1:02:15, 00:30
Is there a way to be able to "sum" up times within Crystal Reports? I want to be able to group on user and drill down to the actual calls. And then...
I have a report where I am giving info about CS ticket requests. So there is a header with the description of the ticket and then when you drill down it's several items of activity on the ticket.
So
gh1a ticket 1 - description - assigned too
gh1b name - date - notes (used this header for...
Has anyone played with Crystal and Windows 7 yet?
I have downloaded the Oracle 10 client to my computer. I can connect to the database just fine using toad, or sqlplus or OEM. So I see the db. But something is not right with crystal.
Someone suggested I download the 32 bit version of oracle...
I have a report that does totals for lots of different people. So they are grouped by id and the report totals 3 different tables and the theory is that all three end totals of several different groups should match. ex
payments 10 10 10
products 5 5 5
misc 8 8...
I have created a case that puts fields into groups based on types. Right now all of them are order in club #, which is fine for the main group. But I want to be able to tell it if the group is equal to X then it needs to order by type and then club # rather than just club #... is this possible...
I have a statement where currently it pulls a list of payments that were pulled that day, but I need it also to make sure that a certain payment id is null.
Currently:
{MPT.CLUB_ID} = {?Club_ID} and
{MPT.TRANSACTION_DATE} >= {?begin_date_range} and
{MPT.TRANSACTION_DATE} <= {?end_date_range}...
I've got a very simple report and it's a "by age" report. Currently though, the ages have the null values first if the user didn't put in birthdates. How do I tell the group that I want the null values last???
Thank you so much!
has anyone had any problems using CRXI in Vista? Our database is in oracle 10g and for some reason crystal will not find that database in Crystal. I just got my new laptop use Vista Ultimate. It's able to find the oracle database when I use Toad - but Crystal can't seem to find it. Any thoughts...
I am struggling to figure out a way to avoid using subreports. I have a revenue by category report I am building. 1st by Category, then by product w/in the category, then by the specific accounts for the product. I need to be able to click into the group 2 and drill into the products and have a...
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.