Search results for query: *

Hi guys Using Oracle 8 and Crystal 9 I am trying to split a one line comma delimited address field into a normal address format using following: @Add1 split({099.HOME_address_name},",")[1] @Add2 split({099.HOME_address_name},",")[2] @Add3 split({099.HOME_address_name},",")[3] @Add4...

Hi Using oracle 8 and Crystal 10 I have a report which stores only month and year (as numbers) and I need to perform a calculation based on the last day of that month field. I have converted it using the following formulas:- @GVAToDate cdate(({GVA.YEMONTH}&'/'&{GVA.YEAR})) @LastDay...

Sorry lbass, doesn't make any difference. I think the formula is ok, it produces the correct results, it just returns the error through enterprise.

Hi Using oracle 8 and Crystal 10 I have a report which stores only month and year (as numbers) and I need to perform a calculation based on the last day of that month field. I have converted it using the following formulas:- @GVAToDate cdate(({GVA.YEMONTH}&'/'&{GVA.YEAR})) @LastDay...

Hi guys Using Crystal 10 and Oracle 8i I have a formula field which calculates the cost of an event using ({EVENT.EVENT_CHRG}*1.175). (£75.00 cost + VAT@17.5%) My grouping is GH1 Business Name, GH2 Attendee Name, GH3 Event Number and the formula field sits on GH3 and works as expected. It is...

Using oracle 8i and Crystal 9 I have a report that replicates a paper form which users complete manually. The idea is that this report will display data already held in the database and when printed users will complete missing or incorrect data. The form has the field names in boxes with each...

Thanks Ian but this didn't quite work, however prompted me to think and have now resolved. I created a parameter field with default values of 'Use Event Default' and 'Insert Event Name'. I have used two report header sections and conditionally suppressed them where True and False. Many thanks...

Hi guys Using Oracle 8i and Crystal 10. I have a report which prompts the user to enter en event number to display event attendees for the designated event. The report displays the event name at the top of the report. The problem we have is that the database field length for the event name...

Hi Using Crystal 10 and Oracle 8i I need to create a formula that translates a code into text and am currently doing this with a simple if, then, else statement. It is fairly long and tedious and was wondering if there is a better way of doing it. When using a different report writer some...

Thanks, didn't quite work using m_start but used student_reference intead and worked perfectly.

Hi Using Crystal 9 and Oracle 9 I have a report with following groupings:- Group 1 - VW_STUDENT_SURNAME Group 2 - VW_STUDENT_REFERENCE Group 3 - VW_MODULE_FP.M_START Group 4 - VW_MODULE_MO.M_ID Group 1 footer holds a text box (signature) Group 2 footer is suppressed. Group 3 footer displays a...

Can't you simply sort by date and then create a running total counting each record and then supressing the section where RunningTotalField>5 jcl5

Alternatively, you can insert all the fields into a text box and format the box using common tab, 'suppress embedded field blank lines' check-box.

Hi Using Crystal 9 and Oracle 9 We have a number of databases holding similar data; Live, Test, Training etc and I would like to display which database the report has been run on in the report footer. I thought I might be able to use a sql expression formula using the system function {fn...

Thanks so much LB, can't believe I am such an idiot - couldn't see the wood for the trees!!

Wow, that works great, and thanks for really quick response jcl5

Hi lb, The selection formula for the container report is:- {VW_MODULE_MO.M_REFERENCE} = {?ModuleRef} and ( if {?Resit} <> "All" then {VW_GRADESET.G_REFERENCE} = {?Resit} else if {?Resit} = "All" then true ) The selection criteria for the sub-report is:- {VW_MODULE_MO.M_REFERENCE} =...

Hi Using Crystal 9 and Oracle 9 I am using the formula:- Join ( {?ModuleRef} , ', ' ) to display parameters selected in a report. This displays as:- Modules Selected:- BA20207E 20-02-06 11-07-06, BA20207S 20-02-06 13-07-06, BA20207S 23-02-06 13-07-06 However, I would like it displayed...

Thanks LB - this is what I'm trying to do and all parameters are the same. As I said before it works fine if I select one of the criteria from the list so demonstrates the links are set up correctly - it's only when selecting the 'All' or multiple criteria that doesn't work. Thanks jcl5

Hi Running Crystal 9 and Oracle 9. Is it possible to display the name of the user who runs the reports in the page footer. I know I can prompt the user to enter their name at runtime but just wondered if there was anyway Crystal can do this from the network login. I understand there is a...