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

 Search and Grid Builder improvement

Print topic Send  topic

Author Message
eserver220

Posts: 41
Posted: 04/11/2006, 8:46 PM

I think Search and Grid Builder should not be tightly connected.
The relationship between Search and Grid Builder should be one to many.
It should be like this, there is a field called "TYPE" in Search, Based on different values of "TYPE" , the final page will show different Grid. It just like the excel file with several sheet, but only with one Search Grid. This implementation can greatly improve the presentation capability of Search & Grid Builder.
View profile  Send private message
WKempees
Posted: 04/12/2006, 3:22 AM

Maybe I don't really grasp your idea, but I think this is already possible.
Although when using GridBuilder it results in Search and Grid, they are not
really tight together, nothing stops you from
A/ putting more than one grid on the page (with or without panels to hide
them (but one)
B/ making the grids (and their panels) react to the Search data and thus
doing exactly what you describe.
C/Putting several Grids each on their own pages and jump there depending on
"Type".

The Search is merely a dumb form that accepts your search criteria input, it
then recalls (if not modified) the page it's on.
CCGetFromGet() can identify (in your example) the contents of "Type".
Each grid on the page can have a CCGetFromGet("Type","") in it's BeforeShow
or in the Pages BeforeShow (to set visibility on the Panels.

Good idea though, but I doubt the builder could or should be made to cater
for multiple grids as there are also multiple ways to implement.
(I, for one, would hate a Builder that outsmarts me!)
Walter


"eserver220" <eserver220@forum.codecharge> schreef in bericht
news:22443c780a261c1@news.codecharge.com...
> I think Search and Grid Builder should not be tightly connected.
> The relationship between Search and Grid Builder should be one to many.
> It should be like this, there is a field called "TYPE" in Search, Based
> on
> different values of "TYPE" , the final page will show different Grid. It
> just
> like the excel file with several sheet, but only with one Search Grid.
> This
> implementation can greatly improve the presentation capability of
> Search &
> Grid Builder.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

eserver220

Posts: 41
Posted: 04/15/2006, 10:47 PM

WKempees, thank you. Your post helps me a lot.
But Will this impose a heavy load on server ? Every grid will rettieve data from database table, but only one grid data will be finally used.
If I merely add custom code in Before Show Event, how about I change Grid into Edit Grid? In such occasion, usually the grid key would be same, Will the CRUD operation impose side effect on other grids which I am not intended for?
View profile  Send private message
WKempees
Posted: 04/16/2006, 7:17 AM

Have to investigate deeper (after tuesday that is), but I think Grids inside
panels which are disabled
are not fetching data, if they are you could easily modify that behaviour.
From the back of my head, in each grid, before execute select, if panel
hidden, ds->SQL ="Select * from dual".
I have build a calendar example that is using several Forms, Calender and
grids, each displayed only when necessary.


"eserver220" <eserver220@forum.codecharge> schreef in bericht
news:224441da5422d96@news.codecharge.com...
> WKempees, thank you. Your post helps me a lot.
> But Will this impose a heavy load on server ? Every grid will rettieve
> data from database table, but only one grid data will be finally used.
> If I merely add custom code in Before Show Event, how about I change
> Grid
> into Edit Grid? In such occasion, usually the grid key would be same,
> Will the
> CRUD operation impose side effect on other grids which I am not intended
> for?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


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.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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