Grouping data on the fly at crystal report

[Jonathan Woods]

Hi there,

How do i handle grouping same level of data at run time? or any idea?
user can view data according to their selection group on the windows
form.

for example: In customer table, (Group by City) or (Group by Country)
-----------
The following code does not compile...

FieldDefinition myFieldDef = new FieldDefinition();
myFieldDef = rs.Database.Tables["tblCust"].Fields[groupby];
rs.DataDefinition.Groups[2].ConditionField = myFieldDef;

But It doesn't work due to FieldDefination Class at protection level.

Any Idea?

Thanks in advance.

[Mohamoss]

Hi Jonathan
f you are to create reports dynamically you can use the Report Designer
component (DRC). There is version 9 available. See this link for its file
requirements

<http://support.businessobjects.com/library/kbase/articles/c2012421.asp>
And here you are the link of to get all available samples on how to use DRC

<http://support.businessobjects.com/c...s/apps_rdc.pdf
..asp>

Here you are also some links that I think could be most helpful

First look at this sample in this link that describes How to create a
Dynamic report using C#. I would say this could be all what you need to
know
<http://support.crystaldecisions.com/...es/csharp_win_
dynamic_report_formula.exe.asp>
If you are using The Microsoft SQL server Database these also are very good
samples

<http://support.crystaldecisions.com/...es/csharp_web_
simplelogonviewer.exe.asp>
<http://support.crystaldecisions.com/...es/csharp_win_
dbengine.exe.asp>
hope this helps
Mohamed M .Mahfouz
Developer Support Engineer
ITWorx on behalf of Microsoft EMEA GTSC