Report Model Builder in SQL Server 2005 CTP

Will the model builder have the ability to build models against an Oracle
database? I may be missing something in the CTP but it looks like I can only
make a SQL Server database data source.Directly supported are:
- Analysis Services 2005 data sources
- SQL Server 2000 and 2005 relational data sources
At this point, other data sources (e.g. Oracle) can only be accessed through
the linked server functionality of SQL Server. We are aware that this
approach has restrictions and drawbacks and we are looking into directly
supported additional data sources natively in future releases.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:DEEE25FF-79DA-498C-8977-0EF2C631E8E0@.microsoft.com...
> Will the model builder have the ability to build models against an Oracle
> database? I may be missing something in the CTP but it looks like I can
> only
> make a SQL Server database data source.

Report Headers & Footers

I see the Page Header and Page footer, but what about Report Header and Report Footers? Doesn't look like ssrs has this ability, am I wrong?

I was able to accomplish what I want by following the suggestion in this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377566&SiteID=1

IMO, this is lame. Come on, even Access has a Report Header & Report Footer, what were they thinking? Seems like to get simple stuff done in ssrs you have to basically find hacks and workarounds. Not impressed.

|||

Hello,

Would the table header/footer work for you?

Jarret

|||

Yes, I ended having to use the table header/footer like it is described in the link in my previous post. I still think this is kind of a hack and am wondering why ReportHeader & ReportFooter were left out.

|||

The link in your previous post takes me to another post by you for Parameter Validation Failed. Oh well, glad you got it working.

Maybe I am missing something, but I can't think of any reason why they wouldn't be considered synonymous. Can you give me an example of something a report header can do that a table header can't (or vice versa), just for my knowledge?

Jarret

|||Sorry about that! I have fixed the link to point to the correct article, thanks for pointing that out.