Search results for query: *

i've reached the limit of my javascript knowledge can you help? i have a form that builds a number of select boxes (it may be different per page) i need a javascript form validator to go through each select in the form and verify that a selection has been made ie selectedIndex !=0 the...

I have a table with row data held as one row per edit, against each row is an edit date. querying this table would be much more efficient (i think) if i could use a join between dates, ie if the table had date_from and date_to columns to replace the edit_date colomn. how do i go about...

Is it possible to use a function or special field to display the data source a report is connecting with. We frequently use the same reports to connect to different data sources (snapshot databases etc) and if this info could be displayed in the report footer or similar it would be very helpful.

I have a formula, @util which calculates the % utilisation as follows (Sum ({@hrs_chargeable}, {@G3})/{#AvailableHrs}) * 100 my grouping is thus G1 G2 G3 detail (suppressed) includes @hrs_chargeable, available_hrs G3 F - @util G2 F G1 F (this has been simplified - there are many...

I have a report where I want to show both the report total and the report total less one of the subtotals in the group ie G1H - G2H - G2F <G2 sub total 1> <G2 sub total 2> <G2 sub total 3> <G2 sub total 4> G1F <G1 subtotal> <G1 subtotal - G2 sub total 4> How can I do this? Thanks

I have a line chart with two data series 1. range 0 - 70,000 2. range 0 - 500 I want to plot each against quarters, this is OK except the (auto) range selected is no use for the second series - how can i add multiple data ranges (axis scale) on the same axis? CR10, XP, SQL Server Thanks

I have a report which shows transactions. Some of these transaction have been paired off by a corresponding -ve amount. I want to only show unpaired rows. ie 19.00 19.00 19.00 -19.00 -19.00 would show 1 row 19.00 500 -500 would show no rows 500 -500 32.00 would show one row 32.00 can...

CR10 / SQL server (SP) I am trying to group on a summary field as follows G1 Financial Year Quarters G2 Bill Value bands G3 Bill Number where G3 sums all the bills for that bill number, and G2 groups in bands based on the formula select <BILL VALUE> case 0 to 249.99 : "1. under...

I'm sure there is an easy answer to this but I can't figure it out. Crystal v8.5, SQL Server 2000. I have a report based on a group select Sum ({@61-90}, {_SP_CR0009;1.CLIENT_CODE}) = 0 and Sum ({@91-120}, {_SP_CR0009;1.CLIENT_CODE}) = 0 and Sum ({@over 120}, {_SP_CR0009;1.CLIENT_CODE}) = 0...

CR v10 / XP / SQL Server I have a report that prints labels. There are 3 reports to print the same data on front labels, index labels and sling labels. I would like to use a subreport and parameter to select which of the reports to print. My problem is however that the sling report needs to...

I have been tearing my hair out over the last few hours - can anybody help. I have a fairly comlicated query which aggregates data from a UNION ALL into a temporary table then returns the result. It was working perfectly but I changed a very minor part and it stopped returning all the rows I...

I am using shared variables in order to calculate subtotals from a subreport as follows. Group //Reset subtotal // reset whileprintingrecords; global numbervar Totals :=0; Detail //Calculate subtotal whileprintingrecords; global numbervar Totals; shared numbervar missingDays; Totals := Totals...

CR 8.5, SQL Server 2000, XP i need to suppress a group if the detail section is also suppressed and i may be going about it all wrong but this is what i'm doing. my group groups pairs of data, and i need to suppress if certain fields in the data are the same. GH 2 // reset isSuppress flag on...

I am using shared variables to calculate subtotals passed back from subreports in my main report BUT when a subreport is suppressed (v10) it still upgdtes the running total used to compute subtotals for the main report ... how can i stop the subtotal accumulating (uses last value) if the...