Group required at CR?

[karnd]

Hi,

I have a question(i am new to CR but not very new)

Suppose the Groups created at the DB level on the SQL query then should i need to create GROUP on those item in Crystal?
In that case, should the values make difference on the report(reason asking - i am dealing with the amounts and percentages at the detail level under those GROUP items)

If the values differs then instead of GROUP should i use SECTION?

one more question - What is an equivalent concept in Crystal for the Page Breaks?

Please throw valuable hints
Regards,

 

[karnd]

Hi,

Could some one provide hints on the previous questions, please?

Regards,

 

[IdoMillet]

Perhaps it's just me, but I don't understand your questions.
Consider rephrasing.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Ido is right, this is a little hard to follow. If you created a SQL query in order to create a group summary, as in:

select
min(table.`amt`) as minamt, table.`ID`
from
`table` table
group by table.`ID`

...you would still need to insert a group on {table.ID} in the report. The value minamt would be a summary with the same value if placed in the detail or in the group section.

For page breaks, you would go into the section expert and select the section where you want the page break to occur and then check either "new page before" or "new page after".

-LB

 

[karnd]

Hi,

I am sorry if the question does not make sense but with the answer i will make sure once the data populates(it is yet to be populated that is why i put the question) and get back to you.but looks like i got what i wanted from you.

I will try as per said for the Page breaks.

Regards,

 

[synapsevampire]

I'm not sure why you would need a group within the report if you're not doing anything iteratively at the group level within the report.

Most databases will return the data sorted by the group, and you can just palce the rewsults in the details.

-k