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 dencom 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: *

  • Users: littleress
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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}...
  7. 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!
  8. 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...
  9. littleress

    Keeping Details only for specific Group

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

Part and Inventory Search

Back
Top