Search results for query: *

If I never leave CR 2008 designer - how do I do that? That's what I'm not getting. Do I do the above in the SQL expression? All we do is call the Crystal Report from cold fusion which just will send through the report id and the 2 dates (start/end), nothing more. The Report calls a view from...

All of this data is coming from a MySQL View. I haven't converted anything in Crystal. I'm using CR 2008 Designer -so I'm not sure if that makes a difference. I haven't created any code in CR. I have 2 views. I have a sum view by date and a details view. So I need the top sum though to be...

I have it in 2 fields. One is a time duration and Crystal know how to format the detail as a time just fine. So when Crystal allows me to format, it comes up: 0:00.02 0:01.46 0:00.25 I also created a field that is a number field summing up the seconds and so it comes up 2 106 25 But I...

I'm using CR 2008 I already have duration. Like I said originally, I just want to sum them, it shows the actual duration in the details. But when I choose the field, it doesn't allow for a Sum on this field so I didn't know if there was a different way to sum time durations within CR or if I...

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

I am using Windows 7 64 bit. I did install the client first. This version of Crystal has always worked, but it's always been with 32 bit OS, not a 64 bit. Most of the posts I had read before said that if I ran a x86 oracle and then installed crystal that I should be able to get them to talk but...

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

Thank you. I will try this. My biggest dilemna is that if I take that exact query and run it in Toad, it works fine. Some days I think Crystal tries to make me crazy!!! I appreciate your replies.

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

That seems complicated just to say nulls last. I know how to do it in sql, but just not in Crystal. It is currently grouped by age. There is a formula field that says take todays date and subtract their birthdate to calculate their age. Then it is grouped by this field so that the group footer...

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!

yes. we installed oracle first, then toad and I can use toad and get to every schema and table and update perfectly. So I know that the database is there. But for some reason when we try to set up the repository it can't connect to the database. We did it the next day on an xp desktop with ease...

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

Nevermind... i figured out how to take your drill down thingy and make a little conditional formatting on the bold! ya!! One report down... but I'll be back because I have 5 more reports to go!! (at least that's what I have scheduled!!)

Ok you are the most helpful person ever. How about this last question (which is probably a lie - but I hope it's the last question) Can you make a formula to bold something only on a drill down? I only want the description to be bold when I've drilled into it. Is this possible?

Ok that worked! thank you. On this same theory. any suggestions on the same report. I've got drill downs and when i drill down into this 3rd group, I don't want all the info from the previous group, really only the description and not all the monetary info. Basically it goes(if you don't see it...

Ok I was hooked on another project and am just getting back to this report. I'm new to crystal reports and don't really understand how do to some things. Can you explain how this drilldowngrouplevel thing works? Or point me to a good forum that explains how to use section suppression?