Changing the ReportViewer control size.

I have an aspx page that uses the ReportViewer control. The dimensions are
set at runtime.
private void Page_Load(object sender, System.EventArgs e)
{
reportViewer.ServerUrl = "http://localhost/reportserver";
reportViewer.ReportPath = "/Samples/Company Sales";
reportViewer.Width = 900;
reportViewer.Height = 580;
}
Is it possible to change the size of the control everytime the browser
window is resized?
TIA.You can set the size to a percent.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:OqzqmWrEFHA.2572@.tk2msftngp13.phx.gbl...
>I have an aspx page that uses the ReportViewer control. The dimensions are
>set at runtime.
> private void Page_Load(object sender, System.EventArgs e)
> {
> reportViewer.ServerUrl = "http://localhost/reportserver";
> reportViewer.ReportPath = "/Samples/Company Sales";
> reportViewer.Width = 900;
> reportViewer.Height = 580;
> }
> Is it possible to change the size of the control everytime the browser
> window is resized?
> TIA.
>|||Thank you.
This worked, but first I had to modify the ReportViewer.dll since, by
default, it doesn't accept precentage for dimensions.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:ekIm4R5EFHA.3200@.TK2MSFTNGP10.phx.gbl...
> You can set the size to a percent.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
> news:OqzqmWrEFHA.2572@.tk2msftngp13.phx.gbl...
>>I have an aspx page that uses the ReportViewer control. The dimensions
>>are set at runtime.
>> private void Page_Load(object sender, System.EventArgs e)
>> {
>> reportViewer.ServerUrl = "http://localhost/reportserver";
>> reportViewer.ReportPath = "/Samples/Company Sales";
>> reportViewer.Width = 900;
>> reportViewer.Height = 580;
>> }
>> Is it possible to change the size of the control everytime the browser
>> window is resized?
>> TIA.
>|||Great, I'm glad you got it working. Sometimes I forget all the steps when I
did something, but just remember that it works!!
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:eoca6W5EFHA.2600@.TK2MSFTNGP09.phx.gbl...
> Thank you.
> This worked, but first I had to modify the ReportViewer.dll since, by
> default, it doesn't accept precentage for dimensions.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:ekIm4R5EFHA.3200@.TK2MSFTNGP10.phx.gbl...
>> You can set the size to a percent.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
>> news:OqzqmWrEFHA.2572@.tk2msftngp13.phx.gbl...
>>I have an aspx page that uses the ReportViewer control. The dimensions
>>are set at runtime.
>> private void Page_Load(object sender, System.EventArgs e)
>> {
>> reportViewer.ServerUrl = "http://localhost/reportserver";
>> reportViewer.ReportPath = "/Samples/Company Sales";
>> reportViewer.Width = 900;
>> reportViewer.Height = 580;
>> }
>> Is it possible to change the size of the control everytime the browser
>> window is resized?
>> TIA.
>>
>

Changing MOLAP dimensions to ROLAP

I have a working SSAS 2005 cube running against a small SS2005 database and successfully deployed so that it can be seen across the internet, and Excel 2002 or 2003 with the correct OLEDB provider installed can view the cube in a pivot table.

I want to be able to demonstrate that the cube dynamically updates when the underlying data changes.

I have therefore changed the measure partition to ROLAP, and now realise that I need to change the dimensions to ROLAP too. I have changed all except one of them successfully. Trying to change the last one causes SSAS2005 to crash during deployment, apparently with no explanation.

On some occasions, deploying the cube reports error:

Internal error: An unexpected error occurred (file 'mdhierarchy.cpp', line 3142, function 'MDUnmaterializedHierIter::Init'). 0 0

rather than killing SSAS2005.

If I try to specify Proactive Caching for this dimension, it gets very confused, because it reports it as a MOLAP dimension, when it isn't.

The dimension it is getting upset about accesses the database through a view.

Has anyone else run into this? If so, what can be done about it? It looks like I have found a bug in SSAS2005.

Have you tried installing SQL Server 2005 service pack 1 to see if you still get the same problem there? http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

If this is not working, please try and contact Customer Support to report the problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Dear Edward,

Thanks for the suggestions.

The problem has shown up after upgrading to SP1, so I will have to take up your suggestion of contacting Customer Support.

Changing FormatString for attribute of a dimension

i can't change the value of a format string for attributes of dimensions.

For Cubes is easy, right-click on the measure -> Proprieties -> FormatString

but for the attributes of a dimension I cannot find where I can change this proprieties..

Someone can help me?

thank you

Riccardo

You cannot find it, because there isn't FormatString for attributes. FormatString is a property which applies to cell values, so specifying different formatting for different attributes doesn't make much sense, as they will simply conflict with each other when applied to the cell. You can specify different formatting for different attribute members, however. Check the CustomRollupOptions property, which allows you to do so.|||

i can't do what i want to do :)

my problem is: I have an attribute in a dimension which assumes values from 0.0001 to 0.0099

I don't know why but this attribute when I browse the dimension is visualized as ".0001" (without the zero)

I want this zero!! :)

ho can I to make it appear with CustomRollupOptions property!?!

|||

Is it not possible to do a named calculation in the data source view and use it in the dimension?

You use TSQL like:

Case When MyColumn < = 0.001 Then 0

Else MyColumn

HTH

Thomas Ivarsson

|||

I think wildthink wants a leading zero, i.e. 0.0001 instead of .0001

Anyway, this is formatting of attribute members, not formatting of cell values, therefore FormatString is not applicable here. You should instead, as Thomas suggests, put a named calculation in DSV which will do formatting for you, using appropriate SQL functions.

|||

>I think wildthink wants a leading zero, i.e. 0.0001 instead of .0001

yes!!

thank you for your answers.

but now i have a new question..

how can I make a named calculation for obtained what I want?

In DSV if I do "Explore Data" on the table of my dimension I can see my attribute correctly (with the leading zero), how create a named calculation to see this zero also when I browse the dimension?

thank you again!

Riccardo

|||

If you can accept a string in the dimension you could try

Named Calculation = MyColumnText

Case When MyColumn between 0.0001 and 0.0099 Then '0' + Cast(MyColumn as Char(4))

Else Cast(MyColumn as char(4))

End

I am not sure about what you would like to do with the other values that are outside of the TSQL-Case here.

This is from memory only so you might have to try:

'0.' + Cast(MyColumn as Char(4))

HTH

Thomas Ivarsson

|||

>If you can accept a string in the dimension you could try

your solution works :)

thank you very much!

Changing FormatString for attribute of a dimension

i can't change the value of a format string for attributes of dimensions.

For Cubes is easy, right-click on the measure -> Proprieties -> FormatString

but for the attributes of a dimension I cannot find where I can change this proprieties..

Someone can help me?

thank you

Riccardo

You cannot find it, because there isn't FormatString for attributes. FormatString is a property which applies to cell values, so specifying different formatting for different attributes doesn't make much sense, as they will simply conflict with each other when applied to the cell. You can specify different formatting for different attribute members, however. Check the CustomRollupOptions property, which allows you to do so.|||

i can't do what i want to do :)

my problem is: I have an attribute in a dimension which assumes values from 0.0001 to 0.0099

I don't know why but this attribute when I browse the dimension is visualized as ".0001" (without the zero)

I want this zero!! :)

ho can I to make it appear with CustomRollupOptions property!?!

|||

Is it not possible to do a named calculation in the data source view and use it in the dimension?

You use TSQL like:

Case When MyColumn < = 0.001 Then 0

Else MyColumn

HTH

Thomas Ivarsson

|||

I think wildthink wants a leading zero, i.e. 0.0001 instead of .0001

Anyway, this is formatting of attribute members, not formatting of cell values, therefore FormatString is not applicable here. You should instead, as Thomas suggests, put a named calculation in DSV which will do formatting for you, using appropriate SQL functions.

|||

>I think wildthink wants a leading zero, i.e. 0.0001 instead of .0001

yes!!

thank you for your answers.

but now i have a new question..

how can I make a named calculation for obtained what I want?

In DSV if I do "Explore Data" on the table of my dimension I can see my attribute correctly (with the leading zero), how create a named calculation to see this zero also when I browse the dimension?

thank you again!

Riccardo

|||

If you can accept a string in the dimension you could try

Named Calculation = MyColumnText

Case When MyColumn between 0.0001 and 0.0099 Then '0' + Cast(MyColumn as Char(4))

Else Cast(MyColumn as char(4))

End

I am not sure about what you would like to do with the other values that are outside of the TSQL-Case here.

This is from memory only so you might have to try:

'0.' + Cast(MyColumn as Char(4))

HTH

Thomas Ivarsson

|||

>If you can accept a string in the dimension you could try

your solution works :)

thank you very much!

changing dimensions

Hi,
how to model changes (I've read R.Kimball) in dimensions and (more
important) how to implement them in OLAP e.g. MS AS ?
I read some papers from scientists but they are not based on commercial
solutions - I don't know how to show changes in MOLAP and how to solve
the problem.
can you give me any suggestions, links etc. ?
thx in advance
Joel"Joel" <dmrozek99@.poczta.onet.pl> wrote in message
news:4005442F.3060307@.poczta.onet.pl...

quote:

---

> Hi,
> how to model changes (I've read R.Kimball) in dimensions and (more
> important) how to implement them in OLAP e.g. MS AS ?
> I read some papers from scientists but they are not based on commercial
> solutions - I don't know how to show changes in MOLAP and how to solve
> the problem.
> can you give me any suggestions, links etc. ?
>

---

A little background for you - I am currently in the process of developing a
prototype for a Kimball-based data warehouse. I have experienced your
challenges but found Kimball's methodology very practical and beneficial.
To answer your questions:
1. Links: Your best bet would be www.rkimball.com, select the articles and
Ralph's Classic Favorites. You should also buy his book "Data Warehouse
Lifecycle Toolkit".
2. Modeling changes in dimensions: this is a very important topic. Once
again, this is addressed in Kimball's articles on slowly changing
dimensions.
For more specific answers, please provide specific questions.
HTH