Problem displaying my results Easy Question

[nervous2]

I have a stock report for my company which comes from a central database. I am now offering a new system where we will buy product back from our customers, if our stock is low or out while a customer may be sitting on dead stock. I have created an Excel file which will be distributed to all customers listing their dead stock, where I will collect all the data and accumulate it into one database and add it to my existing report.


I would like to see my existing report in full as now, for the products which are located at a different site / customer site I'd like them listed in the same designated area as the existing report but (embedded in the existing report) highlighted in another colour, listed a second time in another colour so staff knows it’s an outside stock.

I have added another database file to my existing stock report and linked the products by our manufacturing #, now I'm listing the products but since the added database (customers dead stock) only accounts for about 2% of our total stock, only the customer products are being listed since they are linking the blank areas. How can I fully list my existing stock report but also link the new report while still displaying the areas where only one location resides?

Sorry it is a bit hard to explain but I know it's shouldn’t be too complex

 

[synapsevampire]

Stating technical information helps, starting with your software version and the database type.

We don't need to know that clients are filling in spreadsheets as the source, but it's useful to know the table structures, example dtaa and the expected output.

Try changing the join to a left outer on the part from your current table to the customer table.

You might be better served with a Union Query rather than a join, but it's hard to know without seeing the structure of the data.

-k

 

[nervous2]

Using Excel to complie the customer's stock then exporting to DBIII, running Crystal Reports 8.0. My spread sheets uses the same tables as the existing report tables.

My exisitng Company database is an ODBC (Pervassive Database) then the added customer database is the DB3 file.

 

[synapsevampire]

So you don't import the db3 files into the Pervassive database?

If that's the case, I would link (not import) all of the tables into an MS Access and build out a query supplying the data you need.

I think that you must prefer that someone else help you as I ask for example data and expected output and you discuss compiling spreadsheets again.

What is required to provide a solution is information about your data source from the standpoint of the report.

Again, state what the source of the report is, not the chain of events getting it there, that doesn't change anything.

-k