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

    Need A Formula That Shows ALL the Data of One Field in a NEW Formula

    Need to make a formula based on something like this.... record state name 123 NC John 124 NC Bill 125 FL Mary 126 GA Bob 129 TX Susie 130 TX Dave 131 TX Mike I am grouping records by month (field not...
  2. RoMarcus

    Suppress All Detail Lines Except Last Two Per Group

    CRXI R2 / Oracle 10 group1 - part number group 2 - serial number details - all historical records that fit search critera sorted by date Only want to show the last two records - - currrent historical record and the record prior.... I created a running total which gives me the total records...
  3. RoMarcus

    Value of Actual Field in Heading - Not Parameter Field

    I've seen several posts and answers for 'parameter' join function to show the value in the header of a parameter field and that works very well -- but does not work with a regualr field. How do you do display the values in a field that is NOT a parameter field. Although I'm not reporting on...
  4. RoMarcus

    Best Practices for BO XI - InfoView Questions

    BO XI R1 - Windows Server 2003 R2 SP2 - SQL 2000 SP3 I have some server management questions. How can I tell how much space 'instances' are taking up? What is the easiest/best way to delete instances that are old? - - can I select instances by a date range to delete? Is there an auto delete...
  5. RoMarcus

    Trying to Report AD Users' Groups

    I originally posted this is the wrong group (Crystal Reports - I wish there was an easy way to re-classify your posting......) CR XI W2003 AD / Terminal Server / Citrix I'm excellent at creating reports; not great at writing scripts and stored procedures. I need to create a report that...
  6. RoMarcus

    Trying to Retrieve Active Directory User data in Crystal Reports

    CR XI W2003 AD / Terminal Server / Citrix I'm excellent at creating reports; not great at writing scripts and stored procedures. I need to create a report that shows the AD users 'MemberOf' information. OU name is 'Locations' domain name is 'corp' or 'corp.cd' I've searched this group and I...
  7. RoMarcus

    CR Server 11 - How to Create Hyperlinks & Shortcuts

    I'm a very seasoned Crystal Report writer. I have NO experience with Crystal Server. I know what I want, but can't figure it out so I'm asking for help. I want to know how to make hyperlinks to the crystal reports. So that I can either put the hyperlinks on someone's desktop or in a web...
  8. RoMarcus

    How to select only 100 records from each group

    I have a report of doctors, patients, and date of visit. I want to select by doctor only 100 of his most recent visits. There are 35 doctors. I want to see 100 records for each of my 35 doctors based on the most-recent visits. So a report of approx 3500 records... There was a TopN expert in...
  9. RoMarcus

    How to Force Parameter to a date in the future - crw xi

    I have a report that has a startdate and an enddate. I want to be sure that the user running this report can only enter today's date or a future date for the startdate - I would like the report to beep at them and tell them that they've entered a prior date which is invalid for this report...
  10. RoMarcus

    Main Report Portrait - SUB-Report Landscape

    How do I do that? The Sub-report is in the report footer. What I'm trying to do is have one report print after another and obviously their orientations are different. Thank you.
  11. RoMarcus

    Insert Picture as Result of Formula - - CR XI

    I think I originally posted this in the wrong forum - so let's try here.... I have one picture that I would like to display depending on the result of the formula. If totaldeposit <> PaymentsEntered then show the PHONE.JPG image I clicked on insert, picture, and placed the phone on the...
  12. RoMarcus

    Passing Date Parameter values to SubReport w/both evaluat separately

    I am trying to select records based on a date range to display on the main report and a subreport with both reports reporting off of different tables. I have two parameters on the main report to make a date range ?startdate and ?enddate - I made two formulas that share these for the subreport...

Part and Inventory Search

Back
Top