Search results for query: *

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

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

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.

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

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

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.

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

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?

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

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

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

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?

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

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

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

I'm not sure how to get SQL from Access so I'm going to try to explain my source data. I have a db called Data5. It contains a table called GL_Accounts and GL_Trans_Archive (it contains others but these are the two I've used). The GL_Accounts contains account numbers and descriptions, etc. The...

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

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

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

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