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 bkrike 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: ReillyC
  • Content: Threads
  • Order by date
  1. ReillyC

    Crystal XI - Filter out data from a report

    I have a report where I list the employees and the number of requests they have submitted. What I need to do is just display the employees that have a request in 2005 plus their running totals. How can I filter that out? Current Results Earliest Name Request date...
  2. ReillyC

    Crystal XI - Sharing variable between a main and subreport

    The report I have works great it just I need to know how to combine sites information using the shared variable technique or may I should set up my report differently. I have a main report and a subreport. The main report contains the list of employees along with the sites they belong to. I...
  3. ReillyC

    Crystal XI - Grouping - Including data not in the group.

    Good Day All I need some help. I have a report it's group by SBU then by SITE. IT WORKS GREAT BUT…… Raw data SBU SITE APP NO SBU SYSTEMS BU ACCESS CA 1 SBU...
  4. ReillyC

    Suppress Duplicates Crystal Report XI

    Hello I need some help. I had to create a command that combined three sql queries. The results are correct however, now I have duplicates in my crystal report. See record index App Type Code Event Date Status Filing date Record Index App#2 NP MY 20-Oct-05 FLG 20-Oct-05 5,834,488.00 App#2 NP...
  5. ReillyC

    Crystal XI - Formula criteria ignored. Why?

    The following formula works great {TABLE_PRODUCT}IN ["TV","VCR","DVD"]THEN 1 ELSE 0 but I needed to modified it. I needed to add one other criteria, date criteria. IF NOT IS NULL({TABLE_APPLICATION_DATE}) AND {TABLE_TABPRODUCT.CODPRD}IN ["TV","VCR","DVD"]THEN 1 ELSE 0 The problem is that my...
  6. ReillyC

    Freeze results for future reports - Crystal XI

    In some reports I need to 'freeze' the data by the each quarter and then use the frozen results in future reports. Can this be done in Crystal automatically? Thanks R
  7. ReillyC

    Group expert omitting fields - Crystal XI

    Each application is usually assigned a product. One application can be assigned multiple products. Note the application numbers are alphanumeric. App # Country Product USA2 US DVD USA2 FR DVD USA2 KR DVD USA1 US HDTV USA1 JP HDTV USA1 UK HDTV USA2 US HDTV USA2 FR HDTV USA2 KR HDTV USA3 US...
  8. ReillyC

    Attempting a manual crosstab - Crystal XI

    I'm creating a manual cross tab. I have grouped my report by a field called product. From that field(product) I created 3 GROUPS (digital, analog and others) using the group expert. In the select expert I placed the date range 1/1/2005 - 12/31/2005. I was trying to create a formula to count the...
  9. ReillyC

    Create a folder for each name in a list

    I have a list of employees (287) in excel. Baker Cohn Smith I need to a create folder for each employee. Can this be automated via a script? Many Thanks R
  10. ReillyC

    Crystal XI - Running Total in a crosstab

    Hello Experts, I have a crosstab set up. I think I need a running total in the summarized area. I want to continue to add the number of products added between March and June (106 for Digital) and then between June and Sept. (82 for Digital ) MAR 2005 JUNE 2005...
  11. ReillyC

    Crystal XI - Customize the size of the report

    Is it possible to customize the size of the report and specifically the width? We have many columns to display in one page (several data by quarter, full year data…) Thanks
  12. ReillyC

    Crosstab Display Columns but exclude from final total

    I have a crosstab that works beautifully, ALMOST. ;) Here is the crosstab US JP GB CA MX TOTAL TV 2 9 0 3 0 14 DVD 3 12 5 0 3 23 VCR 0 6 4 2 0 12 I want to display CA and MX but include it in the...
  13. ReillyC

    Organizing and deployment a documentation management system

    Good afternoon all, I have just been tasked to deploy our Xerox Docushare documentation management system worldwide. I have ideas about filenaming conventions for all documents, requiring a workflow from each business but I'm not sure how best to organize and communicate all this information...
  14. ReillyC

    Run Parameters on subreport and main report - Crystal XI

    Good evening folks, I have a bit of challenge. I used a subreport to concatenate a list of values (i.e. countries for each application) This reads that we filed Application01 in USA, France and Great Britain. Application01 - USA, FR, UK Application02 - USA, CN, JP Application04 - CA, MX, TW...
  15. ReillyC

    Crystal XI - Parameter - User doesn't have to select all options

    Is it possible to have more than 2 parameters where selecting options is not required. For example, Parameter 1 Select Country Parameter 2 Select City Parameter 3 Customer What if the user just wants to choose the country and customer and skip the city field? Is this possible or does the user...
  16. ReillyC

    Outlook 2003 - Log in screen Question

    When I started up my Outlook this morning, a log in screen appear with our IT guy's username in it. Does that mean he was logging into my e-mail account?
  17. ReillyC

    Split document into many files Word 2003

    I need help badly.Someone in the Office forum suggested I post here. Thanks I have a word document that is 357 pages. Within the document there are several file groups about 200. For example, File2369933 on pages 1 - 3 File9663339 on page 4 File2173993 on pages 5-9 I need to separate each...
  18. ReillyC

    Split document into many files Word 2003

    I need help badly. I have a word document that is 357 pages. Within the document there are several file groups about 200. For example, File2369933 on pages 1 - 3 File9663339 on page 4 File2173993 on pages 5-9 I need to separate each file group into it's own document. For example...
  19. ReillyC

    Crystal XI - Parameter - Uploading a list

    I have a report where I group data by product type. For example, Model No: 123699 Location: USA Order from: Portugal Model No: 563336 Location: USA Order from: China Model No: 8696633 Location: France Order from: Italy I need to set up 2 parameters. (1) Select countries (2) model numbers (1)...
  20. ReillyC

    Crystal XI - New page to display list of data contained in main report

    I have a report where I group data by product type. For example, Model No: 123699 Location: USA Order from: Portugal Model No: 563336 Location: USA Order from: China Model No: 8696633 Location: France Order from: Italy I want to have a separate page preferably the last page where I can...

Part and Inventory Search

Back
Top