Reporting Services 2005 Metadata

Greetings,

I'm creating a new data model using Reporting Services 2005. The database has the standard generic names like 'idSystem' etc. I have created a Metadata file with user friendly names 'Control System Id', but rather than have to retype all those names and descriptions over into the [Friendly Name Property] I'd like to try to pull that information into the model.

So my question is...

Does anyone know where are the Friendly Names property is stored and can I program that field to pull from another file?

Thanks

- Will

Right click on the model in VS and select View Code. If it is set, the Friendly Name for each Entity element is an element called Name. Because you can nest Entity elements in folders, there is no set XPath you can use other than //Entity.

R

|||

Great Thanks Ron.... I'm having server issues now.. but I will try this.

Thanks again

-Will

sql

Reporting Service Subscriptions E-mail Configuration

Hello Group,
I am trying to set up a e-mail rendered Standard subscription in Report
Server.
I have edited the RSReportServer.config file according to BOL.
Can anyone give me an example of a working SMTP E-mail enabled config.
Thanks,
Heres the error I recieve in My Subscriptions. I am included in the RS
System Admin role.
"Failure sending mail: The server rejected the sender address. The server
response was: 505 Authentication required"
--
Application Engineer / DBA
UCLA SOMYou will need to grant the report server service account permission to send
e-mail to your SMTP server.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:1257729F-CE95-4F69-9134-F9DB8A5B59C7@.microsoft.com...
> Hello Group,
> I am trying to set up a e-mail rendered Standard subscription in Report
> Server.
> I have edited the RSReportServer.config file according to BOL.
> Can anyone give me an example of a working SMTP E-mail enabled config.
> Thanks,
> Heres the error I recieve in My Subscriptions. I am included in the RS
> System Admin role.
> "Failure sending mail: The server rejected the sender address. The server
> response was: 505 Authentication required"
>
> --
> Application Engineer / DBA
> UCLA SOM

Reporting Service not installed even they say it was installed

When trying to install Rs on Win2003 server running standard SQL2k SP3a I get into strange situation.
On start of installation I get statement that asp.net and Visual studio are not installed or not running (they are installed and running)
Than it proceedes to install Reporting services, goes through all dialogues, states it is installed
But it is not! I can see RS books, but not the program, also no reporting services are running .
Help
Natalijahi,
i prepared a documentation to install sps,sqlserver and
reporting services in a machine...i'm sending it to
you..just leave with the sharepoint and do the
remaining ..u dont need to change any file name or any
thing . just follow the procedure. better to use sql
server enterprise edition
************
To configure a server running share point portal server,
sql server , analysis services and reporting services
Software Requirements:
1. windows 2003 server enterprise edition.
1.1. Configure application server (enable both front page
extensions and asp.net ) to install IIS.
1.2. Install smtp server
1.3. Configure DNS giving appropriate IP address.
2. SQL Server 2000 Enterprise Edition with Analysis
Services (if reqd) and service packs for both SQL server
and Analysis services.
3. Visual Studio .net Enterprise Architecture
4. Share Point Portal Server
Install share point portal server with out
desktop engine if u r using sql server on the same
machine.
while configuring share point portal server it
will ask to remove front page server extensions at the
time of creating a portal. remove the front page server
extensions and then restart the machine and after that
create a portal site.
5. Reporting services
While installing reporting services it will
check the system and gives a warning message that share
point is also installed in the system and we need to
manually configure reporting services.
leave it and go for the next tab.
Specify a domain/user account where ever asked.
unckeck the ssl certification if u dont have
any and check direct to default
website.
Then continue installing.
After installation
1. go to IIS
right click on reports--> properties--
>configuration -->extensions-->edit
and then uncheck if "Verify that the file exists" is
checked.
and then click OK
close IIS.
2. open E:\Inetpub\wwwroot\webconfig file.
2.1. in <http Modules>
include the third line also.
<add name="Session"
type="System.Web.SessionState.SessionStateModule"/>
and change the below line as follows
pages enableSessionState="true" enableViewState="true"
enableViewStateMac="true" validateRequest="false" />
3. In cmd prompt go to
E:\Program Files\Common Files\Microsoft Shared\web server
extensions\60\BIN
type
stsadm -o addpath -url http://localhost/reportserver -type
exclusion
and
stsadm -o addpath -url http://localhost/reports -type
exclusion
4. in cmd prompt go to
E:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer
type
rsactivate -c "rsreportserver.config"
Then restart the machine
ur configuration is complete now.
*********************
>--Original Message--
>When trying to install Rs on Win2003 server running
standard SQL2k SP3a I get into strange situation.
>On start of installation I get statement that asp.net and
Visual studio are not installed or not running (they are
installed and running)
>Than it proceedes to install Reporting services, goes
through all dialogues, states it is installed
>But it is not! I can see RS books, but not the program,
also no reporting services are running .
>Help
>Natalija
>.
>