CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Dependente listboxes (multiple depending from multiple - many to many)

 Print topic Send topic

Author Message
dcosta

Posts: 18
Posted: 01/07/2011, 3:58 PM
Hello all!

Ist it possible to create a page to be used as a parameter form to a report in which there are various listboxes having a relationship of many to many among them?
What I need is to prepare oarameters to call a report in which I get data with a structure likte the following:

One Country having many Regions where there are many Cities where many Companys are installed.
So:
when I choose only a Country the report will bring all the Regions and all Citys and all Companys on that Country;
when I choose a Country and one or various Regions the report will bring get all the Citys and all Companys on those Regions;
when I choose a Country and one or various Regions and one or all the Citys the report will bring all the Companys in those Citys.

I hope I was myself clear.



< 1 Country >
< N Regions >
< N Cities >
< N Companies >

How can it be done?
I'm using CodeCharge 4.3 on Windows XP and the language I'm using is PHP?

If not possible using only CodeCharge (PHP + AJAX+...) do You know if there is some ad on tool to CodeCharge I can use?


Thanks in advance
Dias Costa
View profile  Send private message
datadoit
Posted: 01/07/2011, 4:44 PM
http://examples.codecharge.com/Ajax/DependentListBox3.php
CodeChargeMVP

Posts: 473
Posted: 01/10/2011, 8:21 AM
Yes, in our main project this is our daily bread,we use Jasperserver by making the reports.

Quote dcosta:
Hello all!

Ist it possible to create a page to be used as a parameter form to a report in which there are various listboxes having a relationship of many to many among them?
What I need is to prepare oarameters to call a report in which I get data with a structure likte the following:

One Country having many Regions where there are many Cities where many Companys are installed.
So:
when I choose only a Country the report will bring all the Regions and all Citys and all Companys on that Country;
when I choose a Country and one or various Regions the report will bring get all the Citys and all Companys on those Regions;
when I choose a Country and one or various Regions and one or all the Citys the report will bring all the Companys in those Citys.

I hope I was myself clear.



< 1 Country >
< N Regions >
< N Cities >
< N Companies >

How can it be done?
I'm using CodeCharge 4.3 on Windows XP and the language I'm using is PHP?

If not possible using only CodeCharge (PHP + AJAX+...) do You know if there is some ad on tool to CodeCharge I can use?


Thanks in advance
Dias Costa

_________________
Best Regards
Entrepeneur | NT Consultant
View profile  Send private message
dcosta

Posts: 18
Posted: 01/13/2011, 7:15 AM
Hello datadoit !

Thank You for Your answer.

If You look more carefully to my message You'l see I need to select MANY in one listbox and with that many select other many in the next listbox.

Example:
listbox 1 < 1 Country >
listbox 2 < N Regions >
listbox 3 < N Cities >
listbox 4 < N Companies >

One Country having many Regions where there are many Cities where many Companys are installed.
So:
when I choose only a Country the report will bring all the Regions and all Citys and all Companys on that Country;
when I choose a Country and one or various Regions the report will bring get all the Citys and all Companys on those Regions;
when I choose a Country and one or various Regions and one or all the Citys the report will bring all the Companys in those Citys.


Once again
Thank You
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.

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.