Can I access my data source in Custom Report Item during design mode?

Hi,

I'm developing a Custom Report Item and would like to fill my properties dialog in design mode with real data. I have the name of the data source and the command text for the corresponding report dataset, read from the report design.

Is it possible to create an ado.net dataset so that I can display and use real data in my properties dialog box? First problem I have is to get the connection string from the data source string. I found no docs for that, especially the Microsoft.ReportingServices.DataExtensions.ReportDataSource class is not documented. Am I on the right way with that?

Thomas

Check out.. http://msdn.microsoft.com/msdnmag/issues/06/10/SQLServer2005/default.aspx

|||

Sorry,

I can't see where that relates to my question. Did I miss the point?

After rereading the article, I didn't find any word on how to get actual data values in design mode.

Maybe I didn't state clear enough what I want to obtain:

I would like to get actual data values from the dataset in design mode in order to use them for a properties dialog. I have access to the sql statement from reportDataSet.CommandText already and I know the datasource name (that somehow is an alias for the db connection). What's missing is how to get the connection string from the datasource - then I can open the connection and read the data using ado.net.

Thomas

|||

For connection string:

check the DataSourceDefinition class in Reporting Service web service

Can I access my data source in Custom Report Item during design mode?

Hi,

I'm developing a Custom Report Item and would like to fill my properties dialog in design mode with real data. I have the name of the data source and the command text for the corresponding report dataset, read from the report design.

Is it possible to create an ado.net dataset so that I can display and use real data in my properties dialog box? First problem I have is to get the connection string from the data source string. I found no docs for that, especially the Microsoft.ReportingServices.DataExtensions.ReportDataSource class is not documented. Am I on the right way with that?

Thomas

Check out.. http://msdn.microsoft.com/msdnmag/issues/06/10/SQLServer2005/default.aspx

|||

Sorry,

I can't see where that relates to my question. Did I miss the point?

After rereading the article, I didn't find any word on how to get actual data values in design mode.

Maybe I didn't state clear enough what I want to obtain:

I would like to get actual data values from the dataset in design mode in order to use them for a properties dialog. I have access to the sql statement from reportDataSet.CommandText already and I know the datasource name (that somehow is an alias for the db connection). What's missing is how to get the connection string from the datasource - then I can open the connection and read the data using ado.net.

Thomas

|||

For connection string:

check the DataSourceDefinition class in Reporting Service web service

|||Did you ever make any progress on this? I'm trying to get to the Connection String property of the data source from my Custom Report Item code.

Any direction is appreciated.

Thanks

J

Can a Login/Password be validated against a Domain login/passord using a prompt dialog

I have an application database on SQL Server 2K and we've got an NT domain.
I want the users to type in their login and password, but I'd like to
validate that password against the windows NT Domain. Can this be done?
Jared HoffmanHi
This sounds like something that will not be permitted as you could then save
the users account details
You can use integrated security but you don't need a login box, unless you
want a secondary method of verification that you maintain.
John
"Jared Hoffman" <hoffmanj@.kenyon.edu.NO_SPAM> wrote in message
news:edQWKBfDEHA.3804@.TK2MSFTNGP09.phx.gbl...
> I have an application database on SQL Server 2K and we've got an NT
domain.
> I want the users to type in their login and password, but I'd like to
> validate that password against the windows NT Domain. Can this be done?
>
> Jared Hoffman
>|||If the users login to their domain, then they can simply use their nt
credentials to connect.
Change the SQL Server to use Windows Authentication. And change your
application connection string
to make Trusted Connections.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||My application will be used on computers that may or may not be joined to
the domain so I can't rely on Windows Authentication. I'd like to be able to
authenticate users in such a way I don't have to store another set of user
passwords.
Thanks,
Jared Hoffman
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:pd5X%23SfDEHA.3608@.cpmsftngxa06.phx.gbl...
> If the users login to their domain, then they can simply use their nt
> credentials to connect.
> Change the SQL Server to use Windows Authentication. And change your
> application connection string
> to make Trusted Connections.
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||previous post:
"My application will be used on computers that may or may not be joined to
the domain so I can't rely on Windows Authentication. I'd like to be able to
authenticate users in such a way I don't have to store another set of user
passwords.
"
Couple of options:
1. Standard SQL Security
2. Application roles
3. Trusted Security using duplicate nt username and passwords
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Calling the New server Registration Dialog window

Hi,

I'm aware of using SmoApplication.EnumAvailableSqlServers to list network SQL Servers, however I would like to go a step-further and a call the "New Registered Server" dialog (follow the below link), in a similar way that you can use an instance of DataLinksClass to call a udl style connection string builder.

Is this an object that can this be called, or will I need to build it?

http://www.thesalemlot.com/serverreg.jpg

Thanks

Drew

AS SQL Server MS is just a WIndows application built on top of SMO you can′t call this functio, you have to build that on your own. Bu you can take the one Microsoft has built as a template. Simply refelctor the code and take this a a good starting point to built your own register diallog.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Well, I'd never heard off Reflector until you mentioned it. But if I understand you correctly, this could really help me for this and future projects. I've download it, but am unsure how to use it. I'd appreciate it if you could spare a moment to explain it. How do I load that particular part of SMO to view the code behind it?

Thanks

Drew

|||Well you have to reflector the code of SSMS to find the appropiate parts. Find the Forms section within the assembly and see what is happening behind the scenes-

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||THANKS FOR REGISTERED MY NEW WINDOW

Calling the New server Registration Dialog window

Hi,

I'm aware of using SmoApplication.EnumAvailableSqlServers to list network SQL Servers, however I would like to go a step-further and a call the "New Registered Server" dialog (follow the below link), in a similar way that you can use an instance of DataLinksClass to call a udl style connection string builder.

Is this an object that can this be called, or will I need to build it?

http://www.thesalemlot.com/serverreg.jpg

Thanks

Drew

AS SQL Server MS is just a WIndows application built on top of SMO you can′t call this functio, you have to build that on your own. Bu you can take the one Microsoft has built as a template. Simply refelctor the code and take this a a good starting point to built your own register diallog.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Well, I'd never heard off Reflector until you mentioned it. But if I understand you correctly, this could really help me for this and future projects. I've download it, but am unsure how to use it. I'd appreciate it if you could spare a moment to explain it. How do I load that particular part of SMO to view the code behind it?

Thanks

Drew

|||Well you have to reflector the code of SSMS to find the appropiate parts. Find the Forms section within the assembly and see what is happening behind the scenes-

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||THANKS FOR REGISTERED MY NEW WINDOW