Displaying Reports

I have a folder with many reports in it. Each report has a name and a
description of the report. How can I group the reports together?
IE:
Data A Report
Data A Chart
Data B Report
Data B ChartThe only way is by name of the report.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"eric_rs1" <ericrs1@.discussions.microsoft.com> wrote in message
news:0D88A0BB-C1A9-44F7-97EF-55F15538F6AA@.microsoft.com...
> I have a folder with many reports in it. Each report has a name and a
> description of the report. How can I group the reports together?
> IE:
> Data A Report
> Data A Chart
> Data B Report
> Data B Chart
>|||Here is another example. I need to have these two reports together.
Daily Phone Stats Report
Weekly Phone Stats Report
"eric_rs1" wrote:
> I have a folder with many reports in it. Each report has a name and a
> description of the report. How can I group the reports together?
> IE:
> Data A Report
> Data A Chart
> Data B Report
> Data B Chart
>|||Can't you use multiple folders?
True, you can only use a single folder when deploying from Visual Studio,
but once deployed, you can move the report anywhere.
"eric_rs1" <ericrs1@.discussions.microsoft.com> wrote in message
news:76F91A9E-DA73-4D9D-9D2B-24658B77BD7C@.microsoft.com...
> Here is another example. I need to have these two reports together.
> Daily Phone Stats Report
> Weekly Phone Stats Report
> "eric_rs1" wrote:
>> I have a folder with many reports in it. Each report has a name and a
>> description of the report. How can I group the reports together?
>> IE:
>> Data A Report
>> Data A Chart
>> Data B Report
>> Data B Chart
>>

display the description of the parameter field in the report

How do i display the description in the report for the parameter field
eg suppose Parameter UWName Value is AA Desc is Andy Arace
I want to display the Desc of the Parameter in the report details instead of the value AA
Pls helpNot sure what you really want, but here goes (VB Code using CRAXDRT COM object):
assumes you already have an instance of the report object open:

Dim objParamDefs As CRAXDRT.ParameterFieldDefinitions
Dim objParamDef As CRAXDRT.ParameterFieldDefinition
.
.
.
.
Set objPrintApp = New CRAXDRT.Application
Set objReport = objPrintApp.OpenReport(strReportSourcePath & strSource)
.
.
.
Set objParamDefs = objReport.ParameterFields

For Each objParamDef In objParamDefs
objParamDef.Print .Prompt
Next
.
.
.
does that help

dave|||Hi, I have the same problem too,
Springsoft, your answer doesnt match with the problem :(

Display Report Description within Report Body

Hi all. I wanted to use the Report Properties|Description within the report.I

thought it would be something like Globals!Description, but it seems

not. Has anyone else found the syntax to use that (or Author) within

the body?I'm pretty sure that when i tried to do this I was advised that The author and description properties are not available to textboxes. Therefore you need to either hard code the values into a textbox(es) or to add the
information to a table and pull it into the report using a dataset.|||

Thanks Will. In that case I'll look into an alternative.

HN

Display Report AUTHOR and DESCRIPTION

What is the syntax to display the report property
fields within a textbox on the report header ?These properties are not exposed in the Report Object Model (which is
accessible from expressions within a report).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave" <davidldoyle@.yahoo.com> wrote in message
news:4e7ae5a2.0406210905.67ff246e@.posting.google.com...
> What is the syntax to display the report property
> fields within a textbox on the report header ?|||"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message news:<uqo1jCAWEHA.2340@.TK2MSFTNGP09.phx.gbl>...
> These properties are not exposed in the Report Object Model (which is
> accessible from expressions within a report).
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Dave" <davidldoyle@.yahoo.com> wrote in message
> news:4e7ae5a2.0406210905.67ff246e@.posting.google.com...
> > What is the syntax to display the report property
> > fields within a textbox on the report header ?
I did not understand your reply in parenthesis....Do you mean
properties are not available, or that they are within expressions
within a report.
Thank you.|||The author and description properties are not available to textboxes. Your
choices are to either hard code the values into a textbox(es) or to add the
information to a table and pull it into the report using a dataset.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave" <davidldoyle@.yahoo.com> wrote in message
news:4e7ae5a2.0406221148.7468775@.posting.google.com...
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:<uqo1jCAWEHA.2340@.TK2MSFTNGP09.phx.gbl>...
> > These properties are not exposed in the Report Object Model (which is
> > accessible from expressions within a report).
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Dave" <davidldoyle@.yahoo.com> wrote in message
> > news:4e7ae5a2.0406210905.67ff246e@.posting.google.com...
> > > What is the syntax to display the report property
> > > fields within a textbox on the report header ?
> I did not understand your reply in parenthesis....Do you mean
> properties are not available, or that they are within expressions
> within a report.
> Thank you.|||I meant that expressions in reports can only access information and metadata
that is exposed in the Report Object Model. This object model contains the
following collections: Fields, Reportitems, Parameters, Globals, User.
The properties for Author and Description are not exposed there. So you
cannot access them.
BTW: these properties are exposed in the Rendering Object Model, but you
would need to write your own custom rendering extension to take advantage of
that and it would still be very hard to solve your initial problem (show
these properties in header / footer).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave" <davidldoyle@.yahoo.com> wrote in message
news:4e7ae5a2.0406221148.7468775@.posting.google.com...
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:<uqo1jCAWEHA.2340@.TK2MSFTNGP09.phx.gbl>...
> > These properties are not exposed in the Report Object Model (which is
> > accessible from expressions within a report).
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Dave" <davidldoyle@.yahoo.com> wrote in message
> > news:4e7ae5a2.0406210905.67ff246e@.posting.google.com...
> > > What is the syntax to display the report property
> > > fields within a textbox on the report header ?
> I did not understand your reply in parenthesis....Do you mean
> properties are not available, or that they are within expressions
> within a report.
> Thank you.

Display measurement description in Excel 2007

In SSAS 2005, you can specify the description for a measurement in its properties. However, how can I show this description in Excel 2007? I've been searching back and forth from the web but couldn't find the answer. Also, not sure how I can specify description for a calculated member... My users would love to see the description for the measurement and calculated member fields in Excel 2007.

It will be great if anyone can help on this!

Mitch

This is a really good question. It simply depends on if the client had implemented it. Early versions of ProClarity Professional did support descriptions from OLAP Services Cubes(SQL Server 7) but this was removed in later versions.

Measures have no member properties either and I have not seen a client that supports these descriptions in SSAS2005.

Your best opportunity is to write this information in a portal like Sharepoint Server /Services.

HTH

Thomas Ivarsson

|||

I'm a bit surprised that Excel 2007 doesn't show you the Measure description property as a tooltip when browsing the list of measures. Major shortcoming in my opinion.

Report Builder on top of a cube shows the measure description as a tooltip.

In terms of editing descriptions on calculated measures, see:

http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Calculation%20Helpers&referringTitle=Home

|||

Tracing the query that Excel sends to SSAS, it does not even ask for the description property, so there is not even a macro or anything like that which you could use to expose this property.

You can get the descriptions from the MDSCHEMA_MEASURES schema rowset. An easy way to get at this is to use the Discover stored proc that I wrote as part of the Analysis Services Stored Procedure project www.codeplex.com/ASStoredProcedures this proc is not part of the current release, but there will be a new release coming out really soon. To use this function now you would need to download the latest source code from codeplex and compile it yourself.

This would give you the ability to write an MDX query like the following:

Code Snippet

CALL ASSP.Discover("MDSCHEMA_MEASURES")

And put the results into an SSRS Report that gave you a nice list of all the measures and their descriptions for a given cube.

|||

Hopefully, Excel 2007 will expose the Measure description property down the road.

Mitch