Group Level Summary

[jayaram4urs]

Hi,

Im Creating a report from the two data sources.
Example.
Query1. Data is comming from SAP BW
Query2. Meta data is comming from Oracle

Now I created a report with these two queries by the linking of common columns.

Now Question is .
I want to see the records from SAP BW which are matching to the Oracle along with the Total Summary of SAP BW data.

My Assumption is
When we are creating a report with two sources the link between the two sources will acts like a joiner and it will restrict the values.
SO how to show the total values of SAP BW Query..

I tried in different ways but not able to achieve the solution.

Expecting possible workaround from the experts of the group

 

[synapsevampire]

Link the SAP to the Oracle using a Left outer join.

This will get all rows from SAP, and the matching ones from Oracle, unless you put some record selection criteria on the Oracle side.

-k

 

[jayaram4urs]

HI,

Thanks for the response.

My doubt is if im grouping the records by employee code
I want to show particular Emp COde as detail and particular Emp code as summary is it possible.

I'm a beginner in Crystal

Regards
Jayaram

 

[synapsevampire]

Please be specific, there seems to be a language barrier.

How would an emp code be a summary? Do you mean a count?

Do you mean that you want one of the database types emp code in the details, and the other in a summary?

Please take your time and be specific, you're not making sense.

-kj

 

[jayaram4urs]

Hi,

If i'm breaking the reports into different groups by department ID .

Now My question is

I want to show some of the departments data as detail and some of the departments as summary.

Whats the possible way

Ex:-
User want to see Dept 20 all the employees information (Employee salary one by one )
as well as he wants to see Dept 30 Total Information ( All employees salary )

Regards
Jayaram

 

[synapsevampire]

Place the fields that they need to see one by one (there are called rows and you should try to use real technical terms) in the Details section.

Right click the details and select Hide.

Now create the summaries you need in the group footer, and if they click on the summaries, it will drill down to the details and show each row for that group.

-k

 

[jayaram4urs]

Hi,

Thanks for your response.

Is is possible to show the data without drilling down ..

 

[synapsevampire]

Meaning that sometimes you want summaries for some groups, but you want details and summaries for others?

That would mean using suppression, so right click the details and select format section, X2 next to Suppress and use something like:

{table.dept} = 20

Or you might use a parameter to obtain the list of those they only want summaries for (or vice-versa), and use something like:

{table.dept} in {?MyDeptParameter}

-k

 

[jayaram4urs]

Hi Thanks alot for the help.

Now i'm able to supress the records which are not matching in query1 and query 2

I'm Grouping the records by department wise

Problem is when i'm calculating the summary its displaying sum of the records which are showing , Its not showing the sum of all the records including ( Supressed + Not suppressed).
How to get the total sum of the group