Showing posts with label rdl. Show all posts
Showing posts with label rdl. Show all posts

Thursday, March 22, 2012

Adding a blank line after a group of rows

I have an rdl report that shows rows group by category. I would like to include a blank line after each set of categories. Can anyone point me to how I would do that in the rdl.

thanks

idriss

Hi,

Add a blank Group Footer and increase the height of it as per your requirements.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

Tuesday, March 6, 2012

add MatrixRow for total and subtotal

Hi,
How could I add MAtrixRow for total and subtotal?
Or is any other way can do total and subtotal on Matrix?
I see the FoodmartSales.rdl of Reporting Service Example..
How could the Example add a MatrixRow for total and subtotal?
Thanks!
AngiIf you right click in a matrix row or column group cell you will find an
option to add a subtotal.
Note the green triangle in the upper right corner of the subtotal cell. If
you click this properties window will display the style properties for the
subtotal.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"angi" <angi@.microsoft.com> wrote in message
news:uX8%23Y4NZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> Hi,
> How could I add MAtrixRow for total and subtotal?
> Or is any other way can do total and subtotal on Matrix?
> I see the FoodmartSales.rdl of Reporting Service Example..
> How could the Example add a MatrixRow for total and subtotal?
> Thanks!
> Angi
>|||Thanks!
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:#1wfURSZEHA.3596@.tk2msftngp13.phx.gbl...
> If you right click in a matrix row or column group cell you will find an
> option to add a subtotal.
> Note the green triangle in the upper right corner of the subtotal cell. If
> you click this properties window will display the style properties for the
> subtotal.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "angi" <angi@.microsoft.com> wrote in message
> news:uX8%23Y4NZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > How could I add MAtrixRow for total and subtotal?
> > Or is any other way can do total and subtotal on Matrix?
> > I see the FoodmartSales.rdl of Reporting Service Example..
> > How could the Example add a MatrixRow for total and subtotal?
> >
> > Thanks!
> > Angi
> >
> >
>|||No. However this is on the feature wish list.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Laura" <Laura@.discussions.microsoft.com> wrote in message
news:026DFC5F-574E-462A-B41D-DAA671ED55D7@.microsoft.com...
> Hi Bruce,
> Is there a way to edit the expression on this Subtotal? Thanks.
> "angi" wrote:
> > Thanks!
> >
> > "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> > :#1wfURSZEHA.3596@.tk2msftngp13.phx.gbl...
> > > If you right click in a matrix row or column group cell you will find
an
> > > option to add a subtotal.
> > > Note the green triangle in the upper right corner of the subtotal
cell. If
> > > you click this properties window will display the style properties for
the
> > > subtotal.
> > >
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "angi" <angi@.microsoft.com> wrote in message
> > > news:uX8%23Y4NZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > >
> > > > How could I add MAtrixRow for total and subtotal?
> > > > Or is any other way can do total and subtotal on Matrix?
> > > > I see the FoodmartSales.rdl of Reporting Service Example..
> > > > How could the Example add a MatrixRow for total and subtotal?
> > > >
> > > > Thanks!
> > > > Angi
> > > >
> > > >
> > >
> > >
> >
> >
> >

Saturday, February 25, 2012

Add existing report

I'm trying to import a report from our report server because the rdl
file was deleted from my machine. I know this sounds stupid but how
do I go about doing it? I thought the files were stored on the server
in rdl format but I can't find them for the life of me.This is not from Visual Studio it is done via a browser, go to the report in
Report Manager via the browser, properties tab, edit report definition. Save
it somewhere other than where you have your project (like in c:\temp). Then
add an existing item to your project and it will copy it over from c:\temp
to the directory where the project files are stored.
The reason you don't find them on the server is that they do not exist as
files, they are stored in the database.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brent" <mills.brent@.gmail.com> wrote in message
news:681372b5.0412021247.7f2f5218@.posting.google.com...
> I'm trying to import a report from our report server because the rdl
> file was deleted from my machine. I know this sounds stupid but how
> do I go about doing it? I thought the files were stored on the server
> in rdl format but I can't find them for the life of me.