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!

  • Congratulations gkittelson 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. littleress

    Summing Time in Group

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

    Summing Time in Group

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

    Summing Time in Group

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

    Summing Time in Group

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

    Summing Time in Group

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

    Group summaries

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

    Crystal Reports XI with Oracle 10 and Windows 7

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

    Crystal Reports XI with Oracle 10 and Windows 7

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

    Conditional suppression for a text box on grouping

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

    Group Sort Order Formula for Specific Group

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

    Need isnull within select statement

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

    Need isnull within select statement

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

    sorting null values last in the group

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

    sorting null values last in the group

    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!
  15. littleress

    Crystal Reports in Vista using Oracle - can't find database

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

    Crystal Reports in Vista using Oracle - can't find database

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

    Keeping Details only for specific Group

    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!!)
  18. littleress

    Keeping Details only for specific Group

    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?
  19. littleress

    Keeping Details only for specific Group

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

    Keeping Details only for specific Group

    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?

Part and Inventory Search

Back
Top