Show value of a field before pulled date range

[1Taran]

I am building a report that needs to show a beginning inventory.Date is based on a parameter field and the beginning inventory is based on a field that shows the volume just before the pulled date range. How can I get this value from the field to show up in the footer of the report.
Report looks something like this:
Tank: 200
HFO Descri Received Shipped Date
1064 Buff-oo 6,000 0 04/04/05
10697 Transfer 0 2,000 04/05/05

Begin Inventory Receipts Shipped Ending Inventory
03/31/05 9,000 6,000 2,000 13,000

 

[synapsevampire]

Just curious, when you reread your post, does it make sense that others might understand it?

"needs to show a beginning inventory.Date is based on a parameter field and the beginning inventory is based on a field that shows the volume just before the pulled date range"

What field? What is a pulled date range?

In general it's best to post technical information in an organized manner:

Crystal version
Database/connectivy used
Example data (show the fields and the data)
Expected output

Descriptions rarely convey requirements well.

-k

 

[1Taran]

ThanK You.
Sorry it wasn't clear enough.
I will try to clarify.

We are using Crystal version 10, Data comes from SQL server Requirement is to show oil transferred into the tank and shipped out of the tank. Level of oil before a selected date range needs to show in a field called beginning inventory. And level of oil on the last day of the selected range needs to show in a field called ending inventory.

Example of report
Tank: 200
HFO Descri Received Shipped Date
1064 Buff-oo 6,000 0 04/04/05
10697 Transfer 0 2,000 04/05/05

Begin Inventory Receipts Shipped Ending Inventory
03/31/05 9,000 6,000 2,000 13,000

I am looking to include a beginning inventory value from a field called END GSV in the report. I have a parameter set up for a start and end date range.
So scenario:
if I want to show oil that was received into the tank and shipped out of the tank for all of June, we use the parameter field that has been set up to pull that date range(everything is good at this point). The problem is that the value for the beginning inventory is for May 31 just Prior to the selected date range and we are having a difficult time getting that value for the beginning inventory(from the END GSV field) to show in the group footer. We do not want to include in the date range selected May 31 because it throws off some other values in the report.

I hope this clarifies what I am attempting.

 

[synapsevampire]

So you want a value for a field which you won't be pulling into the data set?

Note my previous post where I suggested that you supply technical information to include example data, which you didn't include.

You might use a subreport to pull in this data by adjusting it's record selection formula to say:

{table.datefield} = {?MyDateParm}-1

Or you can include the data in the original query and suppress any display/summaries to not include the data for the first date.

-k

 

[lbass]

If you use the subreport route, you will have to create a shared variable within the subreport and then reference it in your main report calculations.

-LB