I Need my user to select the group by field (s) dynamically during runtime.
I have a DB of students data for example.
I need my user to choose to display this data grouped by Class, by age, by name, ....
and based on his selection the data will be grouped..
Can any one help me with this?
any hint will be really appreciated:) I'm really suffereing with crystal reports
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I'm using c#
I have so many possible options for grouping, the user might choose two different groups at the same time GROUP BY NAME,AGE for example...that's why the second option is totally infeasible.
I have no problem feeding the data in the order (group) I want...but I think this means Feeding the report with an SQL statement.
could u please tell me how to do this?
Thanks
Before you proceed down that road, make sure you understand that you will not have the ability to use Crystal Reports features for group subtotals and group headers. You are not creating groups by sorting the data in advance of feeding it to Crystal Reports, you are only sorting it.
There are a number of ways to use SQL statements with Crystal Reports. What is your database software?
I don't use c#, but here are a few links that may help you:
c#.net and RAS9 Sample
http://support.crystaldeci
Connecting to SQL database with c#
http://support.crystaldeci
http://support.crystaldeci
Creating a dynamic report with c#
http://support.crystaldeci
According to my references
Seagate Crystal Reports 8: The Complete Object
Crystal Royalty Free Help files
You can change the group conditions with the CRAXDRT library and not pay additional royalty. I don't know if this changed with CR9 but my understanding is that allowed capabilities would continue to be allowed only new capabilities would require royalty payment.
In VB (should be relatively easy to change to C#)
IF cboGroupBySelection1 = "CLASS" THEN
REPORT.AREAS("GH").GROUPCO
REPORT.AREAS("GH").GROU{CO
ELSE IF cboGroupBySelection1 = "AGE" THEN
REPORT.AREAS("GH").GROUPCO
REPORT.AREAS("GH").GROU{CO
etc
cboGroupBySelection1 - The field on the form used to select the first group
classfieldnumber - Integer indicating the position in the SELECT statement
good luck
mlmcc
Thanks a lot to all of u for ur help:))
Fot those who might need to do this later the steps are:
Create a new parameter field, name it GroupName for example. and in the formula editor select any field initially.
in report editor add a new group. make this group refer to the selected formula.
then whenever u need to change it from the code add this line:
myReport.DataDefinition.Fo
Thanks:)
Business Accounts
Answer for Membership
by: DRRYAN3Posted on 2003-09-03 at 08:00:08ID: 9277506
Without using the runtime designer (CRAXDDRT instead of CRAXDRT library), I don't think you can do this with groups. Using this library requires royalty payments and the use of VB or some other programming language. You certainly cannot do this with just Crystal Reports - a program will be required.
If you are looking for a simple sort and can design your report without groups, you can feed Crystal Reports the data sorted the way you need to see it and it will be displayed in that order.
The alternative may be to design several reports, each with a different group layout. Using your favorite language, select the appropriate report template based on the user's selection.