Question for Ibass (TechnicalUser) 1

[Myla944]

Hello,

You helped me the other day with a parameter/date question for our bakeries,which I really appreciate what you wrote.
I have two questions:

My first question:

I had my companies showing up on my report by linking to (tblCompany.CompCode), when I added a new table (tblBudgetManufactured) which also has a CompCode on there and only shows manufactured product from 2 bakeries, all the other bakeries disapeared. Do I need to have our Tech add the other companies to the BudgetManufactured table so that all the bakeries will show up? I am stumped on this one. I was using a a selection of True so it would show all the companies, then I tried this formula:
If {tblInvoice.CompCode} = 01 then "New South West Baking"
else if {tblInvoice.CompCode} = 02 then "Mississippi Baking"
else if {tblInvoice.CompCode} = 03 then "Georgia Warehouse"
else if {tblInvoice.CompCode} = 05 then "Mid South Baking"

This did not work either. I then changed my links and it still did not work, as I had them originally linked by CompCode, but then I changed the Budget Manufactured Table to the Sku Number hoping that might work, but it did not work.

Second question - I am using the book entitled "The Complete Reference for Crystal Reports 9. Could you recommend a book that deals more with the formulas for Crystal 9?

Thank you and have an awesome day today,

Myla944

 

[synapsevampire]

1st question: Try using a Left Outer Join, not an equals

2nd question: There are lots of resources for advanced Crystal formulas on the web, you might be more specific about what you want to learn.

The Business Objects Crystal Reports Advanced search page for the Knowledge Base:

http://support.businessobjects.com/search/advsearch.asp?q=

Largest technical support forum for Crystal reports on the WEB:

http://www.tek-tips.com

Become a member (free and no spam as a result), and then search for Crystal and join all of the forums.

Other useful sites:

http://www.kenhamady.com

http://www.hammerman.com

-k

 

[Myla944]

I want to learn as much as I can and how to work on Crystal Formulas and SQL formulas to use in Crystal. Thank you for all your help. I really appreciate it. Have an awesome day today.

Sincerely,

Myla