Report delivery

Is it possible to schedule report delivery using data condition in the
report?
Another words, if report has particular data then it has to be delivered?
ThanksI think you want a data-driven subscription to filter recipients based on
data that is also in the report queries. Here's from the help file.
Use the Create Data-driven Subscription pages to build or modify a
subscription that uses dynamic data to determine the recipients of the
subscription, delivery settings, and report parameter values. At run time,
the report server runs a query to get values used for subscription settings.
Steve MunLeeuw
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:%238$NIoFyGHA.5068@.TK2MSFTNGP02.phx.gbl...
> Is it possible to schedule report delivery using data condition in the
> report?
> Another words, if report has particular data then it has to be delivered?
> Thanks
>|||I haven't been able to get this to work even after previewing the report in
the dev environment. Any successes?
--
Brian J. Matuschak
brian@.electronic-atlas.com
"Steve MunLeeuw" wrote:
> I think you want a data-driven subscription to filter recipients based on
> data that is also in the report queries. Here's from the help file.
> Use the Create Data-driven Subscription pages to build or modify a
> subscription that uses dynamic data to determine the recipients of the
> subscription, delivery settings, and report parameter values. At run time,
> the report server runs a query to get values used for subscription settings.
> Steve MunLeeuw
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:%238$NIoFyGHA.5068@.TK2MSFTNGP02.phx.gbl...
> > Is it possible to schedule report delivery using data condition in the
> > report?
> > Another words, if report has particular data then it has to be delivered?
> >
> > Thanks
> >
>
>

Report Builder: Display Hyperlink

Using the Report Builder, the users need to generate a report in which one of the columns should have a hyperlink that navigates to a particular aspx page.

Now, I am able to provide for a hyperlink enabled column from the static reports designed using the Report Server Project. I have used the Navigation --> Jump To URL property of TextBox for this.

But the users dont want to depend on static reports and need this to be available via Report Builder.

I tried to provide for the <a href="somepage.aspx">xxx</a> from the named query in the datasource view, but when I run the report, the Reporting Service HTMLEncodes the tags and displays everything as text.

Is there a way to generate a hyperlink using Report Builder.

I'd linke to know the answer to the same question: How can you display a hyperlink in a report built using the Report Builder (NOT the report designer). Even a simple textbox that embeds a single url would be nice.... how can this be done?

Report Builder: Display Hyperlink

Using the Report Builder, the users need to generate a report in which one of the columns should have a hyperlink that navigates to a particular aspx page.

Now, I am able to provide for a hyperlink enabled column from the static reports designed using the Report Server Project. I have used the Navigation --> Jump To URL property of TextBox for this.

But the users dont want to depend on static reports and need this to be available via Report Builder.

I tried to provide for the <a href="somepage.aspx">xxx</a> from the named query in the datasource view, but when I run the report, the Reporting Service HTMLEncodes the tags and displays everything as text.

Is there a way to generate a hyperlink using Report Builder.

I'd linke to know the answer to the same question: How can you display a hyperlink in a report built using the Report Builder (NOT the report designer). Even a simple textbox that embeds a single url would be nice.... how can this be done?sql

Report Builder/SRS connectio to Postgres

Hi

I have a customer who wants to connect Reporting Services, Report Builder in particular to Postgres database.

By reading the forums, it looks like ODBC is out of picture.

Can they use some sort of .net provider etc.

I am getting the customer to ETL the data into a SQL Server ODS/Data mart

Has anyone got this working ? would like to hear from you.

Regards.. Yasin

Masestro Systems Ltd, New Zealand.

Report Builder currently works only with MS SQL databases. Semantic queries produced by Report Builder are tranbslated to TSQL and translation uses some of TSQL specifics. So sending those queries directly to any database server other than SQL will not work.

You can either pump data into MSSQL or use linked servers.
If you pump data, make sure that db schema in MSSQL has valid PKs/FKs
If you use linked servers or OPENDATASOURCE you will need to manually craft DSV, specify FKs/PKs and the generate model off it (all is done in Model Designer).