Crystal Reports 10

RMS works with Crystal 8.5.

Even with 8.5 there are usually some issues with the .def files. When you buy RMS, make sure you get the service plan - that will give you access to Customer Source and the knowledge base.

Sorry I can't give you any specifics on Crystal, we've found that we can get the reports we need out of the Active Reports system so I avoid Crystal...

You can do calculated fields in an Active Report - that's what the "Formula" setting in the Column Definition is for - there are many example of this in the reports installed by default - here's an example taken form the Detailed Sales Report:

Begin Column FieldName = "Total" DrillDownFieldName = "" DrillDownReportName = "" Title = "Total Sales" VBDataType = vbCurrency Formula = "TransactionEntry.Price * TransactionEntry.Quantity" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1275 GroupMethod = groupmethodSum ColFormat = "" End Column

Glenn: Your post made me really curious. "Column Definition in an Active Report" Are we talking RMS? Where are you finding this "formula" setting? I can't find what you are talking about, and would like to explore these options...

Peter Johns> You can do calculated fields in an Active Report - that's what the "Formula"

In the ...\Store Operations\Reports directory, you will find .qrp files. These files are the definitions for the reports available from the ReportsMenu in Store Ops Manager - these are "Active Reports". They are text files, so you can open and edit them in Notepad, or any other text editor. If you know SQL, the report definitions are pretty easy to figure out. The last part of the file will contain Column definitions, and the column definitions each have a value called Formula - in most cases this is an empty string, as the column is just supposed to return a single coulumn value from a table, but you can also calculate a value. The "Total" column in the Detailed Sales report is calculated from the Price and Quantity fields of the TransactionEntry table for instance.

Hey Glenn,

Do you have any toruble with overall GP% on reports?

I seem to be having some calcualtion issues for Profit (Ex Tax) GP% in active reports.

Just hoping soemone else has this problem.

Ivan Brebner

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP09.phx.gbl...

Ivan,

Overall GP% does not calculate correctly as you have found. It is a limitation in Active Reports. You could use Crystal Reports to it however. There are 2 reports in the library that calculate a summary GP% for Department and Category, you can use the same logic to create a report that will calculate a summary for Supplier as well. As I write this I just thought of something, you could probably use the same logic to create a summary GP% report for Matrix Items as well. I am going to look at that.

Rob

Hello

Looking to get the Reg Analy to work like a consolidated Z Report. I have made changes to the Orignal Report and have been using for 2 years and have made changes to The time clock report to meet my needs.

Would appreciate any help from someone that understands Crystal Reports 8.5 and RMS to help me out.

Thanks Ralph

Are you good at writing reports with crystal looking for some help?

Can you look at my def and Department report and tell me what might be wrong with it.

I have edited the Reg Analy to match the Z Reading a couple of years ago.

I Aslo created a tax report for the different taxes collect with crystal 8.5

Now I want to create a department sales report.

I need one report that summarizes all the batches closed on the same day. The Reg Analy is great if it had all the same data as the Z Readings for all the POS (DateClosed)

Any advice or help would be appreciated.