Grand Total in Matrixes

Hi,
I am working on matrix report that uses 3 matrixes like below.
In Grand Total matrix, I want to sum matrix 1 and matrix2 subtotals and
display as Grand Total. I had a difficulty to find out the expression for
this(how to reference the subtotals in matrixes?)?
Can we do this or any limitations?
Matrix 1:
Week1 Week2
Sub Total 10 20
Matrix 2:
Week1 Week2
Sub Total 15 25
Grand Total
Week1 Week2
Grand Total 25 45
Any pointers in this regard is appreciated
Thanks
BhaskarOn Nov 16, 5:08 pm, Bhaskar <Bhas...@.discussions.microsoft.com> wrote:
> Hi,
> I am working on matrix report that uses 3 matrixes like below.
> In Grand Total matrix, I want to sum matrix 1 and matrix2 subtotals and
> display as Grand Total. I had a difficulty to find out the expression for
> this(how to reference the subtotals in matrixes?)?
> Can we do this or any limitations?
> Matrix 1:
> Week1 Week2
> Sub Total 10 20
> Matrix 2:
> Week1 Week2
> Sub Total 15 25
> Grand Total
> Week1 Week2
> Grand Total 25 45
> Any pointers in this regard is appreciated
> Thanks
> Bhaskar
Since you have multiple columns that have subtotals, you most likely
will want to sum the subtotals together as part of another report
dataset (via a separate stored procedure/query). If there was only one
subtotal column per matrix, you might have been able to reference
aggregates via an expression similar to this.
=Sum(Fields!Week1.Value, "dsMatrix1") + Sum(Fields!Week1.Value,
"dsMatrix2")
Where dsMatrix1 and dsMatrix2 are the example dataset names used for
Matrix1 and Matrix2 respectively.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Enrique. yeah.. i tried to avoid another query or sp to get the grand
total.
looks like there is no other way. :)
Bhaskar
"EMartinez" wrote:
> On Nov 16, 5:08 pm, Bhaskar <Bhas...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I am working on matrix report that uses 3 matrixes like below.
> >
> > In Grand Total matrix, I want to sum matrix 1 and matrix2 subtotals and
> > display as Grand Total. I had a difficulty to find out the expression for
> > this(how to reference the subtotals in matrixes?)?
> > Can we do this or any limitations?
> >
> > Matrix 1:
> >
> > Week1 Week2
> > Sub Total 10 20
> >
> > Matrix 2:
> > Week1 Week2
> > Sub Total 15 25
> >
> > Grand Total
> >
> > Week1 Week2
> > Grand Total 25 45
> >
> > Any pointers in this regard is appreciated
> >
> > Thanks
> > Bhaskar
>
> Since you have multiple columns that have subtotals, you most likely
> will want to sum the subtotals together as part of another report
> dataset (via a separate stored procedure/query). If there was only one
> subtotal column per matrix, you might have been able to reference
> aggregates via an expression similar to this.
> =Sum(Fields!Week1.Value, "dsMatrix1") + Sum(Fields!Week1.Value,
> "dsMatrix2")
> Where dsMatrix1 and dsMatrix2 are the example dataset names used for
> Matrix1 and Matrix2 respectively.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Grab hand and magnifing glass?

Is there anyway to display the familiar grab hand and magnifying glass on the
report that is native to Adobe PDF viewer? It makes it much more intuitive
for the end user to grab the page to scroll up/down or click with the
magnifying glass to zoom in/out. Please don't tell me this isn't
available... Without those basic features, the report looks pretty darn
cheap.What format are you rendering? If you are rendering in PDF then the PDF
viewer is being used and those things should be available. Otherwise, the
answer is no.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:284CE966-B4C3-451D-8C34-BBFFCAF753B3@.microsoft.com...
> Is there anyway to display the familiar grab hand and magnifying glass on
> the
> report that is native to Adobe PDF viewer? It makes it much more
> intuitive
> for the end user to grab the page to scroll up/down or click with the
> magnifying glass to zoom in/out. Please don't tell me this isn't
> available... Without those basic features, the report looks pretty darn
> cheap.

Google Maps

Has anybody tried to display a Google Map inside a report using Reporting
Services?
Thank you,
Alain Quesnel
alainsansspam@.logiquel.comOn Jun 26, 9:43 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> Has anybody tried to display a Google Map inside a report using Reporting
> Services?
> Thank you,
> Alain Quesnel
> alainsanss...@.logiquel.com
You could add a textbox control to the report and give it a string
value and set it to a Google Maps URL (via: right-click the textbox
contol -> select Properties -> Navigation -> Jump to URL:). Hope this
is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'm already doing that, thanks. It's fine for a pdf file or for viewing the
report online. But once it's printed, thank link is no longer useful. I was
hoping to do something similar to a Windows app or a web page that has a
Google map frame in it.
Thanks,
Alain Quesnel
alainsansspam@.logiquel.com
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1183083791.675971.61680@.k79g2000hse.googlegroups.com...
> On Jun 26, 9:43 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
> wrote:
>> Has anybody tried to display a Google Map inside a report using Reporting
>> Services?
>> Thank you,
>> Alain Quesnel
>> alainsanss...@.logiquel.com
>
> You could add a textbox control to the report and give it a string
> value and set it to a Google Maps URL (via: right-click the textbox
> contol -> select Properties -> Navigation -> Jump to URL:). Hope this
> is helpful.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Go to the last record

How can I go to the last record of database? I've been having problems after creating a new record, and trying to display it, but I don't know what primary ID it's given, so I dont know how to go the last record. Thanks for the help.

Quote:

Originally Posted by LuiePL

How can I go to the last record of database? I've been having problems after creating a new record, and trying to display it, but I don't know what primary ID it's given, so I dont know how to go the last record. Thanks for the help.

if you want to find the last record in a table (with PK = xx) you can to try with:

select * from tabv where xx = (select max(xx) from tab)|||Many thanks!!!!|||Hi,
select top 1 * from tablename order by column name desc

Global Expressions

I'm using Globals.ExecutionTime to display the date of the report.
I would like to only display the year.
Is there somewhere that I can find help with RS Global Expressions? Or any
help would be groovy.
P.S. I'm a NewbHow about:
= year(Globals.ExecutionTime)
If you want anything fancier, then investigate the format function.
Mike G.
"Nice_Out" <NiceOut@.discussions.microsoft.com> wrote in message
news:0719FDB6-6F67-4896-B349-C82E3EEE98A9@.microsoft.com...
> I'm using Globals.ExecutionTime to display the date of the report.
> I would like to only display the year.
> Is there somewhere that I can find help with RS Global Expressions? Or any
> help would be groovy.
> P.S. I'm a Newb

Global expression apply to all fields in report

Hi All,

I got a situation that need to write a expression for doing if the value is negtive then display () around this value, and this expression should apply to 30 fields in my report. so i just wonder is that any way that i can create this expression as global variable , then i can use this expression in each field, instead of i write IIF function in every field expression area.

Any helps are appreciated.

Cheers

Nick

Moved to SSRS forum....(from SSIS)|||

Hi Nick,

You can declare a public variable in the Custom code section of the SSRS reports. The syntax for this variable declaration should be VB. Once declared, it can be used in any part of the report by referring to the field as Code."Variable Name". eg. Code.IntCounter.

Regards,

Pradeep

|||

Yeah, i did this way, and it works.. Thanks mate

But i have a little question, it always hightlight the global variable name and indicate it is not declared object in expression area. even through it still works.

Cheers

Nick

Global expression apply to all fields in report

Hi All,

I got a situation that need to write a expression for doing if the value is negtive then display () around this value, and this expression should apply to 30 fields in my report. so i just wonder is that any way that i can create this expression as global variable , then i can use this expression in each field, instead of i write IIF function in every field expression area.

Any helps are appreciated.

Cheers

Nick

Moved to SSRS forum....(from SSIS)|||

Hi Nick,

You can declare a public variable in the Custom code section of the SSRS reports. The syntax for this variable declaration should be VB. Once declared, it can be used in any part of the report by referring to the field as Code."Variable Name". eg. Code.IntCounter.

Regards,

Pradeep

|||

Yeah, i did this way, and it works.. Thanks mate

But i have a little question, it always hightlight the global variable name and indicate it is not declared object in expression area. even through it still works.

Cheers

Nick