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 Mike Lewis 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. acrouch

    Subreport Values not resetting

    Hi, Thank you so much, I have wasted so much time moving the subreport and variable fields into different sections, and all it was, was one word.... I feel like an idiot ! Your help is greatly appreciated !! Thank you
  2. acrouch

    Subreport Values not resetting

    Hi, I am running Crystal V10 on an SQL 2000 DB, using an SQL ADO Driver. My main report lists all Customer Transactions, my sub report shows all customer receipts. The desired outcome of my report is to show any customer transactions less any allocated receipts, hence showing an overall o/s...
  3. acrouch

    Service Pack installs and Client Connection - SQL 2000

    Hello, I was recently informed that when installing a Service Pack to SQL Server 2000, you need to install this service pack on all workstations that have the client connectivity installed, not just the actual Server ! I have never done this before, is this true ? Your feedback is...
  4. acrouch

    DB Log File Size

    I have a Log file for one of my SQL DB's that is over 5Gig and growing daily. The DB itself is no where near that size. The Database is backed up every night as part of a maintenance plan which backs up multiple Databases and this is the only Database I seem to have a problem with. I have...
  5. acrouch

    Linking a Subreport to diff values ?

    I created the formula as above but when I view the resaults it is not returning the result I require orig result = 123456-1:name result with formula = 123456-1 Req result = 123456:name Have I done something wrong ? I have copied the formula I entered. left ({PURCHORD_HDR.REFERENCE}, instr...
  6. acrouch

    Linking a Subreport to diff values ?

    Hi All, I need to link a field in my sub report which is usally fine except this time the values will sometimes be slightly different. eg: Report 1 123456-1:name 123456-2:name 124567-1:name Report 2 123456:name 124567:name Basically...
  7. acrouch

    Default Value where no result returned

    I would like a default value to appear in a field where no actual value is returned in the report. eg. Field X Field Y Calc Field = X-Y results eg. 10 5 5 12 11 11 0 There May actually be no result for Field Y and I would like...
  8. acrouch

    Report Protection - Password

    I need to put some protection on the reports I have written, so that users can not edit them. How ever I need the user to have access to "Set Location" so they can change the Database and Server they run the report on. Any ideas ? Thanks in advance for your help !! Antoinette Crouch
  9. acrouch

    I Need a Text Box to appear in details section only once per page ?

    Hi, I need to insert a text field into my report, Easy enough, but the text field contains multiple lines and needs to appear beside the information contained in the details section. The problem is I require the text field to appear only once per page and I want the other information contained...

Part and Inventory Search

Back
Top