Can we define dynamic calculation members?

Hi, all here,

I am also wondering is there any way for us to define dynamic calculation members across different levels? (e.g. whatever dimension levels you are browsing you will be able to see the calculated members bound to the particular dimension level you are browsing).

Hope it is clear for your kind advices and help.

I am looking forward to hearing from you shortly for your help.

With best regards,

Yours sincerely,

If you are using MDX (in a query) to calculate your members, I believe if you reference .CurrentMember in any of the attributes/dimensions the calculated member will live in the scope of the Where clause of the query.

If defining it as a calculated measure in the cube, I think it automatically adjusts to the scope of the query.

You can also read up on the SCOPE statement here : http://technet.microsoft.com/en-us/library/ms145989.aspx

Good luck,

John

Can we define dynamic calculation members?

Hi, all here,

I am also wondering is there any way for us to define dynamic calculation members across different levels? (e.g. whatever dimension levels you are browsing you will be able to see the calculated members bound to the particular dimension level you are browsing).

Hope it is clear for your kind advices and help.

I am looking forward to hearing from you shortly for your help.

With best regards,

Yours sincerely,

If you are using MDX (in a query) to calculate your members, I believe if you reference .CurrentMember in any of the attributes/dimensions the calculated member will live in the scope of the Where clause of the query.

If defining it as a calculated measure in the cube, I think it automatically adjusts to the scope of the query.

You can also read up on the SCOPE statement here : http://technet.microsoft.com/en-us/library/ms145989.aspx

Good luck,

John

can u help me to set dynamic database option to crystal reports

hi
I am having 120 crystal reports of 9 and when ever I want to change the DBuser I am facing problem and i have to change for all the 120 reports
IS THERE ANY EASY SOLUTION FOR ME..?
PL HELP ME...:thumb:Hi paste this code in all the view pages of the report and try ...this is working for me in XI verison.
Please do reply me after trying

'' New Code for Passing the DB in Run-Time for CR-XI
Set mainReportTableCollection = Session("oRpt").Database.Tables

For Each mnTable in mainReportTableCollection
With mnTable.ConnectionProperties
.Item("user ID") = DB_UID
.Item("Password") = DB_PWD
.Item("DSN") = CRYSTAL_RPT_DSN
.Item("Database") = DB_NAME
End With
' response.write mnTable.ConnectionProperties.Item("DSN")
mnTable.Location = DB_NAME & ".dbo." & mnTable.name
'mnTable.Location ="crbard.dbo." & mnTable.name
Next

Dim CRXSections, CRXSection, CRXobject, CRXSubreport, CRXsubreports, CrSubtable
Set CRXSections = session("oRpt").Sections
For each CRXSection in CRXSections
For each CRXObject in CRXSection.ReportObjects
If CRXObject.Kind = 5 then 'Subreport
Set CRXSubreport = CRXObject.OpenSubreport
for each crSubTable in CRXSubreport.Database.Tables
' StripLocation(crSubTable)
' crSubTable.SetLogonInfo CRYSTAL_RPT_DSN,DB_NAME , DB_UID, DB_PWD

With crSubTable.ConnectionProperties
.Item("user ID") = DB_UID
.Item("Password") = DB_PWD
.Item("DSN") = CRYSTAL_RPT_DSN
.Item("Database") = DB_NAME
End With
crSubTable.Location = DB_NAME & ".dbo." & crSubTable.name
'crSubTable.Location = "crbard.dbo." & crSubTable.name
next
End IF
next
next
'' Code End for Passing the DB in Run-Time for CR-XI

Can the report table have varying number of columns ??

The requierment is tyo have a dynamic report, that has a table with number of
columns decided on the input from recordset.
The SQL procedure takes in parameters and returns recordset, that can have
varying number of columns. All we want to do is to link this recordset to a
table on the report.
The report table should show the columns as they are in the Recordset. ( and
the column name in the recordset shall appear as the column header in the
Reporting table.)
-- Alok Kumar GuptaThere's really no good way to do this in the current version, no.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Alok" <Alok@.discussions.microsoft.com> wrote in message
news:47BD7BFE-DCAF-4DC1-A360-98BF8F9FB586@.microsoft.com...
> The requierment is tyo have a dynamic report, that has a table with number
of
> columns decided on the input from recordset.
> The SQL procedure takes in parameters and returns recordset, that can have
> varying number of columns. All we want to do is to link this recordset to
a
> table on the report.
> The report table should show the columns as they are in the Recordset. (
and
> the column name in the recordset shall appear as the column header in the
> Reporting table.)
> -- Alok Kumar Gupta
>

Can Reportviewer control size be dynamic

When using an asp.net 2.0 reportviewer control to display an SSRS report, the size of the report is always bigger that the control it is housed in. So you have to scroll back and forth.

Can't the Reportviewer control size be dynamic? What is the general parctice on this?

Thanks

ReportControl and SSRS newbie!

Hi,

I'm not sure what do you mean by "control the size dynamically". Based on my knowledge, if the report does not need to scroll verticall within the iframe, you can handle it in two ways.

First, assign the height, width value in a hard coded way, you can refer the following code which shares the solution.
http://www.codeproject.com/sqlrs/ReportViewer2005.asp

Second, you can set two properties to make the repoertviewer autosize:

AsyncRendering = false; and SizeToReportContent = true;

Thanks.