The reports on the reports menu are based on Crystal works tables that do not exist until the print program is run. If you try to edit the form code and refresh while in the designer no data will appear because the works tables are not populated. You have to save and close and run from the Print panel off the reports menu.  Also how did you add the product line to the report as it is not normally part of the table. The correct way to do it is to create a UDF and add to works table. DO NOT link in tables. 

Hi BigLouie... I understand that previewing within designer will not produce any data. I had saved in designer then went out to Sales Order Reports menu reran the report but instead of selecting STANDARD I selected the new Report Setting I created named PRODUCT LINE and here no data displayed but the PROD LINE header did displayed.  Its almost seems like the new report is not pointing to the tables correctly.  I'm doing all this within a test company where I had copied the production company into.  

Does your report have any tables other than the work table? (Don't do that... add a UDF to the work table instead, like BigLouie advised).

Did you change the report's data source? (Reports run from within Sage need the report's data source to be configured correctly).

Both of those things can easily break a report's functionality.

Are you using SQL / Premium?  Or Standard / Advanced?

So that was it... I did have the CI_Item table added so I removed it then created the UDF then added it to report and now I see the data on the report.  Thanks for the help gents.. 

So that was it... I did have the CI_Item table added so I removed it then created the UDF then added it to report and now I see the data on the report.  Thanks for the help gents.. 

Sorry about this but I did want to add a question to this post... if I can't I will post another. Now that I have the report working I created in a test company so what is the best way to move what I did to our production company?? 

I use Windows Explorer to copy the Crystal Report between company codes manually.

\MAS90\MAS_###\Reports\##_#####PRINTING\FormCodeName\TheReport.rpt

When you create a report the system makes a folder in the Reports folder under the company code. So if you look as MAS_XXX where XXX is the company code you will see a folder called Reports and inside of that you will see a folder called SO_SalesOrderandquoteHistory.  Inside of that you will see the report.  In live company create a new report and make a slight change so the system will create the folder. Then just copy from the test company to live company folder and over write the one you made the slight change to.

Ok.. I did what you suggested and I do get the correct report however I notice when I select Database Expert in field explorer within Crystal it prompts me for username/pw which is fine but I notice the data source is the test company not the production company... does that matter now that the report is in the production company. 

Nope. If you run from reports menu it will use same company you are in.  

If you use a named DSN (other than SOTAMAS90), it won't work, but that is easy enough to test.

If you are on Premium / SQL, the fix is a bit more complicated...

We do use Premium / SQL... 

OK, if it works, that is all that matters.  If the form doesn't work after copying to the different company code, I can point you in the right direction.  The most annoying problem is if the "Trusted Connection" is selected... that breaks reports / forms.  (Sage uses SQL authentication while printing).

I'm having the user run the report several times with different filters making sure the data is correct.. You guys are great I really appreciated the help... crossing my fingers data is good.