Has anyone had success in getting a report to generate by using an SSIS
package as it's data source? If so - can you share how you got it to work -
a couple of us who are pretty able bodied can't seem to get it to work as
Microsoft reports it should.Just visit this site for a very good hands on
http://blogs.msdn.com/bimusings/archive/2006/07/19/671743.aspx and ofcourse
MSDN for configuration as well.
I have tried it, its working fine.
Amarnath
"Joe" wrote:
> Has anyone had success in getting a report to generate by using an SSIS
> package as it's data source? If so - can you share how you got it to work -
> a couple of us who are pretty able bodied can't seem to get it to work as
> Microsoft reports it should.
>
Showing posts with label package. Show all posts
Showing posts with label package. Show all posts
Monday, March 26, 2012
Wednesday, March 7, 2012
Report based on Oracle Package
I want to use the results of a stored procedure from an Oracle package as my source for a report. But the stored procedure isn't listed on the dropdown when I try to add it, even though it's listed under "Procedures" in the server explorer with the [package name].[procedure name] format, but when I try typing that I just get a procedure does not exist message.You can do this programatically by loading the results into a dataset, and loading the dataset into the report. Cheers!|||Thakns. I'm pulling from five tables, so I guess I'd best get started.|||
I've created the dataset, and I can bind it to a grid, but I'm having trouble using it as a datasource for my report.
I used
ReportViewer2.LocalReport.DataSources.Add(New ReportDataSource("ds"))ReportViewer2.DataBind()but then if I use =!Fields.LAST_NAME.Value in my table on my report I get a "report has no dataset" message and if I use =(!Fields.LAST_NAME.Value, "ds") I get the same.
Suggestions?
Subscribe to:
Posts (Atom)