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

 how to display a schedule using grids

Print topic Send  topic

Author Message
minhski

Posts: 2
Posted: 02/28/2004, 6:46 AM

This was posted on the PHP forum as well.

I have a reservation table like so:

ResvID
CustomerID
BallFieldID
ResvDate
TimeStart
TimeEnd

Think of a park with 4 baseball fields. I want to show the reservations of each BallField group by ResvDate and sorted by TimeStart, like a reservation calendar where each column represents a date of the week, and within each column, I want to show the Customer Name, and the time of the reservation.

Date Date Date
============================
CustID CustID CustID
TimeStart TimeStart TimeStart

I'm new to CCS, and generating the reservation records by the row is trivial enough. But with this it becomes a challenge and I've been scratching my head on how to manipulate CCS's grid object.

Thanks for your advice.

Minh
View profile  Send private message
DonB
Posted: 02/28/2004, 9:09 AM

Something that's important to understand is that a "row" can mean either a
row of the source table OR a row in the HTML table. These are not the same
things. In fact, a row doesn't even have to look like a row - it could be a
column, or whatever you want it to look like.

The HTML presentation can be changed around to whatever you like (even
eliminating all the <table>, <td> and <tr> tags. The source data rows are
defined by the <!-- BEGIN --> and <!-- END --> tags. You can put in any
sort of HTML you like as long as you preserve these tags. So advanced html
techniques like "flowing column" layouts are possible. The HTML <table>
that CodeCharge creates is just a baseline for you to work from.

If you were to imagine the rows grouped by Customer and each customer was in
a <div> block, it seems like you could do this fairly easy by manipulating
the CSS attributes position, top and left (e.g., putting something like
style='position: relative; top: 0; left:0' into the <div> tag). The best
thing to do is peruse any of the numerous HTML and CSS sites to learn more
about this. I have several listed under "Sitelinks" on my website, one of
which is http://www.zvon.org. Also you can search google for "html box
model" which should turn up a few good links.

This is one of the great things about templated development the code lives
separately from the visual layout, so you can lay it out any way you want
without being limited by what the code lets you do.
--
DonB

http://www.gotodon.com/ccbth


"minhski" <minhski@forum.codecharge> wrote in message
news:64040a9b72028f@news.codecharge.com...
> This was posted on the PHP forum as well.
>
> I have a reservation table like so:
>
> ResvID
> CustomerID
> BallFieldID
> ResvDate
> TimeStart
> TimeEnd
>
> Think of a park with 4 baseball fields. I want to show the reservations of
each BallField group by ResvDate and sorted by TimeStart, like a reservation
calendar where each column represents a date of the week, and within each
column, I want to show the Customer Name, and the time of the reservation.
>
> Date Date Date
> ============================
> CustID CustID CustID
> TimeStart TimeStart TimeStart
>
> I'm new to CCS, and generating the reservation records by the row is
trivial enough. But with this it becomes a challenge and I've been
scratching my head on how to manipulate CCS's grid object.
>
> Thanks for your advice.
>
> Minh
>
> ---------------------------------------
> 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.

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.