Search results for query: *

yes, it was one of the links that was wrong. I've also put the crosstab in the report footer as suggested. Thanks again.

The fields in the cross tab are: The row is result_description The column is reported_timepoint The Summarised field is formatted_result The Group Header 1 is by result_description The Group Header 2 is by reported timepoint. The crosstab is placed in the Group footer 1 (result_ description)...

Ignore my last thread: This is what i see: Screenvisit 1 Baseline Screenvisit 2 Haemoglobin 12.2 12 - Screenvisit 1 Baseline Screenvisit 2 Uric Acid 271 266 - Screenvisit 1 Screenvisit 2...

This is what i get: Screenvisit 1 Screenvisit 2 Baseline Haemoglobin 12.2 - 12 Screenvisit 1 Screenvisit 2 Baseline Uric Acid 271 - 266 Screenvisit 1 Screenvisit...

Apologies for posting on the wrong forum! The row is result_description The column is reported_timepoint The Summary field is formatted_result The Group Header 1 is by result_description The Group Header 2 is by reported timepoint. The crosstab is placed in the Group footer 1 (result_...

I require the column order in a crystal report to remain the same and not to change order or to not be repeated on each row of the crosstab. (So the columns in the crosstab can be like headers). I only require the summarised fields to change on each row of the crosstab according to which column...

I require the column order in a crystal report to remain the same and not to change order or to not be repeated on each row of the crosstab. (So the columns in the crosstab can be like headers). I only require the summarised fields to change on each row of the crosstab according to which column...

Thanks I've got it working now

I'm obviously not using the formulae correctly, this is what i'm doing to try and get the number after the > : Formula 1: Split({SPECIFICATION_ITEM.DESCRIPTION},">")[2] Formula 2: Split({@test3}," ")[2] This works up until i get >0 and < 1 or >0 and 0.1 Hope this makes sense.

i get the following error: 'A subscript must be between 1 and the size of the array.'

also >0 and <0.1

How would i get it to work with >0 and <1

What if there are decimal places in the format?

What does this mean: "database connector error: if the tables are already linked then the join type cannot be changed" I get it when i try to change a link in a report. I'm using Crystal XI

Does anyone know how to pick the numbers out of a range field like this: '>26 and <31' o I've tried using the instring and mid functions but because the numbers in the range vary in size sometimes the formula field brings back the '>' or the part of the 'and' which i don't want. I thought about...

thanks for the speedy response - you're a star

I'm getting the following error when i preview a crystal report (Crystal Xi) on Business Objects. (It is fine when i run it from crystal though). There are approx. 30 million recordds in the oracle database for this report: Error in File All Sensor Readings between 2 dates and times...

Thanks Turkbear - I'll have at look at that site

Hi, I get the following Error in enterprise when i preview a report: Failed to open the connection. Clinical External Riccarton Invoice Report individual studies Details: [Database Vendor Code: 12154 ] Would anyone know what i need to do to get the reeport running. I'm using Business Objects...

Thanks crsdev: I'm using an oracle server connection and the back end database is oracle. Thanks Turkbear: I've added a TNS entry.