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 derfloh 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. sandora

    Group record selection

    Now we're getting somewhere. Before I delete there are 90 records, when I delete the {00_Veh_Inventory.Current Veh Loc} = "4" value and then bring it back, there are 97 records and all of the group titles are showing up. I'm still blank as to where I might have set that up though. I remember...
  2. sandora

    Group record selection

    I'll have to wait till tomorrow for the Report Def. It's a remote server and I copied the report to my desktop and ran the Def but I don't think it's complete. When they get the add in loaded I can run it from the server, but until then, maybe this will help: I deleted the group in question and...
  3. sandora

    Group record selection

    I tried those, and I checked them again. There's nothing there. It seems like I remember having to choose from the hitch list like you do when you have a custom list, but I'm not sure.
  4. sandora

    Group record selection

    Crystal Ver 11, access DB - I hate to even ask this because I know it's my own stupidity. I have a report that is fairly simple. There are no formulas, only one group: vehicle_hitch, and a very simple selection statement: {00_Veh_Inventory.Current Veh Loc} = "4" and not...
  5. sandora

    MultiTable Group?

    I actually did post the technical stuff and got no response so I thought I'd try to solve it from a different angle. This is original post, but now I'm thinking its in the grouping. V11,AccessDB This is an example of what my report looks like now. GH1-SP1-Mikey GH2-TrailerType-LQ...
  6. sandora

    MultiTable Group?

    V11, Access DB Is there a way to include 2 tables in 1 group. For instance I have two employees who split one deal and I need for both of them to appear in the group.
  7. sandora

    Splitting details between groups

    V11,AccessDB This is an example of what my report looks like now. GH1-Salesperson1-Mikey GH2-TrailerType-LQ Detail-Deal# Gross Commissions GH1-Salesperson1-Howard GH2-TrailerType-LQ Detail-Deal# Gross Commissions I have this report built and it works great, but now they've discovered that...
  8. sandora

    DB Linking Problem, maybe??

    I think the problem may be with the @salesperson formula: {Emplytable.Lastname}&", "&{Emplytable.Firstname} I think I need for it to look at the alias table also but how do I do that? Or am I completly off base?
  9. sandora

    DB Linking Problem, maybe??

    Okay, I added a second Emply# table alias. It is linked the same way as the other table. Still not showing up on the second person. Not what info you are looking for but here goes: DB1: Emply Table, Emply Table1 DB2: Inventory table DB3: Intro table, Profit table Links: Profit;Deal# to...
  10. sandora

    DB Linking Problem, maybe??

    V11,AccessDB This is an example of what my report looks like now. GH1-Salesperson1-Mikey GH2-TrailerType-LQ Detail-Deal# Gross Commissions GH1-Salesperson1-Howard GH2-TrailerType-LQ Detail-Deal# Gross Commissions I have this report built and it works great, but now they've discovered that...
  11. sandora

    split results

    My links look like this Table1 Table2 Table3 Table4 Co#--------->Co# Deal#------>Intro# SP1---------->Emply# Stock#-------------------->Stock# All are Inner Joins except SP1 to Emply#, it's Left Outer. In table 2 is where SP2...
  12. sandora

    split results

    Thanks, that formula worked great for getting them to show up where they weren't before except that the split deal is not showing up under the SP2's group of deals. Is that what the left outer join is for and can you elaborate?
  13. sandora

    split results

    V11,AccessDB This is an example of what my report looks like now. GH1-Salesperson1-Mikey GH2-TrailerType-LQ Detail-Deal# Gross Commissions GH1-Salesperson1-Howard GH2-TrailerType-LQ Detail-Deal# Gross Commissions I have this report built and it works great, but now they've discovered that...
  14. sandora

    Date Parameters in Report Titles

    Ver11, AccessDB. I have a parameter called {?DateRange} which returns the beginning date of the report, which always falls on the first of a month and the ending day of the report which always falls on the first of a month. But this is for accountants and they want the title to say something...
  15. sandora

    Totals of some sums????

    Ver 11, Access DB - Making a Balance Sheet. Here is what I have: (GH1) Assets (GF2) Cash 644,807 AR 573,803 Etc... (GF1) Total 21,161,638 (GH1) Liabilities (GF2)...
  16. sandora

    Freeform report formulas

    ...This is what the queries look like: Table Acct# Arch Arch Field Acct# Debit Credit Exp:[sumofdebit]-[sumofcredit] Total Sum Sum Expression Criter Like "10*" I'm thinking this may be where my problem lies, in using all these queries. Let me know if this is not enough...
  17. sandora

    Freeform report formulas

    Here is the result of the query for cash in access GL Account SumOfCredit SumOfDebit Expr1 1000-10 $45,327,884.36 $45,783,379.26 $455,494.90 1000-13 $14,400,144.25 $14,504,781.79 $104,637.54 1000-15 $4,518,399.24 $4,529,255.61 $10,856.37 1000-16 $236,672.26 $253,055.67...
  18. sandora

    Freeform report formulas

    You may be right, I am very new to Crystal and I'm trying to be as clear as possible. It is possible that I am making this harder that it needs to be. Here is what the output should like except with more totals. I'm not sure if this is the data you are asking for. Assets Cash...
  19. sandora

    Freeform report formulas

    When I say free form, I mean not using the detail line and being able to put things where I want them. I've done the grouping on the access side. I've tried a couple different things, I've moved my data to different sections, I've tried creating a text box (like a form letter) with my account...
  20. sandora

    Freeform report formulas

    v11, accessdb. Not sure if this is the correct forum for this one. I'm building a Balance Sheet. I've summed each of the account catagories with a db query. For instance: cash 1231 sum of debits and credits 1234 sum of debits and credits Fixed assets 2234 sum of debits and credits 2335 sum...

Part and Inventory Search

Back
Top