Custom object or DataSet ?

Hello
I'm using SQL 2000 server and I have question about logining to server. Is it possible to include Active Directory structure? I know I can define SQL user or use Windows Based Account, but I havent read anywhere how to integrate Active Directory. If there is solution or if anybody has experience with this problem, I would be grateful forhelp or reference (btw, I'm using win 2003 server).

Thanks
MatjazCheck this link (http://search.win2000mag.net/query.html) and corresponding links.

Custom Height Footer

Hello
I really hope some one can help me resolve this problem.
I need to be able to print my footer at different heights.
For example:
On the first page i need my footer to start printing at 1.5 in
And all other pager at 0.5 in
Im using Crystal Report 10Here is the structure of my report

GH1 - ITEMNO
GH2 - Header for the ITEMNO
DETAIL at the and of page1 I need to change footer height
GF2 Not Used
GF1A - ITEMNO Additional Info
GF1B - ITEMNO Additional Info|||you can create two footers one at 1.5 and the other at 0.5.

Create 2 shared booleanvar footer_1 and footer_2.

You can manage these variables to show and hide the required footer. First footer_1:= true;
footer_2:=false;

after showing the firt footer or in first footer change the variables to
footer_1:=false;
footer_2:=true;

now your 2nd footer will show onward.

Custom Data Processing Extensions/Custom Data Providers

Hello!

I'm trying to understand the limitations that SSRS places on a developing reports involving multiple data sources and how I can possibly create a custom data provider for a report that will consolidate data from multiple data sources..

thanks in advance.

Doug.

If you want to see what is all involved in creating a Custom Data Processing extension, I used the FSI example that comes with the SQL Server install. It gives you a good idea of what needs to be involved.

I extended and added to it a great deal but the basis for what you need to do is in there. It's non-trivial, but very do-able.

|||

I'll look into that!

THanks!!!!

doug

|||

Instead of implementing a data processing extension, you should look at the T-SQL OPENROWSET command

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

Or linking servers

http://msdn2.microsoft.com/en-us/library/ms188279.aspx

These give you the ability to consolidate multiple data sources and it is a lot easier than implementing your own data processing extension to do the same. The only caveat is that it requires SQL Server.

|||

We're using Oracle...so that kind of bites...

well, we've hit a snag in our development of our extension..

I cannot figure out why I get this exception when we try to generate a DataSet in our SSRS IDE:

A connection cannot be made to the database,
Set and test the connection string.
Additional Information:
The data extension FOCUS could not be loaded. Check the the configuration files RSReportDesigner.config(Microsoft.ReportingServices.Designer)

We added the following to the RSReportDesigner.config file:

<Extension Name="FOCUS" Type="PPD.Focus.FocusDPE.FocusDbConn, PPD.Focus.FocusDPE"/>

And the dll's complete with the proper namespaces are all in the proper directories:

C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin\PPD.Focus.FocusDPE.dll
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PPD.Focus.FocusDPE.dll

We've tried to step into the extension code using a techique outlined in MSDN without any luck. We've also attempted to write out errors the Event Viewer, but it doesn't even seem to get into the connection object,

Any Idea of where I'm going wrong?

thanks!

Doug

Custom Data Processing Extensions/Custom Data Providers

Hello!

I'm trying to understand the limitations that SSRS places on a developing reports involving multiple data sources and how I can possibly create a custom data provider for a report that will consolidate data from multiple data sources..

thanks in advance.

Doug.

If you want to see what is all involved in creating a Custom Data Processing extension, I used the FSI example that comes with the SQL Server install. It gives you a good idea of what needs to be involved.

I extended and added to it a great deal but the basis for what you need to do is in there. It's non-trivial, but very do-able.

|||

I'll look into that!

THanks!!!!

doug

|||

Instead of implementing a data processing extension, you should look at the T-SQL OPENROWSET command

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

Or linking servers

http://msdn2.microsoft.com/en-us/library/ms188279.aspx

These give you the ability to consolidate multiple data sources and it is a lot easier than implementing your own data processing extension to do the same. The only caveat is that it requires SQL Server.

|||

We're using Oracle...so that kind of bites...

well, we've hit a snag in our development of our extension..

I cannot figure out why I get this exception when we try to generate a DataSet in our SSRS IDE:

A connection cannot be made to the database,
Set and test the connection string.
Additional Information:
The data extension FOCUS could not be loaded. Check the the configuration files RSReportDesigner.config(Microsoft.ReportingServices.Designer)

We added the following to the RSReportDesigner.config file:

<Extension Name="FOCUS" Type="PPD.Focus.FocusDPE.FocusDbConn, PPD.Focus.FocusDPE"/>

And the dll's complete with the proper namespaces are all in the proper directories:

C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin\PPD.Focus.FocusDPE.dll
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PPD.Focus.FocusDPE.dll

We've tried to step into the extension code using a techique outlined in MSDN without any luck. We've also attempted to write out errors the Event Viewer, but it doesn't even seem to get into the connection object,

Any Idea of where I'm going wrong?

thanks!

Doug