Replace 'SQL Server Reporting Services' on RS Pages

This has to be easy but I can't find where to change the text on the RS pages that read 'SQL Server Reporting Services' in the upper left hand corner of each RS web page. I would prefer that to show our company name or something else. I have looked at the .CSS file but it just looks like formatting to me. Maybe MS doesn't want it changed?

Actually, what would even be better if that can't be done is to have the ability to put a company name in the (center) of header where it is blank by default (just to the right of where it says 'SQL Server Reporting Services.'

Is there any information available on how to change either one?

Thank you for any direction or help.

If you go to the site settings page (upper right corner) you can set the Name to display in Report Manager.

Repeating a Matrix With Different Values

I have a basic matrix with a title in the top lef corner, a list of locations
down the left hand side and one column per day of reporting across the top.
My problem is that the title is actually data from another column of my
recordset. I am repeating the matrix several times and filtering on this
value to obtain the relevant records for that matrix.
What I want is to automatically repeat the matrix however many times is
necessary for the recordset to be fully output. I thought adding the matrix
to the detail row of a table would acheive this but ssrs won't allow me to do
this.
I'm relatively new to ssrs - is there any way of doing this?If i Understand your concern.
You want to show different matrices for each distinct value in the
Column of a Record set
why can't you have a list containing Matix and Group the List on column
name you want to
Group .Hope this will help you
if you want more detail
please reply
regards
Raj Deep.A
rocket salad wrote:
> I have a basic matrix with a title in the top lef corner, a list of locations
> down the left hand side and one column per day of reporting across the top.
> My problem is that the title is actually data from another column of my
> recordset. I am repeating the matrix several times and filtering on this
> value to obtain the relevant records for that matrix.
> What I want is to automatically repeat the matrix however many times is
> necessary for the recordset to be fully output. I thought adding the matrix
> to the detail row of a table would acheive this but ssrs won't allow me to do
> this.
> I'm relatively new to ssrs - is there any way of doing this?|||I've managed to get a list object to repeat the matrix. But I still can't set
the filter for the matrix to reference the list's filter's current value.
Help is much appreciated.
"rocket salad" wrote:
> I have a basic matrix with a title in the top lef corner, a list of locations
> down the left hand side and one column per day of reporting across the top.
> My problem is that the title is actually data from another column of my
> recordset. I am repeating the matrix several times and filtering on this
> value to obtain the relevant records for that matrix.
> What I want is to automatically repeat the matrix however many times is
> necessary for the recordset to be fully output. I thought adding the matrix
> to the detail row of a table would acheive this but ssrs won't allow me to do
> this.
> I'm relatively new to ssrs - is there any way of doing this?|||My test data only included one value, so the matrix didn't repeat. I had
assumed that when it did, it wouldn't automatically reference the list. As it
happens, since I've altered my source data it works fine.
Thanks.
"RajDeep" wrote:
> If i Understand your concern.
> You want to show different matrices for each distinct value in the
> Column of a Record set
> why can't you have a list containing Matix and Group the List on column
> name you want to
> Group .Hope this will help you
> if you want more detail
> please reply
> regards
> Raj Deep.A
>
> rocket salad wrote:
> > I have a basic matrix with a title in the top lef corner, a list of locations
> > down the left hand side and one column per day of reporting across the top.
> >
> > My problem is that the title is actually data from another column of my
> > recordset. I am repeating the matrix several times and filtering on this
> > value to obtain the relevant records for that matrix.
> >
> > What I want is to automatically repeat the matrix however many times is
> > necessary for the recordset to be fully output. I thought adding the matrix
> > to the detail row of a table would acheive this but ssrs won't allow me to do
> > this.
> >
> > I'm relatively new to ssrs - is there any way of doing this?
>|||So you are trying to catch something which is not in the scope.matrix
can be in Scope of list.But list cannot be in Scope of matrix
Try filter in the dataset tab.
Frankly to speak i didn't understand what exactly you are trying to do.
Filter on the Dataset will filter the records which is returned by the
datasource.
Regards
Raj Deep.A
rocket salad wrote:
> I've managed to get a list object to repeat the matrix. But I still can't set
> the filter for the matrix to reference the list's filter's current value.
> Help is much appreciated.
> "rocket salad" wrote:
> > I have a basic matrix with a title in the top lef corner, a list of locations
> > down the left hand side and one column per day of reporting across the top.
> >
> > My problem is that the title is actually data from another column of my
> > recordset. I am repeating the matrix several times and filtering on this
> > value to obtain the relevant records for that matrix.
> >
> > What I want is to automatically repeat the matrix however many times is
> > necessary for the recordset to be fully output. I thought adding the matrix
> > to the detail row of a table would acheive this but ssrs won't allow me to do
> > this.
> >
> > I'm relatively new to ssrs - is there any way of doing this?

Rendering to Excel: numbers stored as text

Some of my reports are rendering to Excel with numbers stored as text (the
little green triangle in the upper corner of each cell alerts the viewer of
the problem).
While this seems innocuous, it means that a user can't do typical Excel
operations, like highlighting cells and creating a graph, or highlighing and
viewing the totals on the status bar. Although there's a number in the cell,
it acts like text.
Not all of my reports are doing this, but I'm having major trouble figuring
out the differences between those which are, and those which are not. Also,
I can't find any documentation about how the rendering makes this
determination.
Thank you!It appears I've finally found the solution. Since I knew I wasn't *really*
aggregating any values, I was using First() as my aggregation formula. When
I switched to Sum() as my aggregation, the result was forced to be numeric,
even through the Excel rendering.
How was anyone supposed to figure this out without documentation!? I mean,
if the fundamental data is numeric, then why should First( ) change it to
text? That seems SO arbitrary...!
I hope this helps someone to NOT pull their hair out like I did.
"mr_bert" wrote:
> Some of my reports are rendering to Excel with numbers stored as text (the
> little green triangle in the upper corner of each cell alerts the viewer of
> the problem).
> While this seems innocuous, it means that a user can't do typical Excel
> operations, like highlighting cells and creating a graph, or highlighing and
> viewing the totals on the status bar. Although there's a number in the cell,
> it acts like text.
> Not all of my reports are doing this, but I'm having major trouble figuring
> out the differences between those which are, and those which are not. Also,
> I can't find any documentation about how the rendering makes this
> determination.
> Thank you!|||Thanks
This just saved me a day of pulling my hair out