Extracting Specific Data

[ruth999]

I'm using CR 7.

I'm attempting to create an invoice that details Equipment totals, Shipping Totals, and Expendables Totals. All of this information has been line-itemed in one database. Shipping fees are listed as "Deliver / Recover Charge" in the same database that lists each individual item we have up for rental.

How can I extract this information specifically AND include the cost of same (often arbitrary and decided by the individual booker.) The best I have been able to do so far is get the report to True/False me on whether or not "Deliver / Recover Charge" is listed in the report. I can't get it to list the cost.

{hetype2.Description} = ("Deliver / Recover Charge&quot

Thank you,
Ruth

 

[kenhamady]

How many different tables in the database do we need to get this info? What are they called?

What are the fields that we need work with other than description and Cost?

How do we identify Equipment? Expendible? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[ruth999]

Ken,

All this information is in the "hetype.DB"
The tables containing the information are
"description" > "Deliver / Recover Charge" & "Expendable Items" & and Equipment is detailed by item, "Studio Spot", "Studio Color", etc.
"daily" > lists prices for items, where I need to get numbers from

I hope that decribes it well enough!

Thank you,
Ruth

 

[kenhamady]

Sorry, you lost me.

I think you are confusing tables with fields. A field is a column, a table is made up of multiple columns. A database is made up of multiple tables. Is the DB a paradox database with several tables or a single table with fields like "Description"?

Could you try again?


Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[ruth999]

Ken

This is what happens when electricians try to be computer programmers! Thanks for your patience.

The database is "hetype"

The table is "Description"
The fields I need are "Deliver / Recover Charge" & "Expendable Items"

The second table within "hetype" database that I need is "daily".
The fields within "daily" are all the prices I need.

It was easier learning Russian!

Thanks,
Ruth

 

[kenhamady]

Ruth,

I think you missed again. Tell me if this makes sense.

The table is "hetype"

It is made up of rows and columns.
One of the columns is "Description"

In this column on different rows are values like:
"Deliver / Recover Charge"
"Expendable Items"

Another column is the "daily" column.
This has numbers representing the prices.

Are we close? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[ruth999]

Ken,

Yes. I was interpreting "hetype" to be a separate database, that was my mistake.

Ruth

 

[kenhamady]

So, put the fields description and daily on the detail band.

In the select expert, add a rule that says:

Description /
is one of/
and then use the pull down to select each of the descriptions you want to include. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)