CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 master-detail

Print topic Send  topic

Author Message
Rookie
Posted: 11/12/2003, 6:58 AM

I have 2 forms in a page, the page filter data based in a url parameter, but
the page displays data like this:

Form1.1
Form1.2
Form1.3
Form1.4

Form2.1
Form2.2
Form2.3
Form2.4

but i need this:

Form1.1
Form2.1

Form1.2
Form2.2

Form1.3
Form2.3

it can be done?

DonB
Posted: 11/12/2003, 9:33 AM

Hello Will,

The "master-detail" aspect is not clear in your example. The thing to the
right of the decimal is the "master" and the thing to the left is the
"detail"?

Seems like you would want a grid at the top of the page with the
".1,.2,.3,.4" master records listed and each one having a link with this
value (to the same page) would do it. Just add detail form1 and detail
form2 below the grid and set their datasources to receive the URL parameter
from the link. Then, clicking a link in the grid would list the two detail
data sets for whatever you clicked.

--
DonB

http://www.gotodon.com/ccbth


"Rookie" <pcboss1976@hotmail.com> wrote in message
news:bothrg$636$1@news.codecharge.com...
> I have 2 forms in a page, the page filter data based in a url parameter,
but
> the page displays data like this:
>
> Form1.1
> Form1.2
> Form1.3
> Form1.4
>
> Form2.1
> Form2.2
> Form2.3
> Form2.4
>
> but i need this:
>
> Form1.1
> Form2.1
>
> Form1.2
> Form2.2
>
> Form1.3
> Form2.3
>
> it can be done?
>
>

rookie
Posted: 11/13/2003, 10:14 AM

You're rigth, it's doesnt clear....it's something like this:
I have a search form, based in the class field, a class have many students,
I need to display the classes detail and the student's details, search works
fine, but it shows this:

class office2000
class vb
class foxpro
students of office2000
students of vb
students of foxpro
--------and I need this
class office2000
students of office2000
class vb
students of vb
class foxpro
students of foxpro

isnt really a master -detail page, there're two form that receive the same
parameter (s_class) from the search form.
I'm using CCS & ACCESS
in CCS the form are like this:

CLASSESS_FORM
STUDENTS_FORM

we just buy CCS becaus im a newbie in this, and it works so fine, that my
boss doesnt stop asking for new and "harder to do" things... :-(
thanks in advanced...


"DonB" <~ccbth~@gotodon.com> wrote in message
news:botqss$gq0$1@news.codecharge.com...
> Hello Will,
>
> The "master-detail" aspect is not clear in your example. The thing to the
> right of the decimal is the "master" and the thing to the left is the
> "detail"?
>
> Seems like you would want a grid at the top of the page with the
> ".1,.2,.3,.4" master records listed and each one having a link with this
> value (to the same page) would do it. Just add detail form1 and detail
> form2 below the grid and set their datasources to receive the URL
parameter
> from the link. Then, clicking a link in the grid would list the two
detail
> data sets for whatever you clicked.
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Rookie" <pcboss1976@hotmail.com> wrote in message
>news:bothrg$636$1@news.codecharge.com...
> > I have 2 forms in a page, the page filter data based in a url parameter,
> but
> > the page displays data like this:
> >
> > Form1.1
> > Form1.2
> > Form1.3
> > Form1.4
> >
> > Form2.1
> > Form2.2
> > Form2.3
> > Form2.4
> >
> > but i need this:
> >
> > Form1.1
> > Form2.1
> >
> > Form1.2
> > Form2.2
> >
> > Form1.3
> > Form2.3
> >
> > it can be done?
> >
> >
>
>

DonB
Posted: 11/13/2003, 11:53 AM

To do what you describe, you will need to define a query that returns the
following columns:

classname, studentname, <other class or student columns if needed>

You need a query that performs a SQL join between the Class table and the
Student table to get the results shown above. You should also sort the
query results by (classname, studentname) in that sequence.

Now you can put the results into an ordinary grid to get the output you
requested.

You can enhance the appearance by hiding the classname when there are
duplicates. All you have to do is put a small amount of code into the
BeforeShowRow event. For the details on how to do this, search for "Simple
Report with Groups" in the CCS help file. There is a very good example shown
there on how to do this.

--
DonB

http://www.gotodon.com/ccbth


"rookie" <pcboss1976@hotmail.com> wrote in message
news:bp0hmv$ksv$1@news.codecharge.com...
> You're rigth, it's doesnt clear....it's something like this:
> I have a search form, based in the class field, a class have many
students,
> I need to display the classes detail and the student's details, search
works
> fine, but it shows this:
>
> class office2000
> class vb
> class foxpro
> students of office2000
> students of vb
> students of foxpro
> --------and I need this
> class office2000
> students of office2000
> class vb
> students of vb
> class foxpro
> students of foxpro
>
> isnt really a master -detail page, there're two form that receive the same
> parameter (s_class) from the search form.
> I'm using CCS & ACCESS
> in CCS the form are like this:
>
> CLASSESS_FORM
> STUDENTS_FORM
>
> we just buy CCS becaus im a newbie in this, and it works so fine, that my
> boss doesnt stop asking for new and "harder to do" things... :-(
> thanks in advanced...
>
>
> "DonB" <~ccbth~@gotodon.com> wrote in message
>news:botqss$gq0$1@news.codecharge.com...
> > Hello Will,
> >
> > The "master-detail" aspect is not clear in your example. The thing to
the
> > right of the decimal is the "master" and the thing to the left is the
> > "detail"?
> >
> > Seems like you would want a grid at the top of the page with the
> > ".1,.2,.3,.4" master records listed and each one having a link with this
> > value (to the same page) would do it. Just add detail form1 and detail
> > form2 below the grid and set their datasources to receive the URL
> parameter
> > from the link. Then, clicking a link in the grid would list the two
> detail
> > data sets for whatever you clicked.
> >
> > --
> > DonB
> >
> > http://www.gotodon.com/ccbth
> >
> >
> > "Rookie" <pcboss1976@hotmail.com> wrote in message
> >news:bothrg$636$1@news.codecharge.com...
> > > I have 2 forms in a page, the page filter data based in a url
parameter,
> > but
> > > the page displays data like this:
> > >
> > > Form1.1
> > > Form1.2
> > > Form1.3
> > > Form1.4
> > >
> > > Form2.1
> > > Form2.2
> > > Form2.3
> > > Form2.4
> > >
> > > but i need this:
> > >
> > > Form1.1
> > > Form2.1
> > >
> > > Form1.2
> > > Form2.2
> > >
> > > Form1.3
> > > Form2.3
> > >
> > > it can be done?
> > >
> > >
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

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.