Monday, 15 March 2010

detail - Need to do 2 group in Crystal report -


Hello I need to make a report in crystal reports with 2 groups, first of all, Groove: Turnerblue Project and second: expense . Example:

For example:

  -project1 -project2 -project3   

Group 2 Exax

  -expence 1 -expence 2   

Each project note is in a datatable and each expence is in another datatable and I think I only know the items that are selected when I enter inside

You need help for Ty :)

Ideally you should create a scene that is both Makes liqueurs (to handle that you are using a SQL based data source), it will need to be something like:

  see MYVIEWNAME as the selection 'project' Select [TypeName], Somefield, SomeOtherField MyProjectTable Unions as the 'Spend' [TypeName], Somefield, SomeOtherField from MyExpenseTable   

Then once you have it in a crystal As a source, you can first group / project by TypeName The group can group by expenditure.

You want to display different details, create a new statement section, and suppress the formula for the suppression form {Mytable.TypeName} = "Project" To add project section

No comments:

Post a Comment