CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 newbie - creating a report of data between 2 dates

Print topic Send  topic

Author Message
lulazz

Posts: 29
Posted: 07/28/2007, 4:14 PM

Hi,
I am just learning CCS and I am trying to rebuild some simple reporting application using CCS.
The first page is composed of 2 date picker (from and to date) and a submit button.
This brings to a page that shows the data of interests.
Can you please explain me how to build an application like this one (one page with some filters, usually with 2 date pickers, that redirects to a page that shows the data).
Sorry for the question but I am just starting to learn CCS and have still to adapt my mind, I have never used a rad tool before.
Thanks
Lulazz
View profile  Send private message
mamboBROWN


Posts: 1713
Posted: 07/30/2007, 3:51 PM

lulazz
It sounds like you have a search page that sends variables to the details page, which list the details based on the date. Here are some links to get you started:
http://docs.codecharge.com/studio31/html/UserGuide/Builders/Builders.html
http://docs.codecharge.com/studio31/html/UserGuide/Buil...uilder.html?toc
http://docs.codecharge.com/studio31/html/ProgrammingTec...o/Overview.html

You also might want to try searching the forums as well and if you get the time even going through the documentation which is online (links above). Enjoy and welcome to the club :-)
View profile  Send private message
lulazz

Posts: 29
Posted: 07/31/2007, 6:38 AM

Finally I was able to do it...
there was a problem with the date format
:-D
Now I will try implementing new reports using codecharge
thanks and I am sure I'll be back soon :-)
View profile  Send private message
knoops


Posts: 23
Posted: 08/10/2007, 12:36 PM

When you create a report or a grid with a search form, you can do the following:

- Add 2 rows to the searchform
- Add 2 textfields to the searchform named "startdate" and "enddate"
- Add Datepickers to each of them
- Edit the query of the Grid
- Add a WHERE-clause like "Date >= begindate" (select type URL)
- Add a WHERE-clause like "Date <= enddate" (select type URL)

Now the query for the grid will be adjusted to the parameters sent by the searchform.
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.