Defualt Value Question?

Hi,everyone
I have a report.
I List a employees in a table,I use a parameter "DepartmentID"(0-n) to
query employees dataset1.
I have other dataset2 ,the department from a sql text.
the parameter "departmentId" from dataset2,and I need a default value
"All" to list all employees.
But the default value not work.
RedmoonIf you use available values, they should include possible default value (in
your case "All'). If default value does not match any of available values it
is rejected.
--
Lev
http://blogs.msdn.com/levs
This posting is provided "AS IS" with no warranties, and confers no rights.
"Redmoon" <heavenwing@.163.com> wrote in message
news:Xns952DBA9506D1Fheavenwing163com@.207.46.248.16...
> Hi,everyone
> I have a report.
> I List a employees in a table,I use a parameter "DepartmentID"(0-n) to
> query employees dataset1.
> I have other dataset2 ,the department from a sql text.
> the parameter "departmentId" from dataset2,and I need a default value
> "All" to list all employees.
> But the default value not work.
> Redmoon

Defualt number of copies

Hi all - must be a simple one but can't find where to set this - I need to set the number of copies to a default of '3' for my despatch team.

Could anyone point me in the right direction?

Thanks in advaice!

Stephen.

Hi - can anyone help with this? The despatch team are going crazy :( I can't find info on this anywhere!

Thanks!

|||

It is not possible to change the Number of copies in the reporting services client print control

|||

Maybe you can avoid printing by making each of the team members subscribers to the report? They can receive an email with up-to-the minute data at the time of their chosing, and if desired, can print the report then.

|||

Unfortunately I can't do that - the despatch team pick and then despatch an order - many times a day so need to do it on an ad-hoc basis. Really disapointed that the reporting add-in doesn't have this feature. Would have thought that this would have been a standard option :(

Any posibility of Crystal doing this does anyone know?

Thanks!

default view for OLAP cube when first accessed

Hello,

I am using MS Analysis server for OLAP cubes and viewing these cubes using Cognos. What I want to do is to have defualt view defined for the particular cube whenever it is first accessed. I have been able to set the default month (i.e. current month). But in the default view I want data shown across multiple dimensions. E.g. on first view my client should be able to see data against dimensions Date and Product nested on y-axis and dimensions Destination and Time nested on x-axis.

Is it possible to achieve this using MDX query?

Any ideas will be greatly appreciated.

Thanks,

Akber

Hello!

I think that this can only be achieved if you have a client tool that supports writing MDX queries/selects. You cannot do it directly in AS2000 or SSAS2005, you will need a client. Cubes are not repositories for reports.

Since you are using Cognos you will have to rely of this supplier's tools for creating and saving reports.

HTH

Thomas Ivarsson