Technical Questions: Report not displying all data

Report not displying all data

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5718
Printed Date: 06 May 2024 at 6:29am

Topic: Report not displying all data

Posted By: LCLP Kevin
Subject: Report not displying all data
Date Posted: 07 Mar 2009 at 10:28am

I am creating a reorder report from an Access database.

The database calculates using data from 4 tables within the database

Adjustment

Issue

Return

Receive

The formula is (receivedqty)+(returnqty)+(adjqty)-(IssueQty)

The inventory Items are in the stockcode table

All tables contain the stock code and are linked by this field

My problem is that the report is not listing all inventory items when I insert a value from one of the 4 tables used in the calculations. I think the problem is centered around the fact that all stockcodes have not experienced adjustment, receive, return, or issue, so any stockcode not in these tables is excluded.

How do I get the report to continue to list all stockcodes from the stockcode table and list the values from the other tables?

Thans for your help!

-------------
Kevin

Replies:

Posted By: DBlank
Date Posted: 08 Mar 2009 at 8:35pm

are you using left joins in your table connections?

Posted By: LCLP Kevin
Date Posted: 09 Mar 2009 at 3:34pm

Yes,

I figured out the join issue Satuday afternoon.

I am now displaying the data, but still have a few issues.

I need to sum the values for each stock code, and have written a simple formula to do so, but when I place this formula in the report I am getting blank fields.

The other issue is that is there are multiple entries for a stockcode in a table (ie.. the part has been issued on more than on occasion) I am getting a line in the report for each transaction.

Thanks for the help

Kevin

-------------
Kevin

Posted By: DBlank
Date Posted: 09 Mar 2009 at 5:25pm

For #1 what is the formula you are using thtis returning blanks? Too hard to figure out what it is doing without seeing that.

For #2 if you have it designed where the duplicate records are always following one another in the rows you can use a formula with variable and previousrecord<>current record to get a distinct value then sum on the formula field.

There a lot of examples of this process on this site....

http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=5623 - http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=5623