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 -> ASP

 Display Grid Quandry

Print topic Send  topic

Author Message
jshulse

Posts: 9
Posted: 11/17/2011, 1:47 PM

I have a master file that contains company names. I also have 2 detail files, 1 contains the states that the company does business in and the other has the products they sell. I have created a query that pulls the data together such that I have multiple records per company based on the number of states and products. I want to search the query and if I get multiple hits on the same company I only want to display the company once in the grid. Any suggestions? I am using studio 4.3.
View profile  Send private message
lboeldt

Posts: 53
Posted: 11/22/2011, 5:10 PM

You could have the search form post to a report page. Then use the grouping feature and group by company name. This will display each company as a header for the group and all the subsequent details records below each group heading. Like this:

Company Name 1
Detail Record 1
Detail Record 2
Detail Record 3

Company Name 2
Detail Record 1
Detail Record 2
Detail Record 3

...
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.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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