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

looks interesting... but alas its for SQL Server 2005 ? We're upgrading in the next few months, but for the time being we're still on SQL Server 2k.

sorry. i realise i gave too little info first time around. the min(editdate) part will not work because edit dates are not neccessarily unique BUT a row_ino and edit_date will be here is a 'real' data sample row_uno m_uno edit_date x y z 1029 1162 1995-08-09 SEDI PROP...

thanks... but it doesnt quite work. and sorry can't figure out why. 1st table contains 43230 rows, query returns 830401 rows

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

thanks for your help. FYI i'm using CR v10, SQL Server 2000. dgillz can you expand a little on the SQL expressions - not used these before when i just pasted your code into a formula it resulted in an error. thanks

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.

maybe it would be clearer if i illustrated with data G2 (grouped on rank) G3 by employee detail suppressed so the report shows hrs Assistant mr X 2 (subtotal sum hrs) mr Y 2 (subtotal sum hrs) Trainee mrXX 1 (subtotal sum hrs) mrYY 3...

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

The very dab! 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

Sorry guys this still isn't quite working as I'd like. Apologies for the poor data example previously. The code abve (either versions) returns odd rows where there is a match ie 19 -19 19 20 -20 would return one row 19 but if i have a number of unmatched rows 20 20 20 20 i need to return...

Sorry it was a bad example. What I was after was more complicated than a sum. But thanks synapsevampire you guessed what i was after and actually the second option seems to work fine. so aaa bbb ccc 19.00 aaa bbb ccc 19.00 aaa bbb ccc -19.00 would show the one row aaa bbb ccc 19.00

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

I agree I nearly always push the processing onto the database server. And this is what I have done. However I need the ability to drill into the bill detail. So the only way I can see to do this is to create subreports for each of the bills (very inefficient) to allow the user to see bill...

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