Invoice form layout

Is there some way to simulate a fixed form layout for an invoice? I want to
have a fixed set of columns with dividing lines and totals boxes at the
bottom, regardless of how many actual rows of data are displayed. I've
tried 2 approaches (using PDF rendering only):
1. overlay a table with a set of manually drawn lines. This sort of works
for a single page, but if a 2nd page is required by the data it goes
completely haywire.
2. Use a table with conditional formatting. This is my current solution, BUT
a) the totals are always immediately after the last row, instead of at the
page bottom,
b) when the data requires just a little more than a single page the whole
table is moved to start on the 2nd page (where it fits in total due to less
header space) instead of starting on page 1 and continuing on page2 (hope
that makes sense).
Is there any published advice on designing this sort of page layout, or is
RS not really suited to the task?
brian smithHi Brian,
have you had any luck with this?
regards
Matt
"Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> wrote in message
news:OElbad7nEHA.2300@.TK2MSFTNGP10.phx.gbl...
> Is there some way to simulate a fixed form layout for an invoice? I want
to
> have a fixed set of columns with dividing lines and totals boxes at the
> bottom, regardless of how many actual rows of data are displayed. I've
> tried 2 approaches (using PDF rendering only):
> 1. overlay a table with a set of manually drawn lines. This sort of works
> for a single page, but if a 2nd page is required by the data it goes
> completely haywire.
> 2. Use a table with conditional formatting. This is my current solution,
BUT
> a) the totals are always immediately after the last row, instead of at the
> page bottom,
> b) when the data requires just a little more than a single page the whole
> table is moved to start on the 2nd page (where it fits in total due to
less
> header space) instead of starting on page 1 and continuing on page2 (hope
> that makes sense).
> Is there any published advice on designing this sort of page layout, or is
> RS not really suited to the task?
> brian smith
>|||Nope, nothing :-(
My feeling is the RS cannot really do this sort of thing - it's really meant
for screen-based reporting.
brian
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ugVGLjSpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Hi Brian,
> have you had any luck with this?
> regards
> Matt
> "Brian Smith" <bsmith@.no_spam.schemiotics.co.uk> wrote in message
> news:OElbad7nEHA.2300@.TK2MSFTNGP10.phx.gbl...
> > Is there some way to simulate a fixed form layout for an invoice? I want
> to
> > have a fixed set of columns with dividing lines and totals boxes at the
> > bottom, regardless of how many actual rows of data are displayed. I've
> > tried 2 approaches (using PDF rendering only):
> > 1. overlay a table with a set of manually drawn lines. This sort of
works
> > for a single page, but if a 2nd page is required by the data it goes
> > completely haywire.
> > 2. Use a table with conditional formatting. This is my current solution,
> BUT
> > a) the totals are always immediately after the last row, instead of at
the
> > page bottom,
> > b) when the data requires just a little more than a single page the
whole
> > table is moved to start on the 2nd page (where it fits in total due to
> less
> > header space) instead of starting on page 1 and continuing on page2
(hope
> > that makes sense).
> >
> > Is there any published advice on designing this sort of page layout, or
is
> > RS not really suited to the task?
> >
> > brian smith
> >
> >
>

Inventory Cube

How have other tackled the Inventory Cube? I am thinking
along the lines of
these two strategies
1. 1 and only one snap shot at a time that we decide
accurately reflects
realistic inventory levels. Meaning not necessarily at
the end of the month
when they could be low.
or
2. Take 4 snapshots a month and average those 4 together
giving me my
inventory snap shot for the month. Does anyone have other
ideas? I'm
interested in hearing how you have solved this interesting
situation.
-mikeHi Michael,
I noticed that the issue was posted in the following groups
microsoft.public.sqlserver.datawarehouse and
microsoft.public.sqlserver.olap. We have added a reply to you at
http://support.microsoft.com/newsgr...&NewsGroup=micr
osoft.public.sqlserver.olap
If you have follow up questions, please post there and we will work with
you. Thanks.
Regards.
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.sql

Interpolating a line for missing data points in line / bar graph

I know I'm not the only one with this problem. I have a set of data values I want to display as lines from left to right, grouped by month, and a series is specified. There is no aggregation as the series/month combination is unique. However, sometimes there is no data for a given series and month. When this happens, my line breaks at the previous month and starts again on the next month. I tried using a column chart and specifying plot data as line, but I still get the same result. Is there a way to get SQL Server Reporting Services 2000 to connect the dots with the existing data or do I have to alter my stored procedure and create an interpolation scheme for missing months?

If not, will this be addressed in 2005?

Thanks in advance

Please make sure you have RS 2000 SP2 installed (on the report server and the report designer machines).

On SQL Server 2005 it will work just fine.

-- Robert

|||

I have the opposite problem. I'm using SQL Server 2005. I have data to graph by month, but when I have no data for a given month, I'd like like to see the gap in the line. If I leave out the row, the graph just leaves the month out. If I make the data value null, it puts the month in, leaves the marker off, but still draws a line from the previous to the next month. Is there a trick to make the line break?

|||I have the same problem - I am plotting a financial instrument and want to overlay the plot with buy/sell activity. Thus I buy at, say 09:00 and sell at 09:30 before buying again at 10:00. The Chart plots a line between the end of the buy line at 09:30 and the next buy at 10:00. This is despite the result set having a a null value between these two times.
Has anyone an answer to this problem?

Interpolating a line for missing data points in line / bar graph

I know I'm not the only one with this problem. I have a set of data values I want to display as lines from left to right, grouped by month, and a series is specified. There is no aggregation as the series/month combination is unique. However, sometimes there is no data for a given series and month. When this happens, my line breaks at the previous month and starts again on the next month. I tried using a column chart and specifying plot data as line, but I still get the same result. Is there a way to get SQL Server Reporting Services 2000 to connect the dots with the existing data or do I have to alter my stored procedure and create an interpolation scheme for missing months?

If not, will this be addressed in 2005?

Thanks in advance

Please make sure you have RS 2000 SP2 installed (on the report server and the report designer machines).

On SQL Server 2005 it will work just fine.

-- Robert

|||

I have the opposite problem. I'm using SQL Server 2005. I have data to graph by month, but when I have no data for a given month, I'd like like to see the gap in the line. If I leave out the row, the graph just leaves the month out. If I make the data value null, it puts the month in, leaves the marker off, but still draws a line from the previous to the next month. Is there a trick to make the line break?