Is this doable?

On the report table, there are 3 fields called Beginning Amount, Used Amount
and Remaining Amount respectively. The Beginning Amount and Used Amount field
are retrieved from the SQL database, while the Remaining Amount needs to be
calculated from the previous record, e.g, ItemB's RemainingAmount = ItemA's
RemainingAmount - ItemB's UsedAmount. Basides subreport and global variable,
is there any easy way to do it? what is a good approach here?
Example,
Beginning Amount: $1000
============================================== Name Used Amount Remaining Amount
============================================== Item A 100 900
Item B 200 700
Item C 100 600
Thanks.
ShawnYes it is doable with the RunningValue function.
See BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_5tt1.asp
The remaining amount would be e.g.:
= 1000 - RunningValue(Fields!Amount.Value, Sum, Nothing)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:7E302ED6-E26D-4307-A190-F2573050CD85@.microsoft.com...
> On the report table, there are 3 fields called Beginning Amount, Used
Amount
> and Remaining Amount respectively. The Beginning Amount and Used Amount
field
> are retrieved from the SQL database, while the Remaining Amount needs to
be
> calculated from the previous record, e.g, ItemB's RemainingAmount =ItemA's
> RemainingAmount - ItemB's UsedAmount. Basides subreport and global
variable,
> is there any easy way to do it? what is a good approach here?
>
> Example,
> Beginning Amount: $1000
> ==============================================> Name Used Amount Remaining Amount
> ==============================================> Item A 100 900
> Item B 200 700
> Item C 100 600
> Thanks.
> Shawn
>|||Robert Bruckner [MSFT] wrote:
> Yes it is doable with the RunningValue function.
> See BOL:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_5tt1.asp
> The remaining amount would be e.g.:
> = 1000 - RunningValue(Fields!Amount.Value, Sum, Nothing)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sean" <Sean@.discussions.microsoft.com> wrote in message
> news:7E302ED6-E26D-4307-A190-F2573050CD85@.microsoft.com...
>>On the report table, there are 3 fields called Beginning Amount, Used
> Amount
>>and Remaining Amount respectively. The Beginning Amount and Used Amount
> field
>>are retrieved from the SQL database, while the Remaining Amount needs to
> be
>>calculated from the previous record, e.g, ItemB's RemainingAmount => ItemA's
>>RemainingAmount - ItemB's UsedAmount. Basides subreport and global
> variable,
>>is there any easy way to do it? what is a good approach here?
>>
>>Example,
>>Beginning Amount: $1000
>>==============================================>>Name Used Amount Remaining Amount
>>==============================================>>Item A 100 900
>>Item B 200 700
>>Item C 100 600
>>Thanks.
>>Shawn
>>
>
>
RunningValue solves it.sql

Is this a limitation of Reporting Services...?

I am beginning to wonder if the behavior I am running into is a possible
limitation of Reporting Services. This is related to exporting a report to
.pdf that contains an embedded image. I have seen some discussion on this,
but have been unable to glean a solution from the existing threads.
My problem is that when I embed an image into my reports, it looks ok
in Visual Studio, but when I export to .pdf, it is blocky and distorted. My
graphics guy has put the image into ten different formats with different
resolutions, but they all render the same way.
What is the Microsoft recommeded format and resolution for image rendering
to .pdf? He designed the logo and can put it in whatever format I need, I
just don't know what to tell him. I found something on Image Device
Information Settings,
that lists 96 dpi as the best, but we tried that with the same results. It
also said something about the tif format, but when I tried to import the .tif
file, .tif was not listed as an image format in the wizard.
And yes, I have upgraded to SP1.I have posted this same message 7 times and still have not received an
answer. I am beginning to think that I am either invisible, or I have found
a limitation of Reporting Services. If that is the case, I would love for
someone to tell me so. I have spent more hours than I can count trying to
resolve this...
PLEASE HELP ME!!!!!!!!!!!!!!!!!|||OK, so I read this to see if I can help. I don't have a clue what your
problem is. Either repost with the problem to this thread or better yet,
repost with a good description in the subject. Depending on the subject
people with different expertise will jump in.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lisa" <Lisa@.discussions.microsoft.com> wrote in message
news:9FB5F4A6-75FD-4DAD-9B73-B7F63CCE92F1@.microsoft.com...
> I have posted this same message 7 times and still have not received an
> answer. I am beginning to think that I am either invisible, or I have
found
> a limitation of Reporting Services. If that is the case, I would love for
> someone to tell me so. I have spent more hours than I can count trying to
> resolve this...
> PLEASE HELP ME!!!!!!!!!!!!!!!!!|||Here is my original post, which I was replying to in the one you saw...but
maybe you couldn't see the original...
My problem is that when I embed an image into my reports, it looks ok
in Visual Studio, but when I export to .pdf, it is blocky and distorted. My
graphics guy has put the image into ten different formats with different
resolutions, but they all render the same way.
What is the Microsoft recommeded format and resolution for image rendering
to .pdf? He designed the image and can put it in whatever format I need, I
just don't know what to tell him. I found something on Image Device
Information Settings, that lists 96 dpi as the best, but we tried that with
the same results. It also said something about the tif format, but when I
tried to import the .tif file, .tif was not listed as an image format in the
wizard.
And yes, I have upgraded to SP1.
Thanks so much for your help!
Lisa
"Bruce L-C [MVP]" wrote:
> OK, so I read this to see if I can help. I don't have a clue what your
> problem is. Either repost with the problem to this thread or better yet,
> repost with a good description in the subject. Depending on the subject
> people with different expertise will jump in.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lisa" <Lisa@.discussions.microsoft.com> wrote in message
> news:9FB5F4A6-75FD-4DAD-9B73-B7F63CCE92F1@.microsoft.com...
> > I have posted this same message 7 times and still have not received an
> > answer. I am beginning to think that I am either invisible, or I have
> found
> > a limitation of Reporting Services. If that is the case, I would love for
> > someone to tell me so. I have spent more hours than I can count trying to
> > resolve this...
> >
> > PLEASE HELP ME!!!!!!!!!!!!!!!!!
>
>

Is there any requirement to install the client component of RS?

Hi all,
I only install the client component of reporting service,
at the beginning, when it is install the support file, it
always failed with only an 'error' message. No other
messages.
I check the log file. There is
Internet Information Services 5.0 (IIS) or later is either
not installed, or it is configured in a way that is
incompatible with a Reporting Services installation.
ASP.NET version 1.1 is not installed or is not registered
with your Web server. ASP.Net is required for the Report
Server and the Report Manager components.
and in the stlog file, I notice
<Prerequisite Name="IsIISInstalled" Checked="Metabase"
Item="/" Found="Can not open metabase" Expected="No error"
Result="Fail" />
To only install the client component, should I install IIS
and ASP1.1 and how do I check that every thing is OK to
install it.
Thanks.
Lindayou need Visual studio.Net 2003 and .Net framework 1.1
IIS is not required
"YUKON2005" <anonymous@.discussions.microsoft.com> a écrit dans le message de
news:38d201c471e9$c199d760$a501280a@.phx.gbl...
> Hi all,
> I only install the client component of reporting service,
> at the beginning, when it is install the support file, it
> always failed with only an 'error' message. No other
> messages.
> I check the log file. There is
> Internet Information Services 5.0 (IIS) or later is either
> not installed, or it is configured in a way that is
> incompatible with a Reporting Services installation.
> ASP.NET version 1.1 is not installed or is not registered
> with your Web server. ASP.Net is required for the Report
> Server and the Report Manager components.
> and in the stlog file, I notice
> <Prerequisite Name="IsIISInstalled" Checked="Metabase"
> Item="/" Found="Can not open metabase" Expected="No error"
> Result="Fail" />
> To only install the client component, should I install IIS
> and ASP1.1 and how do I check that every thing is OK to
> install it.
> Thanks.
> Linda
>|||Thank you!
I will check it.
:)