Report drilldown still a major issue - HotFix needed!

While testing the latest RC1 SRS software and trying to get report drill down
in a chart working, I found that it was not working as expected. I thought
that this might be a Dundas issue, but has since learned that this is a MS
issue.
I understand that MS is aware of this and I strongly believe that this needs
to be fixed via HotFix rather than waiting until release time or later. We
are working towards a Spring 2006 release of our software and report
drilldown is one of the most important elements of our application.
Has anyone else ran into this issue?
Thanks!
KeithThis sound like you need a fix. I would contact Microsoft Product Support
Services. If it is indeed a fix and not user error, all fees are refunded.
If you specific details on what the bug is, I can look it up and see if it
is fixed if it is something we know about.
bradsy@.microsoft.com
--
| Thread-Topic: Report drilldown still a major issue - HotFix needed!!
| thread-index: AcXERUgoHQxmMZhhRD29mQIbnrU+Aw==| X-WBNR-Posting-Host: 66.89.74.203
| From: "=?Utf-8?B?S2VpdGg=?=" <Keith@.discussions.microsoft.com>
| Subject: Report drilldown still a major issue - HotFix needed!!
| Date: Wed, 28 Sep 2005 08:57:09 -0700
| Lines: 14
| Message-ID: <E55E5CE0-899D-46CA-87F2-11F58CAF6787@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53277
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| While testing the latest RC1 SRS software and trying to get report drill
down
| in a chart working, I found that it was not working as expected. I
thought
| that this might be a Dundas issue, but has since learned that this is a
MS
| issue.
|
| I understand that MS is aware of this and I strongly believe that this
needs
| to be fixed via HotFix rather than waiting until release time or later.
We
| are working towards a Spring 2006 release of our software and report
| drilldown is one of the most important elements of our application.
|
| Has anyone else ran into this issue?
|
| Thanks!
| Keith
|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).