Search results for query: *

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!

Guys, I am on CR XI. I have a list of 3 to 5 digit codes in the format 000 running to 999.99 Each of these codes has a descriptive. I have created a formula to only show the first 3 digits of the code ie 000 to 999 so as it will 'roll' the codes together. What I also need to add is the correct...

Guys, I am on CR XI. I have a list of 3 to 5 digit codes in the format 000 running to 999.99 Each of these codes has a descriptive. I have created a formula to only show the first 3 digits of the code ie 000 to 999 so as it will 'roll' the codes together. What I also need to add is the correct...

Once again you have come up trumps, thanks again for your help though I fear I may be back before this report is completed, trying to replicate an AS400 report in Crystal is easier said than done I'm finding. Thanks again to you and to CR85User

I can't even get to placing the formula, it won't let me exit from the formula correctly as it's returning this error. Cheers Scott

CR85user, Again, like dgillz I can see that this should work but I think the problem is in the join of my files. I'm getting the same error message that too many arguments have been given and I'm sure it has to do with the joins. Cheers Scott