Recent content by scott1971

lbass, What I have is Claim Numbers at GH3 and that is what I need the random sample of. That sits under GH1 which is a provider Type and GH2 which is a Claim Type. I'm trying to get a sample of 50 Claims from GH3 that relate to GH2. The problem is that each claim has various details attached so...

thread767-1493843 Sorry to ask two in the one day but I'm struggling with this one. I have 4 GH's and GH3 holds the detail I want the random sample for with GH 4 having the detail. I have my formula and have placed Dgilz formula in the suppression box but it's suppressing all of my GH3. Can...

thread767-1493843 I tried this and I'm getting a message at the RND statement that the ) is missing. Probably something very, very simple but it's been so long since I even opened crystal that I've forgotten more than I ever knew I think!!! WhilePrintingRecords; Numbervar Array array1; Redim...

Thanks as always Madawc. I feared this may be the case but I'd hoped that perhaps there had been a fix put in place.....forever hopeful! Thanks again

Hi, I have a covering letter report and another detail report and I have inserted both into a blank template as subreports. The letter I want as portrait but the report has to be on landscape but I can't see anyway of doing this. The template has to be set us portrait or landscape and there...

Guys, I've seen an old post here regarding printing one subreport in Portrait and another in Landscape. I'm hoping something has changed since that post in 2007 though I'm not holding my breath. If anyone has any idea if this can be done in Crystal Reports or in Enterprise can you please let me...

thanks for this, I'll get the guys to take a look and see if this is the case for us. Much appreciated as always.

Guys, I'm very confused. My headings in Enterprise have changed into Spanish yet everything else is in English. Then if I hovver over the Enterprise window the description changed to Spanish, though these random occurrences were hours apart and in between times things were ok! No one has...

Guys, Urgent help needed on this. I understand there is no formatting but I'm not sure how you get the above to work, totally confused. Word isn't my thing but I can usually muddle through this but not this time! Thanks Scott1971

sorry, I should have said, some of the codes might not be used so with the 000 code the only code we have used is 000.9 so that is the description that is returned as it clearly can't return something that isn't on the database as being used. there lies my problem I think. Cheers Scott1971

lbass, sorry, I should have said, I have to join this file to another one that uses these codes against a claim number. My count is done on that so when I try and return the description it returns the first one it finds within that range which is seldom the 3 digit code. Sorry to go on with...

lbass, The Code I showed in my post is exactly what I see without using my formula. The field length in the database is 6 characters which includes the decimal place but there are obviously blanks in there as there are times when only the 3 or sometimes 5 characters are displayed. The only...

Hi there If I do that then it's spot on, I get the correct descriptive at each level as shown in my previous post, it's only goes pear shaped when I try and roll the codes together. what I think it does is it finds the first instance of any of the codes used from the file and returns that, not...

Hi lbass The formula is left ({Field_Name},3). The field has values and descriptions as follows: 001 Finger injury 001.00 Finger injury not specified 001.01 Finger injury (skin) through to 999 Foot injury 999.99 Foot Injury (toe) I want to return the initial 3 digit code only...

Thanks Skip, that's what I get for not checking which forum I was on! I hadn't even noticed that I'd posted that to the wrong one......bad ending to a bad day!