Help With Query and/or Design

I am currently trying to model a database and have great difficulty in
determining the correct structure.
General Subject - Aircraft Flights.
Table - Flight ( FlightID = PK, FlightNumber, ClientNumber etc.... ))
Table - FlightLegs (FlightLegID = PK , FlightLegID = FK Date,
AirportDepartID = FK, AirportArrivalID = FK, etc...)
Table - Airports ( AiportID = PK , AirportName, City , Country
etc...) ,
PK = Primary Key , FK = Foreign Key .
The ForeignKeys require a double liaison between FlightLegs and
Airports. ( Is this a bad idea ?).
----
1 : Each flight may have one or more flightlegs.
2 : Each FlightLeg has a Depart Airport and an Arrival Airport.
----
For a given FlightNumber I wish to be able to display a list of all
flightlegs and the appropriate AirportNames.
I am having difficulty trying to create queries where I can get both
"AirportNames" for a given flightleg. I can easily retrieve either the
Departure or Arrival name but cannot seem to get both in one query.
I have simplified my examples for clarity.
No problem here
SELECT AirportName from Airports WHERE Airports.AirportID =
FlightLeg.AirportDepartID FROM Airports
Problem here
SELECT AirportName as Departure,AirportName as Arrival from Airports
WHERE Airports.AirportID = FlightLeg.AirportDepartID AND
Airports.AirportID = FlightLeg.AirportArrivalID FROM Airports
I realise that the above can never work due to the AND condition.
I know that the following works but I don't like this solution.
SELECT
( SELECT AirportName from Airports WHERE Airports.AirportID =
FlightLeg.AirportDepartID FROM Airports) Departure,
(SELECT AirportName from Airports WHERE Airports.AirportID =
FlightLeg.AirportArrivalID FROM Airports) Arrival
FROM Airports
what would be a more elegant solution, is my model incorrect.On Apr 30, 2:11 pm, r.whiteh...@.gyrolan.com wrote:
> I am currently trying to model a database and have great difficulty in
> determining the correct structure.
> General Subject - Aircraft Flights.
> Table - Flight ( FlightID = PK, FlightNumber, ClientNumber etc.... ))
> Table - FlightLegs (FlightLegID = PK , FlightLegID = FK Date,
> AirportDepartID = FK, AirportArrivalID = FK, etc...)
> Table - Airports ( AiportID = PK , AirportName, City , Country
> etc...) ,
> PK = Primary Key , FK = Foreign Key .
> The ForeignKeys require a double liaison between FlightLegs and
> Airports. ( Is this a bad idea ?).
> ----
-
> 1 : Each flight may have one or more flightlegs.
> 2 : Each FlightLeg has a Depart Airport and an Arrival Airport.
> ----
> For a given FlightNumber I wish to be able to display a list of all
> flightlegs and the appropriate AirportNames.
> I am having difficulty trying to create queries where I can get both
> "AirportNames" for a given flightleg. I can easily retrieve either the
> Departure or Arrival name but cannot seem to get both in one query.
> I have simplified my examples for clarity.
> No problem here
> SELECT AirportName from Airports WHERE Airports.AirportID =
> FlightLeg.AirportDepartID FROM Airports
> Problem here
> SELECT AirportName as Departure,AirportName as Arrival from Airports
> WHERE Airports.AirportID = FlightLeg.AirportDepartID AND
> Airports.AirportID = FlightLeg.AirportArrivalID FROM Airports
> I realise that the above can never work due to the AND condition.
> I know that the following works but I don't like this solution.
> SELECT
> ( SELECT AirportName from Airports WHERE Airports.AirportID =
> FlightLeg.AirportDepartID FROM Airports) Departure,
> (SELECT AirportName from Airports WHERE Airports.AirportID =
> FlightLeg.AirportArrivalID FROM Airports) Arrival
> FROM Airports
> what would be a more elegant solution, is my model incorrect.
SELECT FlightLegID,
(SELECT AirportName FROM Airports WHERE Airports.AirportID
=FlightLeg.AirportDepartID ) as AirportDepart,
(SELECT AirportName FROM Airports WHERE Airports.AirportID
=FlightLeg.AirportArrivalID ) as AirportArrival
FROM FlightLegs|||Here is another alternative.
SELECT
fl.FlightLegID,
dep.AirportName DepartureAirport,
arr.AirportName ArrivalAirport
FROM
FlightLegs fl
JOIN Airports dep ON dep.AirportID = fl.AirportDepartID
JOIN Airports arr ON arr.AirportID = fl.AirportArrivalID
On Apr 30, 7:33 am, M A Srinivas <masri...@.gmail.com> wrote:
> On Apr 30, 2:11 pm, r.whiteh...@.gyrolan.com wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> SELECT FlightLegID,
> (SELECT AirportName FROM Airports WHERE Airports.AirportID
> =FlightLeg.AirportDepartID ) as AirportDepart,
> (SELECT AirportName FROM Airports WHERE Airports.AirportID
> =FlightLeg.AirportArrivalID ) as AirportArrival
> FROM FlightLegs- Hide quoted text -
> - Show quoted text -

Help With Query and/or Design

I am currently trying to model a database and have great difficulty in
determining the correct structure.
General Subject - Aircraft Flights.
Table - Flight ( FlightID = PK, FlightNumber, ClientNumber etc.... ))
Table - FlightLegs (FlightLegID = PK , FlightLegID = FK Date,
AirportDepartID = FK, AirportArrivalID = FK, etc...)
Table - Airports ( AiportID = PK , AirportName, City , Country
etc...) ,
PK = Primary Key , FK = Foreign Key .
The ForeignKeys require a double liaison between FlightLegs and
Airports. ( Is this a bad idea ?).
1 : Each flight may have one or more flightlegs.
2 : Each FlightLeg has a Depart Airport and an Arrival Airport.
For a given FlightNumber I wish to be able to display a list of all
flightlegs and the appropriate AirportNames.
I am having difficulty trying to create queries where I can get both
"AirportNames" for a given flightleg. I can easily retrieve either the
Departure or Arrival name but cannot seem to get both in one query.
I have simplified my examples for clarity.
No problem here
SELECT AirportName from Airports WHERE Airports.AirportID =
FlightLeg.AirportDepartID FROM Airports
Problem here
SELECT AirportName as Departure,AirportName as Arrival from Airports
WHERE Airports.AirportID = FlightLeg.AirportDepartID AND
Airports.AirportID = FlightLeg.AirportArrivalID FROM Airports
I realise that the above can never work due to the AND condition.
I know that the following works but I don't like this solution.
SELECT
( SELECT AirportName from Airports WHERE Airports.AirportID =
FlightLeg.AirportDepartID FROM Airports) Departure,
(SELECT AirportName from Airports WHERE Airports.AirportID =
FlightLeg.AirportArrivalID FROM Airports) Arrival
FROM Airports
what would be a more elegant solution, is my model incorrect.
On Apr 30, 2:11 pm, r.whiteh...@.gyrolan.com wrote:
> I am currently trying to model a database and have great difficulty in
> determining the correct structure.
> General Subject - Aircraft Flights.
> Table - Flight ( FlightID = PK, FlightNumber, ClientNumber etc.... ))
> Table - FlightLegs (FlightLegID = PK , FlightLegID = FK Date,
> AirportDepartID = FK, AirportArrivalID = FK, etc...)
> Table - Airports ( AiportID = PK , AirportName, City , Country
> etc...) ,
> PK = Primary Key , FK = Foreign Key .
> The ForeignKeys require a double liaison between FlightLegs and
> Airports. ( Is this a bad idea ?).
> ----
> 1 : Each flight may have one or more flightlegs.
> 2 : Each FlightLeg has a Depart Airport and an Arrival Airport.
> ----
> For a given FlightNumber I wish to be able to display a list of all
> flightlegs and the appropriate AirportNames.
> I am having difficulty trying to create queries where I can get both
> "AirportNames" for a given flightleg. I can easily retrieve either the
> Departure or Arrival name but cannot seem to get both in one query.
> I have simplified my examples for clarity.
> No problem here
> SELECT AirportName from Airports WHERE Airports.AirportID =
> FlightLeg.AirportDepartID FROM Airports
> Problem here
> SELECT AirportName as Departure,AirportName as Arrival from Airports
> WHERE Airports.AirportID = FlightLeg.AirportDepartID AND
> Airports.AirportID = FlightLeg.AirportArrivalID FROM Airports
> I realise that the above can never work due to the AND condition.
> I know that the following works but I don't like this solution.
> SELECT
> ( SELECT AirportName from Airports WHERE Airports.AirportID =
> FlightLeg.AirportDepartID FROM Airports) Departure,
> (SELECT AirportName from Airports WHERE Airports.AirportID =
> FlightLeg.AirportArrivalID FROM Airports) Arrival
> FROM Airports
> what would be a more elegant solution, is my model incorrect.
SELECT FlightLegID,
(SELECT AirportName FROM Airports WHERE Airports.AirportID
=FlightLeg.AirportDepartID ) as AirportDepart,
(SELECT AirportName FROM Airports WHERE Airports.AirportID
=FlightLeg.AirportArrivalID ) as AirportArrival
FROM FlightLegs
|||Here is another alternative.
SELECT
fl.FlightLegID,
dep.AirportName DepartureAirport,
arr.AirportName ArrivalAirport
FROM
FlightLegs fl
JOIN Airports dep ON dep.AirportID = fl.AirportDepartID
JOIN Airports arr ON arr.AirportID = fl.AirportArrivalID
On Apr 30, 7:33 am, M A Srinivas <masri...@.gmail.com> wrote:
> On Apr 30, 2:11 pm, r.whiteh...@.gyrolan.com wrote:
>
>
>
>
>
>
>
>
>
>
> SELECT FlightLegID,
> (SELECT AirportName FROM Airports WHERE Airports.AirportID
> =FlightLeg.AirportDepartID ) as AirportDepart,
> (SELECT AirportName FROM Airports WHERE Airports.AirportID
> =FlightLeg.AirportArrivalID ) as AirportArrival
> FROM FlightLegs- Hide quoted text -
> - Show quoted text -

Help With Query and/or Design

I am currently trying to model a database and have great difficulty in
determining the correct structure.
General Subject - Aircraft Flights.
Table - Flight ( FlightID = PK, FlightNumber, ClientNumber etc.... ))
Table - FlightLegs (FlightLegID = PK , FlightLegID = FK Date,
AirportDepartID = FK, AirportArrivalID = FK, etc...)
Table - Airports ( AiportID = PK , AirportName, City , Country
etc...) ,
PK = Primary Key , FK = Foreign Key .
The ForeignKeys require a double liaison between FlightLegs and
Airports. ( Is this a bad idea ?).
----
1 : Each flight may have one or more flightlegs.
2 : Each FlightLeg has a Depart Airport and an Arrival Airport.
----
For a given FlightNumber I wish to be able to display a list of all
flightlegs and the appropriate AirportNames.
I am having difficulty trying to create queries where I can get both
"AirportNames" for a given flightleg. I can easily retrieve either the
Departure or Arrival name but cannot seem to get both in one query.
I have simplified my examples for clarity.
No problem here
SELECT AirportName from Airports WHERE Airports.AirportID = FlightLeg.AirportDepartID FROM Airports
Problem here
SELECT AirportName as Departure,AirportName as Arrival from Airports
WHERE Airports.AirportID = FlightLeg.AirportDepartID AND
Airports.AirportID = FlightLeg.AirportArrivalID FROM Airports
I realise that the above can never work due to the AND condition.
I know that the following works but I don't like this solution.
SELECT
( SELECT AirportName from Airports WHERE Airports.AirportID = FlightLeg.AirportDepartID FROM Airports) Departure,
(SELECT AirportName from Airports WHERE Airports.AirportID = FlightLeg.AirportArrivalID FROM Airports) Arrival
FROM Airports
what would be a more elegant solution, is my model incorrect.On Apr 30, 2:11 pm, r.whiteh...@.gyrolan.com wrote:
> I am currently trying to model a database and have great difficulty in
> determining the correct structure.
> General Subject - Aircraft Flights.
> Table - Flight ( FlightID = PK, FlightNumber, ClientNumber etc.... ))
> Table - FlightLegs (FlightLegID = PK , FlightLegID = FK Date,
> AirportDepartID = FK, AirportArrivalID = FK, etc...)
> Table - Airports ( AiportID = PK , AirportName, City , Country
> etc...) ,
> PK = Primary Key , FK = Foreign Key .
> The ForeignKeys require a double liaison between FlightLegs and
> Airports. ( Is this a bad idea ?).
> ----
> 1 : Each flight may have one or more flightlegs.
> 2 : Each FlightLeg has a Depart Airport and an Arrival Airport.
> ----
> For a given FlightNumber I wish to be able to display a list of all
> flightlegs and the appropriate AirportNames.
> I am having difficulty trying to create queries where I can get both
> "AirportNames" for a given flightleg. I can easily retrieve either the
> Departure or Arrival name but cannot seem to get both in one query.
> I have simplified my examples for clarity.
> No problem here
> SELECT AirportName from Airports WHERE Airports.AirportID => FlightLeg.AirportDepartID FROM Airports
> Problem here
> SELECT AirportName as Departure,AirportName as Arrival from Airports
> WHERE Airports.AirportID = FlightLeg.AirportDepartID AND
> Airports.AirportID = FlightLeg.AirportArrivalID FROM Airports
> I realise that the above can never work due to the AND condition.
> I know that the following works but I don't like this solution.
> SELECT
> ( SELECT AirportName from Airports WHERE Airports.AirportID => FlightLeg.AirportDepartID FROM Airports) Departure,
> (SELECT AirportName from Airports WHERE Airports.AirportID => FlightLeg.AirportArrivalID FROM Airports) Arrival
> FROM Airports
> what would be a more elegant solution, is my model incorrect.
SELECT FlightLegID,
(SELECT AirportName FROM Airports WHERE Airports.AirportID
=FlightLeg.AirportDepartID ) as AirportDepart,
(SELECT AirportName FROM Airports WHERE Airports.AirportID
=FlightLeg.AirportArrivalID ) as AirportArrival
FROM FlightLegs|||Here is another alternative.
SELECT
fl.FlightLegID,
dep.AirportName DepartureAirport,
arr.AirportName ArrivalAirport
FROM
FlightLegs fl
JOIN Airports dep ON dep.AirportID = fl.AirportDepartID
JOIN Airports arr ON arr.AirportID = fl.AirportArrivalID
On Apr 30, 7:33 am, M A Srinivas <masri...@.gmail.com> wrote:
> On Apr 30, 2:11 pm, r.whiteh...@.gyrolan.com wrote:
>
>
> > I am currently trying to model a database and have great difficulty in
> > determining the correct structure.
> > General Subject - Aircraft Flights.
> > Table - Flight ( FlightID = PK, FlightNumber, ClientNumber etc.... ))
> > Table - FlightLegs (FlightLegID = PK , FlightLegID = FK Date,
> > AirportDepartID = FK, AirportArrivalID = FK, etc...)
> > Table - Airports ( AiportID = PK , AirportName, City , Country
> > etc...) ,
> > PK = Primary Key , FK = Foreign Key .
> > The ForeignKeys require a double liaison between FlightLegs and
> > Airports. ( Is this a bad idea ?).
> > ----
> > 1 : Each flight may have one or more flightlegs.
> > 2 : Each FlightLeg has a Depart Airport and an Arrival Airport.
> > ----
> > For a given FlightNumber I wish to be able to display a list of all
> > flightlegs and the appropriate AirportNames.
> > I am having difficulty trying to create queries where I can get both
> > "AirportNames" for a given flightleg. I can easily retrieve either the
> > Departure or Arrival name but cannot seem to get both in one query.
> > I have simplified my examples for clarity.
> > No problem here
> > SELECT AirportName from Airports WHERE Airports.AirportID => > FlightLeg.AirportDepartID FROM Airports
> > Problem here
> > SELECT AirportName as Departure,AirportName as Arrival from Airports
> > WHERE Airports.AirportID = FlightLeg.AirportDepartID AND
> > Airports.AirportID = FlightLeg.AirportArrivalID FROM Airports
> > I realise that the above can never work due to the AND condition.
> > I know that the following works but I don't like this solution.
> > SELECT
> > ( SELECT AirportName from Airports WHERE Airports.AirportID => > FlightLeg.AirportDepartID FROM Airports) Departure,
> > (SELECT AirportName from Airports WHERE Airports.AirportID => > FlightLeg.AirportArrivalID FROM Airports) Arrival
> > FROM Airports
> > what would be a more elegant solution, is my model incorrect.
> SELECT FlightLegID,
> (SELECT AirportName FROM Airports WHERE Airports.AirportID
> =FlightLeg.AirportDepartID ) as AirportDepart,
> (SELECT AirportName FROM Airports WHERE Airports.AirportID
> =FlightLeg.AirportArrivalID ) as AirportArrival
> FROM FlightLegs- Hide quoted text -
> - Show quoted text -

Help with phoneBook db design

Hi All!!
I need to build small phone book db.
There are phone numbers and name (to whom phone belong)
There are distribution lists that holds phone numbers and also can hold
another lists.
There are Users to whom distribution lists and or phones belong.
Any ideas, implementations ??
TNX
Imagination is more important then knowledge. (A.Einshtein)
Message posted via http://www.droptable.com
E B via droptable.com wrote:
> Hi All!!
> I need to build small phone book db.
> There are phone numbers and name (to whom phone belong)
> There are distribution lists that holds phone numbers and also can hold
> another lists.
> There are Users to whom distribution lists and or phones belong.
> Any ideas, implementations ??
> TNX
> --
> Imagination is more important then knowledge. (A.Einshtein)
> Message posted via http://www.droptable.com
Please don't multi-post!
Answered in comp.databases.ms-sqlserver
David Portas
SQL Server MVP

Help with phoneBook db design

Hi All!!
I need to build small phone book db.
There are phone numbers and name (to whom phone belong)
There are distribution lists that holds phone numbers and also can hold
another lists.
There are Users to whom distribution lists and or phones belong.
Any ideas, implementations '?
TNX
Imagination is more important then knowledge. (A.Einshtein)
Message posted via http://www.droptable.comE B via droptable.com wrote:
> Hi All!!
> I need to build small phone book db.
> There are phone numbers and name (to whom phone belong)
> There are distribution lists that holds phone numbers and also can hold
> another lists.
> There are Users to whom distribution lists and or phones belong.
> Any ideas, implementations '?
> TNX
> --
> Imagination is more important then knowledge. (A.Einshtein)
> Message posted via http://www.droptable.com
Please don't multi-post!
Answered in comp.databases.ms-sqlserver
David Portas
SQL Server MVP
--

Help with phoneBook db design

Hi All!!
I need to build small phone book db.
There are phone numbers and name (to whom phone belong)
There are distribution lists that holds phone numbers and also can hold
another lists.
There are Users to whom distribution lists and or phones belong.
Any ideas, implementations '?
TNX
--
Imagination is more important then knowledge. (A.Einshtein)
Message posted via http://www.sqlmonster.comE B via SQLMonster.com wrote:
> Hi All!!
> I need to build small phone book db.
> There are phone numbers and name (to whom phone belong)
> There are distribution lists that holds phone numbers and also can hold
> another lists.
> There are Users to whom distribution lists and or phones belong.
> Any ideas, implementations '?
> TNX
> --
> Imagination is more important then knowledge. (A.Einshtein)
> Message posted via http://www.sqlmonster.com
Please don't multi-post!
Answered in comp.databases.ms-sqlserver
--
David Portas
SQL Server MVP
--

Help with Matrix report and design

I've got this data source that returns member information.. great.
I've got a function that when passed the member number and a month/
year returns days participating in the club.
I need to build a report that will output some of the columns for the
member, but then report other information for 6 months for each member
that all calulated based on days particpating for that month. Which 6
months will be dictated by single parameter passed to the report for
starting month/year... basically the next 6 months.
Is a matrix report a good option for this? Or should I just have the
function called 6 times in my data source? Ideally I layout the report
for one month and then *somehow* join in my data source for 6
iterations where month is 1 through 6.
Right now I'm having trouble wrapping my mind around how and where to
join the data? Especially if matrix and I have two data sources. I'm
also not sure I can call my function from cells in the matrix or if I
can even have mulitple data buckets in the matrix. I'm tempted to do
this the only way I know how, but I suspect there is a better way.
I've never built a matrix report in ssrs, any information or help is
appreciated.
Thank you!If you have a table that lists visits for your members with a datetime
field, your query should look like this:
select MemberFullName, Month(ActivityDate), count(*) from MyTable
group by MemberFullName, Month(ActivityDate)
Then put a matrix control on your report's layout. Drag the MemberFullName
field on the top row, the Month(ActivityDate) on the left column and the
count(*) field in the middle cell. Preview your report.
John Smith | Mary Poppins | Joe Shmoe
Jan 12 | 15 | 17
Feb 14 | 19 | 10
Mar 11 | 12 | 12
Apr 12 | 8 | 11
May 9 | 7 | 18
Jun 10 | 3 | 14
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
<wildman@.noclient.net> wrote in message
news:8cb4193c-acf5-405d-b6b3-d03d512bdcfe@.e53g2000hsa.googlegroups.com...
> I've got this data source that returns member information.. great.
> I've got a function that when passed the member number and a month/
> year returns days participating in the club.
> I need to build a report that will output some of the columns for the
> member, but then report other information for 6 months for each member
> that all calulated based on days particpating for that month. Which 6
> months will be dictated by single parameter passed to the report for
> starting month/year... basically the next 6 months.
> Is a matrix report a good option for this? Or should I just have the
> function called 6 times in my data source? Ideally I layout the report
> for one month and then *somehow* join in my data source for 6
> iterations where month is 1 through 6.
> Right now I'm having trouble wrapping my mind around how and where to
> join the data? Especially if matrix and I have two data sources. I'm
> also not sure I can call my function from cells in the matrix or if I
> can even have mulitple data buckets in the matrix. I'm tempted to do
> this the only way I know how, but I suspect there is a better way.
> I've never built a matrix report in ssrs, any information or help is
> appreciated.
> Thank you!
>

Help with Invoice design anybody!

Hi,
This issue is driving me nuts (well.. more nuts).
Our invoices have lines which run from the top of the page to the bottom.
How would we achieve this in reporting services assuming we are using a
table to show the items on the invoice?
thanks
MattYou can apply Border to the the text boxs in the table...for line running
from top to bottom..apply solid border on left and rigth of the text box.
Also u can use expressions to manage when u want the borders to be visible ...
I hope thats what u r looking for ...
"Matt" wrote:
> Hi,
> This issue is driving me nuts (well.. more nuts).
> Our invoices have lines which run from the top of the page to the bottom.
> How would we achieve this in reporting services assuming we are using a
> table to show the items on the invoice?
> thanks
> Matt
>
>|||Hi Sunny,
thanks for the reply, actually I need the lines to run from the top of the
page to the bottom of the page - unfortunately, they stop when the rows in
the table stop.
"Sunny" <Sunny@.discussions.microsoft.com> wrote in message
news:C618BC15-C56A-47E6-82DE-6A5AB27443B1@.microsoft.com...
> You can apply Border to the the text boxs in the table...for line running
> from top to bottom..apply solid border on left and rigth of the text box.
> Also u can use expressions to manage when u want the borders to be visible
...
> I hope thats what u r looking for ...
>
> "Matt" wrote:
> > Hi,
> >
> > This issue is driving me nuts (well.. more nuts).
> >
> > Our invoices have lines which run from the top of the page to the
bottom.
> > How would we achieve this in reporting services assuming we are using a
> > table to show the items on the invoice?
> >
> > thanks
> >
> > Matt
> >
> >
> >|||Greetings,
Matt wrote:
> Hi,
> This issue is driving me nuts (well.. more nuts).
> Our invoices have lines which run from the top of the page to the bottom.
> How would we achieve this in reporting services assuming we are using a
> table to show the items on the invoice?
> thanks
> Matt
I would suggest you add the line(s) as a background image to the report.
--
Regards,
Neale NOON|||I had to do this very thing for both quotes and invoices; although it's been
a while, I seem to remember I placed rectangle and vertical line elements
down the length of the page, carefully ensuring that the vertical lines
lined up with the columns of the table. For a reason I forget, I also had
to send the table to the "back" of the page, behind the rectangle and line
elements.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eKU060TpEHA.1668@.TK2MSFTNGP14.phx.gbl...
> Hi Sunny,
> thanks for the reply, actually I need the lines to run from the top of the
> page to the bottom of the page - unfortunately, they stop when the rows in
> the table stop.
> "Sunny" <Sunny@.discussions.microsoft.com> wrote in message
> news:C618BC15-C56A-47E6-82DE-6A5AB27443B1@.microsoft.com...
> > You can apply Border to the the text boxs in the table...for line
running
> > from top to bottom..apply solid border on left and rigth of the text
box.
> > Also u can use expressions to manage when u want the borders to be
visible
> ...
> > I hope thats what u r looking for ...
> >
> >
> > "Matt" wrote:
> >
> > > Hi,
> > >
> > > This issue is driving me nuts (well.. more nuts).
> > >
> > > Our invoices have lines which run from the top of the page to the
> bottom.
> > > How would we achieve this in reporting services assuming we are using
a
> > > table to show the items on the invoice?
> > >
> > > thanks
> > >
> > > Matt
> > >
> > >
> > >
>|||Thanks Greg,
was the Table contained within the rectangle element?
"Greg Clark" <gclarkmail@.yahoo.com> wrote in message
news:O1WTFCVpEHA.4008@.TK2MSFTNGP14.phx.gbl...
> I had to do this very thing for both quotes and invoices; although it's
been
> a while, I seem to remember I placed rectangle and vertical line elements
> down the length of the page, carefully ensuring that the vertical lines
> lined up with the columns of the table. For a reason I forget, I also had
> to send the table to the "back" of the page, behind the rectangle and line
> elements.
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:eKU060TpEHA.1668@.TK2MSFTNGP14.phx.gbl...
> > Hi Sunny,
> >
> > thanks for the reply, actually I need the lines to run from the top of
the
> > page to the bottom of the page - unfortunately, they stop when the rows
in
> > the table stop.
> >
> > "Sunny" <Sunny@.discussions.microsoft.com> wrote in message
> > news:C618BC15-C56A-47E6-82DE-6A5AB27443B1@.microsoft.com...
> > > You can apply Border to the the text boxs in the table...for line
> running
> > > from top to bottom..apply solid border on left and rigth of the text
> box.
> > > Also u can use expressions to manage when u want the borders to be
> visible
> > ...
> > > I hope thats what u r looking for ...
> > >
> > >
> > > "Matt" wrote:
> > >
> > > > Hi,
> > > >
> > > > This issue is driving me nuts (well.. more nuts).
> > > >
> > > > Our invoices have lines which run from the top of the page to the
> > bottom.
> > > > How would we achieve this in reporting services assuming we are
using
> a
> > > > table to show the items on the invoice?
> > > >
> > > > thanks
> > > >
> > > > Matt
> > > >
> > > >
> > > >
> >
> >
>|||Thanks for the suggestion. This might work if each page was identical.
Unfortunately, the first page has additional detail including address
information etc.
Further, I guess if you needed to resise/add/remove a column you would have
to re-create the image.
"noonie" <noonie1155@.hotmail.com> wrote in message
news:OqA2JEUpEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Greetings,
> Matt wrote:
> > Hi,
> >
> > This issue is driving me nuts (well.. more nuts).
> >
> > Our invoices have lines which run from the top of the page to the
bottom.
> > How would we achieve this in reporting services assuming we are using a
> > table to show the items on the invoice?
> >
> > thanks
> >
> > Matt
> I would suggest you add the line(s) as a background image to the report.
> --
> Regards,
> Neale NOON