Recent content by fragglemoo

Hi I have a 400gb Seagate IDE drive from another pc that was split into 3 partitions. I tried to clear these by using Vista Disk Management and have managed to lose a partition. I have a 372.61Gb NTFS Active Primary partition and have "lost" the other partition. I reinstalled the disk back...

Hi CR2008. I have some data consisting of a reference no and 3 dates. CR123 15/1/2008 10/10/2008 11/10/2008 CR345 15/1/2008 16/1/2008 17/4/2008 IR789 16/10/2008 17/10/2008 19/5/2008 What I've been asked to do is to pull off the records where 1 or more of the dates is in a certain...

Cracked it :D Thanks again.

Thanks for the response - they are staying as strings. Sorry :( but I'm still a novice at CR, how do I use the above? is it a formula field or lots of formula fields? Thanks again.

Hi I am using CR2008 and have a string that contains numbers which I need to split into separate fields e.g 23 26 27 28 48 49 23 27 29 24 63 71 77 86 87 89 90 and so on. The number of digits in a field can vary but at the moment they are all 2 digits with a space between each one. Can...

Thanks for coming back to me. CR2008 as mentioned above. Sorry whats an object model? Unfortunately the data is confidential so I am unable to upload a copy.

I am using a hyperlink in my report to open an object in my database: "ttstudio://mksrvttp02:99//" & {Command.Project Name} & "/dfct?recordID=" & {Command.idrecord} It works fine in CR2008 but if I try and access via Crystal Viewer or a 3rd party viewer (Logicity) it doesn't work as a...

I've just been advised that we are looking for anomalies. There may be 300 same dates in a group and 1 different one and they would like to be able to highlight this.

lbass - good question! I never thought of that DOH! I'll ask the managers who requested this.

Thanks for coming back to me but I may not have explained what I am trying to do very well. Sorry :( What I'm trying to do is highlight "data entry" errors. The dates in each group should be indentical so what I am trying to do is highlight in red any date that is not the same as the others in...

CR2008 I have a report that is grouped and one of the fields is a date/time field. The values in this field should all be the same but occasionally they are incorrect and I want to highlight these in red. I have been able to partially do this using If ({Command.Promotion to Production}) <>...

Thanks for the response. The link wasn't what I was looking for but I did find this one on the same site. http://www.kenhamady.com/form17.shtml

Hi I am using CR2008 and need some help with a formula to predict a date in the future. I have a date/time field and need to be able to add 552 hours to this and come up with a future date. Unfortunately this 552 hours is working/business hours only. Mon-Fri 09:00 - 17:30. Does any one have...

Thank you - worked perfectly

I'm using CR2008 and have a report where I need to be able to view the Report Header but not physically print it out. How can I do this? Thanks