Recent content by timhans

Hello new to Crystal Reports. I have a report based on a survey I have tbl.Theme where there are 14 Themes under each theme there are questions. I have the variance calculated for each theme, how do I either 1) Get the top 2 variance and the bottom 2 variance for all themes 2) Get all...

Thanks, others have recommended third party products for what I was asking but you are the first to say what I want to do is not possible.

New to Crystal Rreports I have a report based on a group (using the group expert), the items of the group are peoples names; Bob, Jane, ... Is it possible print the report to separate pdf's based on the group's items i.e. the names; Bob, Jane, ... with a formula or...something(I know there are...

Here is what finally worked in a way that I could use in a chat. Create a formula "Null" when the editor opens click close and save with out doing anything then Conditional_Score If {@CntClient}<=2 and {'360_'.Relationship}="Client" then 0 else {'360_'.Score} Becomes...

Hello, very new to Crystal Reports. I have managed to write a conditional formula (it is my first and only took 15hrs to figure out). Table name is 360 two of the fields in the table are "Relationship" and "Score" Conditional_Client If {'360_'.Relationsnhip}="Client" then...

Hello very new to writing sql,I need to create two new tables from one existing table. One table is all of the data of 1Section and the second table is all of the data of 2Section. I have been trying but not getting it. Any help is very appreciated. Thanks | ID | SUBJECT | RELATIONSHIP |...

Hello, Odd request maybe, but has anyone seen or have a link to or now how to make a bound transparent form that show the text from a text box. I have found to code for a transparent form but you can not display text on it, which I need to do, i.e I need to place text boxes on a transparent...

Yes it is, a crystal report is where I got the data for my Access tables, it came with fields that were related to the to the fields I was interested in and could not just be deleted and I found them confusing and difficult to work with, thank you again for your help, it was valuable to my...

Hello Duane,Thanks for your help I finally got it to work, this is my first Crystal report and I was a little confused by it. Tim

I did a count on the repetitions of any ID and it turns out some are repeated up to 18 times i.e some people have up up 18 insurance entries, when I looked, all were repetitions of the same entry. So some one might have two distinct insurance entries with one repeated 16 times. So I think the...

Also if this matter's there are 308 unique insurance company's

Hello, I removed the join in the first query and this helped some, I know have only 18 insurance fields, the range in the ColHead column is 1 to 30, it was 1 to 220 and every thing dose depend on the ID field, sorry if I was confusing.

Hello Duane, thank you for the code, I can kind of follow what you wrote but could not have gotten close to writing it. I have tweaked every thing and gotten it to run. Is there a way to move the Insurance codes for any record forward i.e any person has at most 4 insurance providers and the...

Hello, not sure if this is the right forum for this questions. I have a crystal report which I imported into Access, the table is like so ID Insurance Name ID1 Ins1 Name1 ID1 Ins2 Name1 ID1 Ins3 Name1 ID2 Ins1 Name2 ID3 Ins1 Name3 ID3 Ins2 Name3 ID3 Ins3 Name3 ID3...

joelforendo thank you