Grouping

[Ramon]

Hello, i need some help

In my report i have the next query

SELECT        TOP 100 Me_Sicex.FOLIO, Me_Sicex.PERMISO,  Me_Sicex_Dtl.DESCRIPCION
FROM            Me_Sicex INNER JOIN
                         Me_Sicex_Dtl ON Me_Sicex.FOLIO = Me_Sicex_Dtl.FOLIO

I want to make a group for the three data fields, but when i show the report i doesn't make the group correctly.

In the group options i put the three fields but i don't see it works correctly.

Then i group it in the sql query analizer and it group them right. Here is the query:

SELECT        TOP 100 Me_Sicex.FOLIO, Me_Sicex.PERMISO, Me_Sicex_Dtl.DESCRIPCION,
FROM            Me_Sicex INNER JOIN
                         Me_Sicex_Dtl ON Me_Sicex.FOLIO = Me_Sicex_Dtl.FOLIO
group by Me_Sicex.FOLIO, Me_Sicex_Dtl.DESCRIPCION, Me_Sicex.PERMISO

What am i doing wrong??

Need Help Please!!!

Sorry for my bad english.

[Ivan]

Hi Ramon,

I have attached a report with three field grouping. The report uses the AdventureWorksT database (the database used by Telerik Reporting installer).

In the attached files, please review how data is set in the Report's and Group's Sorting property.

 
Best wishes,
Ivan
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center