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!

Search results for query: *

  1. mikefight

    Variables saved in the repository

    I am trying to save a list of variables in the repository then call it in the select formula of my reports. We have crystal reports XI and crystal server running. I can upload a text file with crystal server. But I can not call it from the select formula.
  2. mikefight

    Duplicate Records

    I need to link the Name.SSN to get the account numbers of the loans that need to be added. A member can have more than one account with loans on every account. I need total loans for the SSN even on multiple accounts.
  3. mikefight

    Duplicate Records

    CRXI r1 I have an SQL Database with a Name table and a loan table. I have dropped in the name table twice and the loan table twice. I have a left outer join with the name.SSN = name_1.SSN and name_1.AcountNumber != name.AccountNumber and a left outer join on from the name tables to the loan...
  4. mikefight

    4 tables, accounts, names, shares, cards

    The relevant field is the account. Since the account meets the criteria of not closed it shows. The account is the master table linked to the other three. The tables are linked with inner joins. When I add in details, then alter the select, it removes the details, like the cards, names, and...
  5. mikefight

    4 tables, accounts, names, shares, cards

    Sorry about that I did not understand want you wanted. out of your sample data i would want: account 100 123 main street account 300 345 some street These are in the group section, there is nothing in the detail of my report. This is for a mailing list. So I imported in 4 tables. Linked them...
  6. mikefight

    4 tables, accounts, names, shares, cards

    The detail data shows all the names that do not have a suffix and mutiple times group: 100 123 main st details: 100 123 main st 100 123 main st 100 456 some st 100 456 some st if there is only a name with a suffix then I get group: 100 details: 100 100
  7. mikefight

    4 tables, accounts, names, shares, cards

    I have account:number in the as the group. The I have name:street in the group header. account 100 123 main street account 200 account 300 345 some street
  8. mikefight

    4 tables, accounts, names, shares, cards

    I do not have any or statements. I left it off because that part is working and would just add confusion. The suffix part is working like it designed, I just have the design wrong. It is removing the name record, i do not want it to show the account at all. I have the formula in the group to...
  9. mikefight

    4 tables, accounts, names, shares, cards

    Cr 11 sql data base I have a 4 tables, accounts, names, shares, cards I only want accounts without a certain card type, with a certain share, without name suffix I am getting the account that match the the account statements in the select, such as close date is null on account, but it is also...
  10. mikefight

    Multiple address on record

    You rock man thanks alot.
  11. mikefight

    Multiple address on record

    That worked Awesome, thank you so much. Now if I can just get it to exported to excel.
  12. mikefight

    Multiple address on record

    I am only getting the name type 0 address in the group header. I also tried the below code and got blank. stringVar street; if {NAME.TYPE} = 3 and {NAME.MAILOVERRIDE} = 1 then street = {NAME.STREET}; if {NAME.TYPE} = 0 and street = "" then street = {NAME.STREET}; street;
  13. mikefight

    Multiple address on record

    I did that and I get... account address --------------------------------- 12345 type 0 address 12345 override adress So I am getting both addresses. I only want the override, or the primary if there is no override.
  14. mikefight

    Multiple address on record

    I need to print a specific address. I keep getting the address printing twice or not at all. I am new to cr 11. Crytsal version 11 SQL database name type = o name type = 3 and maileoverride = 1 if account has a name with type = 3 and override = 1 then print override address else print...

Part and Inventory Search

Back
Top