Monday, March 19, 2012
New ReportViewer Component
It seems it is possible to export to export to pdf through ReportViewer in
SQL Server 2005 and VS 2005. Is it possible to use â'Microsoft Report Viewer
Redistributable 2005â' in VS.Net 2003 and SQL Server 2000 and use it to export
pdf automatically?The new controls are based on the 2.0 framework. VS.Net 2003 and RS 2000 are
1.1 framework. You cannot use the controls in VS 2003. Also, you cannot use
the controls against RS 2000. The VS 2005 controls only work in VS 2005 with
RS 2005 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:F932E66E-6BC1-4579-ABD0-36F193A056E7@.microsoft.com...
> Hello,
> It seems it is possible to export to export to pdf through ReportViewer in
> SQL Server 2005 and VS 2005. Is it possible to use "Microsoft Report
> Viewer
> Redistributable 2005" in VS.Net 2003 and SQL Server 2000 and use it to
> export
> pdf automatically?
>
Monday, February 20, 2012
new custom flat file connection manager component
The standard flat file connection component does not handle flat files with different column counts on different rows. Since that's the type of file I have to read, I like to create a modified version of the flat file connection manager that can do this. I have found some info in how to create a connection manager. But I can't find anything that tels me how to build one that would be recognized by the flat file source dataflow component.
So how do you build an connection manager that can used by the standard flat file source component? Anyone ever did this or knows were to get the docs?
I know my problem is also solvable by reading the row into a single column and then using a script component to split them but that is not the solution I want.
The new connection manager is not going to solve this problem. The parsing logic is not part of the connection manager, it is part of the Flat File source adapter. You would need to build a new source, not connection manager.
Thanks,
Bob