Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by timhans

  1. timhans

    How to get top 2 variance

    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...
  2. timhans

    How to print report to pdf by members of group

    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.
  3. timhans

    How to print report to pdf by members of group

    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...
  4. timhans

    Format zero in chart to hyphen or null

    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...
  5. timhans

    Format zero in chart to hyphen or null

    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...
  6. timhans

    create two new tables from one existing table

    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 |...
  7. timhans

    Transparent form with text

    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...
  8. timhans

    Many Records to one

    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...
  9. timhans

    Many Records to one

    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
  10. timhans

    Many Records to one

    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...
  11. timhans

    Many Records to one

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

    Many Records to one

    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.
  13. timhans

    Many Records to one

    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...
  14. timhans

    Many Records to one

    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...
  15. timhans

    combo box to open on nth entry

    joelforendo thank you
See more

Part and Inventory Search

Back
Top