CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

 Ideas for doing a group by in a grid

Print topic Send  topic

Author Message
E43509

Posts: 283
Posted: 02/02/2004, 7:40 AM

On my grid, I really want some of the repeating data to no display over and over again (ie like name). Any ideas on how to do this in vb.net
My grid looks like
Name training
Tom english 102
Tom history 101
Tom science 200
Bill english 102
Bill music 200

I want it to display as:
Tom english 102
       history 101
       science 200
Bill english 102
       music 200
View profile  Send private message
Rick

Posts: 52
Posted: 02/02/2004, 9:10 AM

I think think the following should work.

1. Use the Before Show Row event of the grid to do following in code.
2. Check each new row (except the very first row read) to see if the name (key) is the same as the previous row.
3. If it is the same person then move blank value "" to name label so the name is not displayed.

That should do it.

Rick
View profile  Send private message
E43509

Posts: 283
Posted: 02/02/2004, 10:17 AM

Sounds good. I'm new to asp.net and I don't quite understand the scoping of variables. How would I 'save' the previous value or get the previous row value to compare. I assume I need to store it somewhere
View profile  Send private message
E43509

Posts: 283
Posted: 02/02/2004, 10:17 AM

Sounds good. I'm new to asp.net and I don't quite understand the scoping of variables. How would I 'save' the previous value or get the previous row value to compare. I assume I need to store it somewhere
View profile  Send private message
E43509

Posts: 283
Posted: 02/02/2004, 11:55 AM

Got the answer from CCS support. They have the solution in the help file.

Please refer to CCS Help/Examples and Techniques/Programming/Simple Reporting/
Simple Report with Simple Grouping.

View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.