Search results for query: *

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

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

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

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

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

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

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

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

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