Problem with formula

[brucevde]

Crystal generates the Where clause based on the information in the Record Selection formula (Report -> Edit Selection Formula -> Record menu). You don't need the If statement just the following

{lancamentos.livro}="Venda de Mercadorias"

As for the Sum, the easiest way is to add the database field onto the report. Then Right-Click on that object, select the Insert menu item and then the required summary that you want to perform.

[sacramento]

Hi:

And don't know the way to insert from database the field into the report...
I think you refer to the field "txredvaloriva" right?

[VBFnewcomer]

Hi:

And don't know the way to insert from database the field into the report...
I think you refer to the field "txredvaloriva" right?

You should see a Field Explorer to the left (unless you have meddled with the default settings). If it is not visible click View->Field Explorer. You should find several entries click the one which says Database Fields. This should open all the tables/views you have added (Linked) to the CR. Click further the reqd T/V you should find all the Fields of the T/V. Now pull the Field you want to summarize

[sacramento]

ok...Thanks