Credentials for Data Sources - Changing Authentication

I have Visual Studio installed on my local laptop, as well as on the report server. The only place reporting services is installed is on the report server.

I have a solution called “Performance Monitoring”, and within that solution is a report of the same name. That report uses 2 data sets, “DSOne” and “DSTwo” and these data sets are pulled from 2 shared data sources. I can edit the report locally and preview it just fine and the results are what we’re looking for.

Right now, the data sources are all set to Windows authentication. We would like to tie the data sources to a specific user ID and password, so that I or anybody else is able to view the report without having to have a separate login for all those people. I have tried changing the data sources' properties in Visual Studio to reflect using a specific login/pass (my own). I have tried this in Report Manager too – editing the data sources there to use my login and pass. Both of these methods have not worked.

In Visual Studio, in the Solution Explorer, I double click on one of the data sources and go to the credentials tab. “Use Windows Authentication” is checked, so I check “use a specific user name and password” instead and then enter my login and password. When I try to preview the report, it gives me the following error and I am stumped as to why this is:

“An error has occurred during report processing. Cannot create a connection to data source “DSTwo”. Login failed for user “xxx”.”

I have also tried editing the login and password through the “edit” button on the “general” tab of whatever data source I’m working with. The “Use Windows NT Integrated Security” box is checked, so I check the “Use a Specific Name and Password” box and again, type in my login info. When I hit “Test Connection”, I get the following:

“Test connection failed because of an error in initializing provider. Login failed for user ‘xxx.”

Hopefully this provided enough detail as to what the heck is going on here. I’ve been playing with these processes for a few days and for whatever reason, it is not working. I’m hoping somebody may have some insight as to why this is.

Thanks,
Matt

If you're using stored windows credentials, you need to check the "use as windows credentials" checkbox on the data source properties page.

-Lukasz

Credentials for Data Sources - Changing Authentication

I have Visual Studio installed on my local laptop, as well as on the report server. The only place reporting services is installed is on the report server.

I have a solution called “Performance Monitoring”, and within that solution is a report of the same name. That report uses 2 data sets, “DSOne” and “DSTwo” and these data sets are pulled from 2 shared data sources. I can edit the report locally and preview it just fine and the results are what we’re looking for.

Right now, the data sources are all set to Windows authentication. We would like to tie the data sources to a specific user ID and password, so that I or anybody else is able to view the report without having to have a separate login for all those people. I have tried changing the data sources' properties in Visual Studio to reflect using a specific login/pass (my own). I have tried this in Report Manager too – editing the data sources there to use my login and pass. Both of these methods have not worked.

In Visual Studio, in the Solution Explorer, I double click on one of the data sources and go to the credentials tab. “Use Windows Authentication” is checked, so I check “use a specific user name and password” instead and then enter my login and password. When I try to preview the report, it gives me the following error and I am stumped as to why this is:

“An error has occurred during report processing. Cannot create a connection to data source “DSTwo”. Login failed for user “xxx”.”

I have also tried editing the login and password through the “edit” button on the “general” tab of whatever data source I’m working with. The “Use Windows NT Integrated Security” box is checked, so I check the “Use a Specific Name and Password” box and again, type in my login info. When I hit “Test Connection”, I get the following:

“Test connection failed because of an error in initializing provider. Login failed for user ‘xxx.”

Hopefully this provided enough detail as to what the heck is going on here. I’ve been playing with these processes for a few days and for whatever reason, it is not working. I’m hoping somebody may have some insight as to why this is.

Thanks,
Matt

If you're using stored windows credentials, you need to check the "use as windows credentials" checkbox on the data source properties page.

-Lukasz

Credentials

When running reports inside the Visual Studio IDE the datasources lose the
credentials that were previously set up.
I use the 'Use a specific user name and password'.
Any ideas?Try setting the credentials in the advanced datasource options, and
then using the "Test Connection" button on the lower left. If the
credentials aren't correct, the connection will fail, and the report
manager will not keep them in the connection string. Of course, I may
have misinterpreted your problem, in which case sorry! Hope this helps.
Lance M.
Brian Shannon wrote:
> When running reports inside the Visual Studio IDE the datasources lose the
> credentials that were previously set up.
> I use the 'Use a specific user name and password'.
> Any ideas?|||Brian,
Are you saying that the credentials aren't in Report Manager when you
deploy, or are you saying that the credentials disappear while you are
designing the report in VS?
-Josh
Lance M wrote:
> Try setting the credentials in the advanced datasource options, and
> then using the "Test Connection" button on the lower left. If the
> credentials aren't correct, the connection will fail, and the report
> manager will not keep them in the connection string. Of course, I may
> have misinterpreted your problem, in which case sorry! Hope this helps.
> Lance M.
> Brian Shannon wrote:
> > When running reports inside the Visual Studio IDE the datasources lose the
> > credentials that were previously set up.
> >
> > I use the 'Use a specific user name and password'.
> >
> > Any ideas?|||The credentials disapprear while I am designing the report in VS.
Scenerio:
I create a report. Deploy the report. All works fine. I come back a few
days later to make a change and the credentials are gone. I simply have to
add username/password back. Then all works fine again. It seems like a
random problem.
There are 3 of us using the VS solution. Could that be causing problems?
Thanks.
"Josh" <bell.joshua@.gmail.com> wrote in message
news:1155234202.244242.157330@.h48g2000cwc.googlegroups.com...
> Brian,
> Are you saying that the credentials aren't in Report Manager when you
> deploy, or are you saying that the credentials disappear while you are
> designing the report in VS?
> -Josh
>
> Lance M wrote:
>> Try setting the credentials in the advanced datasource options, and
>> then using the "Test Connection" button on the lower left. If the
>> credentials aren't correct, the connection will fail, and the report
>> manager will not keep them in the connection string. Of course, I may
>> have misinterpreted your problem, in which case sorry! Hope this helps.
>> Lance M.
>> Brian Shannon wrote:
>> > When running reports inside the Visual Studio IDE the datasources lose
>> > the
>> > credentials that were previously set up.
>> >
>> > I use the 'Use a specific user name and password'.
>> >
>> > Any ideas?
>|||Hi Brian,
I am getting the same problem. Did you find a solution?
Regards,
Robbie Berghan
rberghan@.gmail.com
"Brian Shannon" wrote:
> The credentials disapprear while I am designing the report in VS.
> Scenerio:
> I create a report. Deploy the report. All works fine. I come back a few
> days later to make a change and the credentials are gone. I simply have to
> add username/password back. Then all works fine again. It seems like a
> random problem.
> There are 3 of us using the VS solution. Could that be causing problems?
> Thanks.
> "Josh" <bell.joshua@.gmail.com> wrote in message
> news:1155234202.244242.157330@.h48g2000cwc.googlegroups.com...
> >
> > Brian,
> >
> > Are you saying that the credentials aren't in Report Manager when you
> > deploy, or are you saying that the credentials disappear while you are
> > designing the report in VS?
> >
> > -Josh
> >
> >
> > Lance M wrote:
> >> Try setting the credentials in the advanced datasource options, and
> >> then using the "Test Connection" button on the lower left. If the
> >> credentials aren't correct, the connection will fail, and the report
> >> manager will not keep them in the connection string. Of course, I may
> >> have misinterpreted your problem, in which case sorry! Hope this helps.
> >>
> >> Lance M.
> >>
> >> Brian Shannon wrote:
> >> > When running reports inside the Visual Studio IDE the datasources lose
> >> > the
> >> > credentials that were previously set up.
> >> >
> >> > I use the 'Use a specific user name and password'.
> >> >
> >> > Any ideas?
> >
>
>

Creating trigger with update

Hello

I am new to sql and asp, I am using visual web developer and have table that when it gets change I would like to see another table populated with the information. This is the two tables I have

First one has the information in it that users will insert in it

asset_id int Unchecked
asset_desc varchar(50) Checked
serial_no varchar(50) Unchecked
model_no varchar(50) Checked
category bigint Unchecked
Manufacturer varchar(50) Checked
Mac_address varchar(50) Checked
service_pack varchar(50) Checked
owner bigint Unchecked
location bigint Unchecked
date_acquired datetime Checked
date_deactivated datetime Checked
system_asset_no varchar(50) Checked
cs_desc varchar(50) Checked
vendor varchar(50) Checked
modified_date datetime Checked
action varchar(50) Checked
Unchecked

Next table is the one I want the information to go in

history_asset_id int Unchecked
history_asset_desc varchar(50) Checked
history_serial_no varchar(50) Checked
history_model_no varchar(50) Checked
history_category bigint Checked
history_manufacturer varchar(50) Checked
history_mac_address varchar(50) Checked
history_service_pack varchar(50) Checked
history_owner bigint Checked
history_location bigint Checked
history_date_acquired datetime Checked
history_date_deactivated datetime Checked
history_system_asset_no varchar(50) Checked
history_cs_desc varchar(50) Checked
history_vendor varchar(50) Checked
[modified date] datetime Checked
action varchar(50) Checked
Unchecked

the column action is for the name of person updating and modified date is the system date. My trigger is this

Create TRIGGER Trigger4
ON dbo.t_asset
FOR INSERT /* INSERT, UPDATE, DELETE */
AS
INSERT INTO history_asset_id
(history_asset_id, history_asset_desc, history_asset_orderno, history_asset_invoiceno, history_asset_yellowno, history_asset_serial_number,history_asset_cost, history_asset_fedpart, history_date_acquired, history_asset_cond, history_cat_id, history_bld_id, history_loc_name,history_date_deactivated, history_asset_dispvalue, action, modified_date)
VALUES ('@.asset_id','@.asset_desc','@.asset_orderno','@.asset_invoiceno','@.asset_yellowno','@.asset_serial_number','@.asset_cost','@.asset_fedpart','@.date_acquired','@.asset_cond','@.cat_id','@.bld_id','@.loc_name','@.date_deactivated','@.asset_dispvalue','@.action','@.sysdate')

Can anyone please help me or point me in the right direction, rbynum@.kansascommerce.com

Hi,

perhaps you first shoud read some concepts about triggers before implementing them.

Don′t wanna be a whippersnapper :-), this is a serious suggestion, most people (or even many) implemented triggers without having a basic understanding of them, like this, that triggers are fired on statement level rather than on a row level. So this can turn out to a real problem as data can be left in an inconsistent state if you don't care about that issue.

YOu will need the information and the understanding that information about the deleted / updated / inserted data is stored in virtual tables which are accessible at the following stages:

INSERT operation: INSERTED
UPDATE operation: INSERTED, DELETED
DELETE operation: DELETED

So in your case that would be something like:

INSERT INTO history_asset_id
(history_asset_id, history_asset_desc, history_asset_orderno, history_asset_invoiceno, history_asset_yellowno, history_asset_serial_number,history_asset_cost, history_asset_fedpart, history_date_acquired, history_asset_cond, history_cat_id, history_bld_id, history_loc_name,history_date_deactivated, history_asset_dispvalue, action, modified_date)
Select <columnlisthere>
FOM INSERTED

If you have any further question, don't hesitate to come back.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

You need to reference the inserted/updated/deleted rows inside the trigger code using the inserted/deleted virtual tables. See the Books Online topic on CREATE TRIGGER for more details. For the insert trigger above, you need to reference the inserted table like:

Create TRIGGER Trigger4
ON dbo.t_asset
FOR INSERT /* INSERT, UPDATE, DELETE */
AS
INSERT INTO history_asset_id
(history_asset_id, history_asset_desc, history_asset_orderno, history_asset_invoiceno, history_asset_yellowno, history_asset_serial_number,history_asset_cost, history_asset_fedpart, history_date_acquired, history_asset_cond, history_cat_id, history_bld_id, history_loc_name,history_date_deactivated, history_asset_dispvalue, action, modified_date)
select asset_id, asset_desc....

from inserted

sql

Creating SQL Server Databases With No Security Restrictions

First, let me apologize for crossposting and the lengthy post, but this
question involved both MSDE and (I believe) security settings.
We use Visual Studio .NET 2003 with MSDE in classrooms and labs and have
had no security issues once things were configured properly for student
access. The sample databases install and work correctly for any authorized
users who might be logged on to a given PC.
We are using a text that supplies .mdf files as part of the support
materials for the book. We are able to copy the .mdf files to the
appropriate directory (..\Microsoft SQL Server\MSSQL$InstanceName\Data),
then use Server Explorer in VS .NET to create a database link to the file
(Connect To Database button on the Server Explorer toolbar). Once VS .NET is
restarted, the database appears in the list of databases under the SQL
Server instance and is fully accessible.
I now want to create additional SQL Server databases for students to use
with development projects, etc. I have access to the SQL Server GUI
management tools (from our MSDNAA subscription) and they are installed and
working with the MSDE instance on my office PC. When I create a
database/tables/etc. on my instance, then attempt to copy the .mdf to
another PC to use the setup technique described above, a window pops up
wanting me to select a security option and then refuses me access to the new
database regardless of the option (NT Security or database
username/password) I try to choose.
After all that, what I'm seeking is the way to create a database to export
to any PC, with any student or faculty member logged on so that they can
import the .mdf file and connect to it using Server Explorer *without*
encountering security issues. So, when I'm creating a database, what
settings do I apply so that it doesn't care who is interacting with it?
Thanks in advance for reading and any insights!
hi Peter,
Peter van der Goes wrote:
> First, let me apologize for crossposting and the lengthy post, but
> this question involved both MSDE and (I believe) security settings.
> We use Visual Studio .NET 2003 with MSDE in classrooms and labs and
> have had no security issues once things were configured properly for
> student access. The sample databases install and work correctly for
> any authorized users who might be logged on to a given PC.
> We are using a text that supplies .mdf files as part of the support
> materials for the book. We are able to copy the .mdf files to the
> appropriate directory (..\Microsoft SQL
> Server\MSSQL$InstanceName\Data), then use Server Explorer in VS .NET
> to create a database link to the file (Connect To Database button on
> the Server Explorer toolbar). Once VS .NET is restarted, the database
> appears in the list of databases under the SQL Server instance and is
> fully accessible.
> I now want to create additional SQL Server databases for students to
> use with development projects, etc. I have access to the SQL Server
> GUI management tools (from our MSDNAA subscription) and they are
> installed and working with the MSDE instance on my office PC. When I
> create a database/tables/etc. on my instance, then attempt to copy
> the .mdf to another PC to use the setup technique described above, a
> window pops up wanting me to select a security option and then
> refuses me access to the new database regardless of the option (NT
> Security or database username/password) I try to choose.
> After all that, what I'm seeking is the way to create a database to
> export to any PC, with any student or faculty member logged on so
> that they can import the .mdf file and connect to it using Server
> Explorer *without* encountering security issues. So, when I'm
> creating a database, what settings do I apply so that it doesn't care
> who is interacting with it?
> Thanks in advance for reading and any insights!
in order to attach an existing db file, as long as create a brand new
database, the logged user must be member of the sysadmin and/or dbcreator
server role...
in order to connect to an MSDE instance you have to provide a login
information, both for Windows NT (trusted) authenticated or SQL Server
authenticated connections, as you provide this kind of information in the
Data Link dialog to (Connect To Database button on the Server Explorer
toolbar)... so there's no difference in the behaviour you are
experimenting..
what kind of error do you get when accessing the attached database?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:36sc8vF556sgkU1@.individual.net...
> hi Peter,
> in order to attach an existing db file, as long as create a brand new
> database, the logged user must be member of the sysadmin and/or dbcreator
> server role...
> in order to connect to an MSDE instance you have to provide a login
> information, both for Windows NT (trusted) authenticated or SQL Server
> authenticated connections, as you provide this kind of information in the
> Data Link dialog to (Connect To Database button on the Server Explorer
> toolbar)... so there's no difference in the behaviour you are
> experimenting..
> what kind of error do you get when accessing the attached database?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Thanks for responding, Andrea.
The issue is not permissions assigned to a given user (all users must log on
to any campus PC, thus providing username/password information), but the
difference between a .mdf file I create vs. those supplied by the publisher
of the textbook.
When we work with the .mdf files supplied by the publisher, there is no
issue with requested authentication information. Any user who can log onto a
campus PC can copy the .mdf file to the correct location on that PC, follow
the procedures I outlined in my original post using Visual Studio .NET 2003
Server Explorer and "create" an accessible database using the file in
question, then access it and its objects in Server Explorer at will. Some
setting in that .mdf file is allowing this behavior for any user. This
database can be "opened" by anybody who logs onto that PC and uses Server
Explorer.
When I create a database (.mdf) file using SQL Server Enterprise Manager and
try to "create" a database from it on a different PC, the process appears to
work. When I subsequently attempt to open that database in Server Explorer
(by clicking on the + next to the newly-created database name), I get a
dialog box insisting that I supply either NT Security information or, select
SQL Server access and provide a username/password for the database. Any
combination of username/password information I supply at that stage is
rejected by the dialog. When I open a database supplied by the publisher, no
such dialog appears and I have full access. My goal is to create databases
which behave like those supplied by the publisher.
As the security issue does not occur when using the .mdf files provided by
the publisher, I can only assume that these files were from databases set up
as accessible to all. As I'm not smart on SQL Server administration
(everything I "know" comes from SQL Server 2000 Programming, Step by Step
from MS Press), I'm hoping that somebody will guide me to the correct
settings for a SQL Server database so it's openly accessible to any user who
logs onto a PC where the database resides without triggering any
authentication dialogs. For what it's worth, I can replicate all the
behaviors above on my home PC which just uses a simple default logon.
I can send you (or, anybody else) one of the publisher's .mdf files if it
would help identify the settings in question.
|||On Tue, 8 Feb 2005 12:50:40 -0600, Peter van der Goes wrote:

> When I create a database (.mdf) file using SQL Server Enterprise Manager and
> try to "create" a database from it on a different PC, the process appears to
> work. When I subsequently attempt to open that database in Server Explorer
> (by clicking on the + next to the newly-created database name), I get a
> dialog box insisting that I supply either NT Security information or, select
> SQL Server access and provide a username/password for the database. Any
> combination of username/password information I supply at that stage is
> rejected by the dialog. When I open a database supplied by the publisher, no
> such dialog appears and I have full access. My goal is to create databases
> which behave like those supplied by the publisher.
Perhaps this would do the trick:
EXECUTE sp_grantdbaccess guest
EXECUTE sp_addrolemember 'db_owner',guest
Sorry, but I couldn't find an equivalent to this in Enterprise Manager, so
execute it from Query Analyzer.
|||"Ross Presser" <rpresser@.imtek.com> wrote in message
news:uauu8880rpzp$.dlg@.rpresser.invalid...
> On Tue, 8 Feb 2005 12:50:40 -0600, Peter van der Goes wrote:
> Perhaps this would do the trick:
> EXECUTE sp_grantdbaccess guest
> EXECUTE sp_addrolemember 'db_owner',guest
> Sorry, but I couldn't find an equivalent to this in Enterprise Manager, so
> execute it from Query Analyzer.
Unfortunately, the commands didn't alter the situation. However, through
additional experimentation, I've discovered the following:
The database itself is OK, as I can access it in Enterprise Manager. In
Server Explorer, the database appears, but its State property says
"Disconnected" and I get the SQL Server authentication dialog when Server
Explorer attempts to connect. I've checked the database file's network
security properties, and they appear to be set the same as those for the
database files (from the book) that I am able to access in Server Explorer.
Public has full access. I'm beginning to think I'm dealing with a NTFS file
or folder access issue, as the same database is fully accessible through
Server Explorer on a PC with a FAT32 partition?!?

Creating SQL Server Databases With No Security Restrictions

First, let me apologize for crossposting and the lengthy post, but this
question involved both MSDE and (I believe) security settings.
We use Visual Studio .NET 2003 with MSDE in classrooms and labs and have
had no security issues once things were configured properly for student
access. The sample databases install and work correctly for any authorized
users who might be logged on to a given PC.
We are using a text that supplies .mdf files as part of the support
materials for the book. We are able to copy the .mdf files to the
appropriate directory (..\Microsoft SQL Server\MSSQL$InstanceName\Data),
then use Server Explorer in VS .NET to create a database link to the file
(Connect To Database button on the Server Explorer toolbar). Once VS .NET is
restarted, the database appears in the list of databases under the SQL
Server instance and is fully accessible.
I now want to create additional SQL Server databases for students to use
with development projects, etc. I have access to the SQL Server GUI
management tools (from our MSDNAA subscription) and they are installed and
working with the MSDE instance on my office PC. When I create a
database/tables/etc. on my instance, then attempt to copy the .mdf to
another PC to use the setup technique described above, a window pops up
wanting me to select a security option and then refuses me access to the new
database regardless of the option (NT Security or database
username/password) I try to choose.
After all that, what I'm seeking is the way to create a database to export
to any PC, with any student or faculty member logged on so that they can
import the .mdf file and connect to it using Server Explorer *without*
encountering security issues. So, when I'm creating a database, what
settings do I apply so that it doesn't care who is interacting with it?
Thanks in advance for reading and any insights!hi Peter,
Peter van der Goes wrote:
> First, let me apologize for crossposting and the lengthy post, but
> this question involved both MSDE and (I believe) security settings.
> We use Visual Studio .NET 2003 with MSDE in classrooms and labs and
> have had no security issues once things were configured properly for
> student access. The sample databases install and work correctly for
> any authorized users who might be logged on to a given PC.
> We are using a text that supplies .mdf files as part of the support
> materials for the book. We are able to copy the .mdf files to the
> appropriate directory (..\Microsoft SQL
> Server\MSSQL$InstanceName\Data), then use Server Explorer in VS .NET
> to create a database link to the file (Connect To Database button on
> the Server Explorer toolbar). Once VS .NET is restarted, the database
> appears in the list of databases under the SQL Server instance and is
> fully accessible.
> I now want to create additional SQL Server databases for students to
> use with development projects, etc. I have access to the SQL Server
> GUI management tools (from our MSDNAA subscription) and they are
> installed and working with the MSDE instance on my office PC. When I
> create a database/tables/etc. on my instance, then attempt to copy
> the .mdf to another PC to use the setup technique described above, a
> window pops up wanting me to select a security option and then
> refuses me access to the new database regardless of the option (NT
> Security or database username/password) I try to choose.
> After all that, what I'm seeking is the way to create a database to
> export to any PC, with any student or faculty member logged on so
> that they can import the .mdf file and connect to it using Server
> Explorer *without* encountering security issues. So, when I'm
> creating a database, what settings do I apply so that it doesn't care
> who is interacting with it?
> Thanks in advance for reading and any insights!
in order to attach an existing db file, as long as create a brand new
database, the logged user must be member of the sysadmin and/or dbcreator
server role...
in order to connect to an MSDE instance you have to provide a login
information, both for Windows NT (trusted) authenticated or SQL Server
authenticated connections, as you provide this kind of information in the
Data Link dialog to (Connect To Database button on the Server Explorer
toolbar)... so there's no difference in the behaviour you are
experimenting..
what kind of error do you get when accessing the attached database?
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:36sc8vF556sgkU1@.individual.net...
> hi Peter,
> in order to attach an existing db file, as long as create a brand new
> database, the logged user must be member of the sysadmin and/or dbcreator
> server role...
> in order to connect to an MSDE instance you have to provide a login
> information, both for Windows NT (trusted) authenticated or SQL Server
> authenticated connections, as you provide this kind of information in the
> Data Link dialog to (Connect To Database button on the Server Explorer
> toolbar)... so there's no difference in the behaviour you are
> experimenting..
> what kind of error do you get when accessing the attached database?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Thanks for responding, Andrea.
The issue is not permissions assigned to a given user (all users must log on
to any campus PC, thus providing username/password information), but the
difference between a .mdf file I create vs. those supplied by the publisher
of the textbook.
When we work with the .mdf files supplied by the publisher, there is no
issue with requested authentication information. Any user who can log onto a
campus PC can copy the .mdf file to the correct location on that PC, follow
the procedures I outlined in my original post using Visual Studio .NET 2003
Server Explorer and "create" an accessible database using the file in
question, then access it and its objects in Server Explorer at will. Some
setting in that .mdf file is allowing this behavior for any user. This
database can be "opened" by anybody who logs onto that PC and uses Server
Explorer.
When I create a database (.mdf) file using SQL Server Enterprise Manager and
try to "create" a database from it on a different PC, the process appears to
work. When I subsequently attempt to open that database in Server Explorer
(by clicking on the + next to the newly-created database name), I get a
dialog box insisting that I supply either NT Security information or, select
SQL Server access and provide a username/password for the database. Any
combination of username/password information I supply at that stage is
rejected by the dialog. When I open a database supplied by the publisher, no
such dialog appears and I have full access. My goal is to create databases
which behave like those supplied by the publisher.
As the security issue does not occur when using the .mdf files provided by
the publisher, I can only assume that these files were from databases set up
as accessible to all. As I'm not smart on SQL Server administration
(everything I "know" comes from SQL Server 2000 Programming, Step by Step
from MS Press), I'm hoping that somebody will guide me to the correct
settings for a SQL Server database so it's openly accessible to any user who
logs onto a PC where the database resides without triggering any
authentication dialogs. For what it's worth, I can replicate all the
behaviors above on my home PC which just uses a simple default logon.
I can send you (or, anybody else) one of the publisher's .mdf files if it
would help identify the settings in question.|||On Tue, 8 Feb 2005 12:50:40 -0600, Peter van der Goes wrote:

> When I create a database (.mdf) file using SQL Server Enterprise Manager a
nd
> try to "create" a database from it on a different PC, the process appears
to
> work. When I subsequently attempt to open that database in Server Explorer
> (by clicking on the + next to the newly-created database name), I get a
> dialog box insisting that I supply either NT Security information or, sele
ct
> SQL Server access and provide a username/password for the database. Any
> combination of username/password information I supply at that stage is
> rejected by the dialog. When I open a database supplied by the publisher,
no
> such dialog appears and I have full access. My goal is to create databases
> which behave like those supplied by the publisher.
Perhaps this would do the trick:
EXECUTE sp_grantdbaccess guest
EXECUTE sp_addrolemember 'db_owner',guest
Sorry, but I couldn't find an equivalent to this in Enterprise Manager, so
execute it from Query Analyzer.|||"Ross Presser" <rpresser@.imtek.com> wrote in message
news:uauu8880rpzp$.dlg@.rpresser.invalid...
> On Tue, 8 Feb 2005 12:50:40 -0600, Peter van der Goes wrote:
> Perhaps this would do the trick:
> EXECUTE sp_grantdbaccess guest
> EXECUTE sp_addrolemember 'db_owner',guest
> Sorry, but I couldn't find an equivalent to this in Enterprise Manager, so
> execute it from Query Analyzer.
Unfortunately, the commands didn't alter the situation. However, through
additional experimentation, I've discovered the following:
The database itself is OK, as I can access it in Enterprise Manager. In
Server Explorer, the database appears, but its State property says
"Disconnected" and I get the SQL Server authentication dialog when Server
Explorer attempts to connect. I've checked the database file's network
security properties, and they appear to be set the same as those for the
database files (from the book) that I am able to access in Server Explorer.
Public has full access. I'm beginning to think I'm dealing with a NTFS file
or folder access issue, as the same database is fully accessible through
Server Explorer on a PC with a FAT32 partition?!?

Creating Sql Server 2005 Express Databases via VS2005 Std.

Hello all,

I use Visual Studio 2005 Standard. I would like to know the best way that I can create Sql Server 2005 Express databases visually since VS2005 Std. does not allow me to do it.

Any help is appreciated and thanks in advance,

I'd be interested in knowing how VS doesn't allow you to create a database. What error are you getting?

There are two ways to create databases, depending on your goal:

To just create a database on your server, do the following:

Creating Sql Server 2005 Express Databases via VS2005 Std.

Hello all,

I use Visual Studio 2005 Standard. I would like to know the best way that I can create Sql Server 2005 Express databases visually since VS2005 Std. does not allow me to do it.

Any help is appreciated and thanks in advance,

I'd be interested in knowing how VS doesn't allow you to create a database. What error are you getting?

There are two ways to create databases, depending on your goal:

To just create a database on your server, do the following:

Creating SQL Data base

Hi,
I want to create SQL Data and default user base using Visual Basic. any body help me to create it
thanks for your advise
byeif you have a script file
you can use shell command or winexec api, e.g.

winexec("osql.exe -S -usa -p -iscriptfile", SW_HIDE)

about osql' parameters, to see sql server online help|||You can execute script string in ADODB.Command object.|||The simplest way is:

Dim cn As ADODB.Connection

Set cn = New ADODB.Connection
cn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=myserver"
cn.Execute "create database test"
cn.Close
Set cn = Nothing

You can get more fancy with this. If you will use this more than once I would recommend creating a stored procedure that you would execute. This can also be used if you need to pass parameters like database name, location, size ...

If you are using vb.net take a look at the following ms article:

article (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q305079&ID=kb;en-us;Q305079&SD=MSDN)

Creating RS 2005 with Visual Studio 2003

Hi All,

My company is condidering upgrading to SQL Server 2005 and/or Visual Studio 2005. We may decide we want to upgrade one without upgrading the other. My concern is the Reporting Services compatibility.

My understanding is that if we decide to upgrade to Visual Studio 2005, we would have to upgrade to Reporting Services 2005 because VS 2005 cannot create reports that are compatible with RS 2000. But if we decide we want to upgrade to RS 2005, we can continue to create the reports in VS 2003 because RS 2005 supports RS 2000 rdl files.

Is this correct?

Thanks!

Yes, you are wright.

But you cannot use the new feature from RS2005 (see http://www.sqlservercentral.com/columnists/kAli/microsoftreportingservices2005featuresandenhanceme.asp )

|||

SQL Server 2000 Report Designer requires Visual Studio 2003. It does not run in Visual Studio 2005.

Note: reports designed with the RS 2000 report designer / VS 2003 can be directly published to a RS 2005 report server (they will be auto-upgraded on publishing on the server).

SQL Server 2005 uses Visual Studio 2005. If you do not have Visual Studio 2005 installed, Setup will install the version of the Visual Studio shell that is necessary for running Report Designer. You cannot use SQL Server 2005 Report Designer to publish reports to a SQL Server 2000 report server.

-- Robert

|||

Thank you both for your answers!

So basically, we'd be ok upgrading to SQL Server 2005 and staying with VS 2003, but can't upgrade to VS 2005 without upgrading SQL Server - unless we want to run VS 2003 AND VS 2005.

|||Correct.

Creating Reports on SQL Server 2005 Mobile Edition

I am looking for a reporting software to create reports (Invoices, Receipts) for PocketPC 2003 using Visual Studio 2005 and SQL Server 2005 Mobile Edition.
Any recommendations will be appreciated.

Thanks, Alla

At present SQL Server 2005 Mobile Edition doesnt have integration with SQL Reporting services or Crystal reports. You may need to author your own report and query SQL Mobile database for data.|||

In our development, we do it "by hands" and send to printer via a third party "PrinterCE".

HTH, Fabien.

Creating Reports on SQL Server 2005 Mobile Edition

I am looking for a reporting software to create reports (Invoices, Receipts) for PocketPC 2003 using Visual Studio 2005 and SQL Server 2005 Mobile Edition.
Any recommendations will be appreciated.

Thanks, Alla

At present SQL Server 2005 Mobile Edition doesnt have integration with SQL Reporting services or Crystal reports. You may need to author your own report and query SQL Mobile database for data.|||

In our development, we do it "by hands" and send to printer via a third party "PrinterCE".

HTH, Fabien.

Creating Reports at Runtime

Is it possible to create a report programmatically at runtime using Visual Studio 2005 based upon say a report layout specification file?There is a nifty tutorial on this I found.|||

Can you direct me to that tutorial please? It might help me in my situation.

Thanks!

|||

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

It's beautiful!

|||

Hi,

Can you give link for example report preview by RDL-file ?

|||

proki wrote:

Hi,

Can you give link for example report preview by RDL-file ?

You can create any report preview that you would normally create using a report server project. I'm not sure what type of link you are wanting. RDL generator offers full flexibility for creating reports. It's just a different way to go about creating the report. The same reports can be created by using either the RDL generator method or the report server project.

There's nothing new and magical looking if that's what you're asking.

Creating Reports at Runtime

Is it possible to create a report programmatically at runtime using Visual Studio 2005 based upon say a report layout specification file?There is a nifty tutorial on this I found.|||

Can you direct me to that tutorial please? It might help me in my situation.

Thanks!

|||

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

It's beautiful!

|||

Hi,

Can you give link for example report preview by RDL-file ?

|||

proki wrote:

Hi,

Can you give link for example report preview by RDL-file ?

You can create any report preview that you would normally create using a report server project. I'm not sure what type of link you are wanting. RDL generator offers full flexibility for creating reports. It's just a different way to go about creating the report. The same reports can be created by using either the RDL generator method or the report server project.

There's nothing new and magical looking if that's what you're asking.

Creating Reports

What needs to be installed on a workstation in order to be able to create
reports for reporting services?
I have Visual Studio .NET installed, and having installed the reporting
services client noticed it had appeared as an option in VS.
A colleague installed the reporting services client who didn't have Visual
Studio .NET and doesn't seem to have the ability to create a report.You need VS. I've read here about other software to generate the RDL,
but VS makes it much nicer.

Creating Report using Visual Web Developer 2005 Express with SQL 2005 Reporting Services A

Hi

I am wanting to learn how to create a Report using SQL 2005 Reporting Services, I use Visual Web Developer 2005 Express and have installed the Reporting Services Add-In for Visual Web Developer 2005 Express.

Does anyone here know of any good step-by-step tutorials on how to get started creating the reports. As I want something to go through how to create the datasource right through to creating / formating the report ready for use.

Matthew

This links might help you:

http://technoblab.blogspot.com
http://www.databasejournal.com
http://www.codeproject.com/aspnet/ReportViewer.asp

Creating RDL Files - Software Requirements

I have a copy of SQL Server Express running, but am not sure how to create
reports. Does this require a full/regular copy of Visual Studio or is there
an 'express' (read:free) solution to create reports.
Thanks,
MatthewThere is another version called SQL Server 2005 Express Edition with
Advanced Services SP1 which comes with everything you need to develop
reports. Note that the data for your reports need to be local (in your SQL
Server Express database is what I believe that means).
Download here: http://msdn.microsoft.com/vstudio/express/sql/download/
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"matthew gibson" <matthewgibson@.discussions.microsoft.com> wrote in message
news:9D74D31A-EFB3-492F-8D23-C2D9B51CEADD@.microsoft.com...
>I have a copy of SQL Server Express running, but am not sure how to create
> reports. Does this require a full/regular copy of Visual Studio or is
> there
> an 'express' (read:free) solution to create reports.
> Thanks,
> Matthew|||yes, I think. I have that. Here is a select @.@.version to clarify...
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.2 (Build 3790:
Service Pack 1)
I have seen references to Business Intelligence Designer. I have the
virtual directory for reports. I can go out to it and there is an option to
upload RDL files; however, I am not sure what tool is necessary to create RDL
files. I know Visual Studio (for pay ones) can do it, but I don't know if
there is a free version. I don't see anything in the SQL MGMT tool or in the
Start Menu which allow me to create reports. I do see the Report SErver
configuration tool... and it shows it to be setup correctly.
Thanks!
Matthew
"Bruce L-C [MVP]" wrote:
> There is another version called SQL Server 2005 Express Edition with
> Advanced Services SP1 which comes with everything you need to develop
> reports. Note that the data for your reports need to be local (in your SQL
> Server Express database is what I believe that means).
> Download here: http://msdn.microsoft.com/vstudio/express/sql/download/
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "matthew gibson" <matthewgibson@.discussions.microsoft.com> wrote in message
> news:9D74D31A-EFB3-492F-8D23-C2D9B51CEADD@.microsoft.com...
> >I have a copy of SQL Server Express running, but am not sure how to create
> > reports. Does this require a full/regular copy of Visual Studio or is
> > there
> > an 'express' (read:free) solution to create reports.
> > Thanks,
> > Matthew
>
>|||I don't know about the setup but it shouldn't be any difference. You need to
install the Business Intelligence tools. It will install a version of VS to
host the report designer. Run setup and see about a choice to install. Once
installed you should be have something in your program files called SQL
Server Business Intelligence Development Studio.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"matthew gibson" <matthewgibson@.discussions.microsoft.com> wrote in message
news:81305E18-ABEF-449E-AA63-76CEF9583387@.microsoft.com...
> yes, I think. I have that. Here is a select @.@.version to clarify...
> Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
> Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation
> Express Edition with Advanced Services on Windows NT 5.2 (Build 3790:
> Service Pack 1)
> I have seen references to Business Intelligence Designer. I have the
> virtual directory for reports. I can go out to it and there is an option
> to
> upload RDL files; however, I am not sure what tool is necessary to create
> RDL
> files. I know Visual Studio (for pay ones) can do it, but I don't know if
> there is a free version. I don't see anything in the SQL MGMT tool or in
> the
> Start Menu which allow me to create reports. I do see the Report SErver
> configuration tool... and it shows it to be setup correctly.
> Thanks!
> Matthew
>
> "Bruce L-C [MVP]" wrote:
>> There is another version called SQL Server 2005 Express Edition with
>> Advanced Services SP1 which comes with everything you need to develop
>> reports. Note that the data for your reports need to be local (in your
>> SQL
>> Server Express database is what I believe that means).
>> Download here: http://msdn.microsoft.com/vstudio/express/sql/download/
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "matthew gibson" <matthewgibson@.discussions.microsoft.com> wrote in
>> message
>> news:9D74D31A-EFB3-492F-8D23-C2D9B51CEADD@.microsoft.com...
>> >I have a copy of SQL Server Express running, but am not sure how to
>> >create
>> > reports. Does this require a full/regular copy of Visual Studio or is
>> > there
>> > an 'express' (read:free) solution to create reports.
>> > Thanks,
>> > Matthew
>>

Creating indexes on tables from the Database Explorer

I would like to create an index on a table from the Database Explorer.

I am using Microsoft Visual C# 2005 Express Edition.

I downloaded Microsoft SQL Server Management Studio Express with the intention of using it to create an index, but it does not seem to find the database that I created from the Database Explorer.

Thanks!

Are you sure you're looking at the right server and connection? Can you post a screenshot of the two environments?

Creating indexes on tables from the Database Explorer

I would like to create an index on a table from the Database Explorer.

I am using Microsoft Visual C# 2005 Express Edition.

I downloaded Microsoft SQL Server Management Studio Express with the intention of using it to create an index, but it does not seem to find the database that I created from the Database Explorer.

Thanks!

Are you sure you're looking at the right server and connection? Can you post a screenshot of the two environments?

Creating custom controls

Hi all,
Using SQL Server 2000, Visual Studio .NET and the Report Project Wizard I've
nearly been able to create the kind of reports I like.
What I'd like to do now is to create a custom control and have it appear on
the Report Items toolbox along with the other report controls (Textbox,
Line, Table, Matrix etc.). I've tried creating an empty class:
using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Windows.Forms;
using Microsoft.ReportDesigner;
using Microsoft.VisualStudio;
using Microsoft.ReportDesigner.Controls;
using Microsoft.ReportDesigner.Drawing;
using Microsoft.ReportDesigner.Serialization;
using System.Collections.Specialized;
using System.Xml.Serialization;
using Microsoft.ReportDesigner.Interop;
namespace ReportControl
{
public sealed class MyReportControl :
Microsoft.ReportDesigner.Controls.ReportControl
{
}
}
But when I build this as a dll and try and add it into the Report Items
toolbox I get the following error "File or assembly name
Microsoft.DataWarehouse, or one of its dependencies, was not found." I've
had a good look around on Google for any information on this error or
information on how to create a custom control for sql reporting services
without finding any. Could anybody please tell me if it is possible to
create custom controls for SQL 2000 reporting services? If so, is there any
information I can read on it?
I've read on:
http://msdn.microsoft.com/SQL/2005/2005Webcasts/ReportingServicesQandA.aspx
that:
"Sachin Asked: Can Reporting services be used to pull up reports from a C#
Windows Forms application?
Answered: Yes, this will be easily possible using the new Reporting Services
Winforms control which will ship in Visual Studio 2005."
Does this mean that I'll be able to use my own custom-created
System.Windows.Forms.Control within this new Reporting Services Winforms
control?
Many thanks for any head-ups on any of these questions,
Best Regards,
Christopher Ireland> "Sachin Asked: Can Reporting services be used to pull up reports from a C#
> Windows Forms application?
> Answered: Yes, this will be easily possible using the new Reporting
> Services
> Winforms control which will ship in Visual Studio 2005."
> Does this mean that I'll be able to use my own custom-created
> System.Windows.Forms.Control within this new Reporting Services Winforms
> control?
No. The Winforms control can only be used to process and render existing
reports.
However, RS 2005 will add a so-called CustomReportItem. You can write
controls that implement certain interfaces and can then plug into report
designer and into report processing.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Ireland" <cireland@.gmail.com> wrote in message
news:e7oxVjOQFHA.1500@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> Using SQL Server 2000, Visual Studio .NET and the Report Project Wizard
> I've
> nearly been able to create the kind of reports I like.
> What I'd like to do now is to create a custom control and have it appear
> on
> the Report Items toolbox along with the other report controls (Textbox,
> Line, Table, Matrix etc.). I've tried creating an empty class:
> using System;
> using System.Collections;
> using System.ComponentModel;
> using System.Drawing;
> using System.Data;
> using System.Windows.Forms;
> using Microsoft.ReportDesigner;
> using Microsoft.VisualStudio;
> using Microsoft.ReportDesigner.Controls;
> using Microsoft.ReportDesigner.Drawing;
> using Microsoft.ReportDesigner.Serialization;
> using System.Collections.Specialized;
> using System.Xml.Serialization;
> using Microsoft.ReportDesigner.Interop;
> namespace ReportControl
> {
> public sealed class MyReportControl :
> Microsoft.ReportDesigner.Controls.ReportControl
> {
> }
> }
> But when I build this as a dll and try and add it into the Report Items
> toolbox I get the following error "File or assembly name
> Microsoft.DataWarehouse, or one of its dependencies, was not found." I've
> had a good look around on Google for any information on this error or
> information on how to create a custom control for sql reporting services
> without finding any. Could anybody please tell me if it is possible to
> create custom controls for SQL 2000 reporting services? If so, is there
> any
> information I can read on it?
> I've read on:
> http://msdn.microsoft.com/SQL/2005/2005Webcasts/ReportingServicesQandA.aspx
> that:
> "Sachin Asked: Can Reporting services be used to pull up reports from a C#
> Windows Forms application?
> Answered: Yes, this will be easily possible using the new Reporting
> Services
> Winforms control which will ship in Visual Studio 2005."
> Does this mean that I'll be able to use my own custom-created
> System.Windows.Forms.Control within this new Reporting Services Winforms
> control?
> Many thanks for any head-ups on any of these questions,
> Best Regards,
> Christopher Ireland
>|||"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:#Jh53L7QFHA.4028@.tk2msftngp13.phx.gbl...
> > "Sachin Asked: Can Reporting services be used to pull up reports from a
C#
> > Windows Forms application?
> > Answered: Yes, this will be easily possible using the new Reporting
> > Services
> > Winforms control which will ship in Visual Studio 2005."
> >
> > Does this mean that I'll be able to use my own custom-created
> > System.Windows.Forms.Control within this new Reporting Services Winforms
> > control?
> No. The Winforms control can only be used to process and render existing
> reports.
> However, RS 2005 will add a so-called CustomReportItem. You can write
> controls that implement certain interfaces and can then plug into report
> designer and into report processing.
Excellent. Thank you very much Robert, I'll look into it.
Best Regards,
Christopher Ireland.|||"Christopher Ireland" <cireland@.gmail.com> wrote in message
news:e8x6rO#QFHA.2384@.tk2msftngp13.phx.gbl...
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:#Jh53L7QFHA.4028@.tk2msftngp13.phx.gbl...
> > However, RS 2005 will add a so-called CustomReportItem. You can write
> > controls that implement certain interfaces and can then plug into report
> > designer and into report processing.
> Excellent. Thank you very much Robert, I'll look into it.
Hi Robert,
It seems that when using the VS2005 Beta 2 (April 2005) along with the SQL
Server 2005 CTP (April 2005), CustomReportItem is sealed although there is a
ICustomReportItem interface.
I don't suppose you know where I could get an example of how to author a
custom control for SQL Server 2005 CTP (April 2005) ReportingServices using
VS2005 Beta 2 (April 2005), something along the lines of the SimpleControl
Sample for Windows Forms control?
Many thanks,
Chris.|||Well, since I worked on the design and the implementation, I certainly
should know how it works :). I want to add that CustomReportItem (CRI) in RS
2005 serves one main purpose: allow the integration of additional charting
capabilities. Hence, a CustomReportItem at this point can create an image
(with image maps) or a textbox, but not yet complex RDL report items at
processing time. The new data grouping RDL structure of the CustomReportItem
will also show how we will make table or matrix more powerful in future
releases.
The ICustomReportItem interface is the way to go. We are working on making
an interesting but yet not too complex sample publicly available that shows
how to implement a CRI design-time control (for report designer) and a CRI
processing control (for report server). We hope to have the sample and
documentation ready when we release RS 2005.
In the meantime you may want to look for a session at the upcoming TechEd
2005 conference presented by Andrew Bryan (Dundas Software). He will talk
about their work using the CRI approach (derived from complex prototypes we
have built) and how to build your own CRI controls:
http://www.msteched.com/content/sessions.aspx, Session BIN335 - "SQL Server
2005 Reporting Services Custom Report Items", Thursday, June 9, 5:00 PM -
6:15 PM.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Ireland" <cireland@.gmail.com> wrote in message
news:u2zQD%23%23TFHA.616@.TK2MSFTNGP12.phx.gbl...
> "Christopher Ireland" <cireland@.gmail.com> wrote in message
> news:e8x6rO#QFHA.2384@.tk2msftngp13.phx.gbl...
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:#Jh53L7QFHA.4028@.tk2msftngp13.phx.gbl...
>> > However, RS 2005 will add a so-called CustomReportItem. You can write
>> > controls that implement certain interfaces and can then plug into
>> > report
>> > designer and into report processing.
>> Excellent. Thank you very much Robert, I'll look into it.
> Hi Robert,
> It seems that when using the VS2005 Beta 2 (April 2005) along with the SQL
> Server 2005 CTP (April 2005), CustomReportItem is sealed although there is
> a
> ICustomReportItem interface.
> I don't suppose you know where I could get an example of how to author a
> custom control for SQL Server 2005 CTP (April 2005) ReportingServices
> using
> VS2005 Beta 2 (April 2005), something along the lines of the SimpleControl
> Sample for Windows Forms control?
> Many thanks,
> Chris.
>|||"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:#r1drZAUFHA.3352@.TK2MSFTNGP12.phx.gbl...
> Well, since I worked on the design and the implementation, I certainly
> should know how it works :).
Excellent! Many thanks for taking some time out to answer mine (and others)
questions!!
> The ICustomReportItem interface is the way to go. We are working on making
> an interesting but yet not too complex sample publicly available that
shows
> how to implement a CRI design-time control (for report designer) and a CRI
> processing control (for report server). We hope to have the sample and
> documentation ready when we release RS 2005.
That would be fantastic.
In the meantime I wonder if you're up for giving me a couple of tips in the
meantime <g>. My first objective is to get my custom component on the Report
Items ToolBox, so I created a simple dummy class that looks like this:
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.ReportingServices.Interfaces;
using Microsoft.ReportingServices.ReportProcessing;
using Microsoft.ReportingServices.ReportRendering;
namespace MyReportControl
{
public class MyNonDundasChart : ReportItem
{
public MyNonDundasChart() { }
}
public class MyReportControl : ICustomReportItem
{
private CustomReportItem customItem;
public ChangeType Process()
{
return ChangeType.None;
}
public Action Action
{
get { return new Action(); }
}
public CustomReportItem CustomItem
{
set { customItem = value;}
}
public ReportItem RenderItem
{
get { return new MyNonDundasChart(); }
}
}
}
However, when I try and add MyReportControl.dll into the Report Items
ToolBox, I get the following error:
There are no components in
"C:\Test\ReportProject1\MyReportControl\bin\Debug\MyReportControl.dll" that
can be placed on the toolbox.
Any chance of giving me a couple of "preview" pointers? Please <gg>?
> In the meantime you may want to look for a session at the upcoming TechEd
> 2005 conference presented by Andrew Bryan (Dundas Software). He will talk
> about their work using the CRI approach (derived from complex prototypes
we
> have built) and how to build your own CRI controls:
> http://www.msteched.com/content/sessions.aspx, Session BIN335 - "SQL
Server
> 2005 Reporting Services Custom Report Items", Thursday, June 9, 5:00 PM -
> 6:15 PM.
Maybe I'll look into getting the DVD set which may have this session on it;
Orlando, Florida is quite a way from Girona, Catalonia :-)
Best Regards,
Chris.|||Well, writing and integrating your design time control is not that simple.
Also registering it in the VS toolbox is not trivial at this point in VS
2005 Beta 2 and requires a set of manual steps (this will hopefully change
and be simplified with VS 2005 RTM). I would recommend you wait till we have
the sample ready.
Regarding the TechEd session - it seems to be pretty popular so far (based
on the registrations). Popular sessions are more likely to be recorded and
available on the post-conference DVD set.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Ireland" <cireland@.gmail.com> wrote in message
news:%23HQGV2iUFHA.3244@.TK2MSFTNGP15.phx.gbl...
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:#r1drZAUFHA.3352@.TK2MSFTNGP12.phx.gbl...
>> Well, since I worked on the design and the implementation, I certainly
>> should know how it works :).
> Excellent! Many thanks for taking some time out to answer mine (and
> others)
> questions!!
>> The ICustomReportItem interface is the way to go. We are working on
>> making
>> an interesting but yet not too complex sample publicly available that
> shows
>> how to implement a CRI design-time control (for report designer) and a
>> CRI
>> processing control (for report server). We hope to have the sample and
>> documentation ready when we release RS 2005.
> That would be fantastic.
> In the meantime I wonder if you're up for giving me a couple of tips in
> the
> meantime <g>. My first objective is to get my custom component on the
> Report
> Items ToolBox, so I created a simple dummy class that looks like this:
> using System;
> using System.Collections.Generic;
> using System.Text;
> using Microsoft.ReportingServices.Interfaces;
> using Microsoft.ReportingServices.ReportProcessing;
> using Microsoft.ReportingServices.ReportRendering;
> namespace MyReportControl
> {
> public class MyNonDundasChart : ReportItem
> {
> public MyNonDundasChart() { }
> }
> public class MyReportControl : ICustomReportItem
> {
> private CustomReportItem customItem;
> public ChangeType Process()
> {
> return ChangeType.None;
> }
> public Action Action
> {
> get { return new Action(); }
> }
> public CustomReportItem CustomItem
> {
> set { customItem = value;}
> }
> public ReportItem RenderItem
> {
> get { return new MyNonDundasChart(); }
> }
> }
> }
>
> However, when I try and add MyReportControl.dll into the Report Items
> ToolBox, I get the following error:
> There are no components in
> "C:\Test\ReportProject1\MyReportControl\bin\Debug\MyReportControl.dll"
> that
> can be placed on the toolbox.
> Any chance of giving me a couple of "preview" pointers? Please <gg>?
>> In the meantime you may want to look for a session at the upcoming TechEd
>> 2005 conference presented by Andrew Bryan (Dundas Software). He will talk
>> about their work using the CRI approach (derived from complex prototypes
> we
>> have built) and how to build your own CRI controls:
>> http://www.msteched.com/content/sessions.aspx, Session BIN335 - "SQL
> Server
>> 2005 Reporting Services Custom Report Items", Thursday, June 9, 5:00 PM -
>> 6:15 PM.
> Maybe I'll look into getting the DVD set which may have this session on
> it;
> Orlando, Florida is quite a way from Girona, Catalonia :-)
> Best Regards,
> Chris.
>