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

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

    Thank you - I used a variation of that and it is working in the group header. Appreciate the reply...
  2. 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...
  3. RoMarcus

    change of database logon for the deployed reports

    I have used schedule manager and it does work. However it does NOT work for recurring reports that are scheduled. Those will have to be re-scheduled or use a third party tool or the SDK.
  4. RoMarcus

    Problems scheduling in CE10 - Database logon information error.

    Where is the report supposed to eventually end up? In an email or file location or printer?
  5. RoMarcus

    Suppress All Detail Lines Except Last Two Per Group

    I knew it was something simple - thank you. Works perfectly.
  6. RoMarcus

    running a report with date parameters

    What is your logical date range for each day? excample...Last two days?
  7. 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...
  8. RoMarcus

    Value of Actual Field in Heading - Not Parameter Field

    Thank you for the reply CoSpringsGuy.... That is close to what we came up with which is now working perfectly ... I failed to mention that the data is collected in a group; what we ended up with is the following which is very close to yours and basically does the same .... Two Formulas...
  9. 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...
  10. RoMarcus

    Best Practices for BO XI - InfoView Questions

    Thank you for this information. That sounds really interesting. Can you tell me the steps? I'm the admin person so there is no one else to ask... except that I'm going to be taking a BO XI Admin class in a couple of weeks so some of these types of questions will be answered. I have...
  11. RoMarcus

    How to pass value from sub report to main report

    It almost sounds like your subreport's page headers are suppressed - Have you tried not suppressing the subreport's page header in your subreports? Don't use the Report header - by design it's only going to print on the first page. I have dozens of reports that have subreports in the footer in...
  12. RoMarcus

    How to pass value from sub report to main report

    As lbass and madawc mention, the variable has to appear in a section 'above' the section in which you want to use the data. The shared variable formula in the subreport also must be displayed. To make it show on the same row, go in that section and select 'underlay following section'. If you...
  13. RoMarcus

    retrieving DBF files, from another server

    That is how all of my other services that are not listed are set - to local user. And I bet the local user of that machine does not have rights to the database on the other server. I look forward to hearing back with some good news......
  14. RoMarcus

    retrieving DBF files, from another server

    I had a similar issue - changing the services log on account information fixed the problem. To see what account the crystal server services are using ... go into the central configuration manager - this shows which services are running; check the Central Management Server for example, by...
  15. RoMarcus

    retrieving DBF files, from another server

    Check to be sure that the service account that is running the BO services has the rights to access that database. It could be that the 'local' service on that machine may not have the rights needed.
  16. RoMarcus

    retrieving DBF files, from another server

    Try using the UNC path rather than the mapped drive.
  17. RoMarcus

    Best Practices for BO XI - InfoView Questions

    Thank you both for this information; I will try both of your suggestions and let you know how it goes. I appreciate your input!
  18. 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...
  19. RoMarcus

    Pass variable from sub to main report - no records

    Does your report start out in-sync? and then become 'off'?

Part and Inventory Search

Back
Top