Binding dataset to a reportviewer control

Hi,

I need to bind my custom dataset, which i retrieve by executing some query to a reportviewer control. I don't want to create a typed dataset in the application. Is there any way to do it? The dataset that i bind will be built in a seperate class. If I plan to use a Object Data source, what are the steps to follow. Pls help.

thanks,

Saravanan

www.gotreportviewer.com provides information about how to use object data sources specifically at: http://www.gotreportviewer.com/objectdatasources/index.html

-- Robert

|||

Hi Robert,

Thanks for the reply. I already read through that article. What i really need is to bind a dataset ( which i create in my application) to be bound to the report viewer. The dataset will have some columns from the database ( thro a select query), some columns may be added by me. I want to bind this custom dataset to the report viewer control (local mode processing). Please let me know if this can be done and also some steps to do it.

Thanks in advance,

Saravanan.

bind matrix or table to image or map

Hi
I want to create a report where data is fixed to certain areas on a map (eg
I have an image of Switzerland and regional data. The data should be
displayed ontop of certain regions of the map). When I deploy the report and
open it in Preview or with a browser, everything is moved: eg, if I scroll up
or down, the data moves but the map stays fix.
Is there a way to tie the dataobjects to the image so the data will always
stay ontop of the same point?
Thanks for any help,
SalvatoreYou can approximate this by placing the data regions in rectangles and
placing rectangles in specific areas you'd like.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Salvatore" <Salvatore@.discussions.microsoft.com> wrote in message
news:B2DE92AB-4D79-4E6F-AB4F-A53FEA25CC9B@.microsoft.com...
> Hi
> I want to create a report where data is fixed to certain areas on a map
(eg
> I have an image of Switzerland and regional data. The data should be
> displayed ontop of certain regions of the map). When I deploy the report
and
> open it in Preview or with a browser, everything is moved: eg, if I scroll
up
> or down, the data moves but the map stays fix.
> Is there a way to tie the dataobjects to the image so the data will always
> stay ontop of the same point?
> Thanks for any help,
> Salvatore|||Hi Ravi
I have try by placing the data regions in rectangles or placing Image in
rectangles but without success
Thanks for any help,
Salvatore
"Ravi Mumulla (Microsoft)" wrote:
> You can approximate this by placing the data regions in rectangles and
> placing rectangles in specific areas you'd like.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Salvatore" <Salvatore@.discussions.microsoft.com> wrote in message
> news:B2DE92AB-4D79-4E6F-AB4F-A53FEA25CC9B@.microsoft.com...
> > Hi
> > I want to create a report where data is fixed to certain areas on a map
> (eg
> > I have an image of Switzerland and regional data. The data should be
> > displayed ontop of certain regions of the map). When I deploy the report
> and
> > open it in Preview or with a browser, everything is moved: eg, if I scroll
> up
> > or down, the data moves but the map stays fix.
> >
> > Is there a way to tie the dataobjects to the image so the data will always
> > stay ontop of the same point?
> >
> > Thanks for any help,
> > Salvatore
>
>

Binary sort order and clustering

I am trying to create a four node cluster. One of my instances has a Binary
sort order. The SQL Server cluster install and SP4 worked. Now I am tryin
g
to add additional drives for SQL Server to use. I am able to do this for my
case insensitive instances, and those SQL Server instances can see the
drives.
On the Binary instance, once I add the drive and try to bring the instance
back online, SQL Server will not come back up. In cluster manager, the
status just says "Online Pending".
If I go to the services applet and try to start it, I get a message the the
service started and stopped. The instance will failover to another node.
The error log actually looks like SQL Server is still running, and I can see
sqlservr.exe in Task Manager. I can also connect to it using Query Analyzer
.
When I run this: "select * from ::fn_servershareddrives()", the correct
drive letters show up in the results. From Enterprise Manager, It looks lik
e
the instance is stopped. I can also navigate to the drive.
Has anyone successfully clustered a case sensitive instance? What could I
be doing wrong?Never mind. It was something besides adding the drive and nothing to do with
the collation.
"Kathi Kellenberger" wrote:

> I am trying to create a four node cluster. One of my instances has a Bina
ry
> sort order. The SQL Server cluster install and SP4 worked. Now I am try
ing
> to add additional drives for SQL Server to use. I am able to do this for
my
> case insensitive instances, and those SQL Server instances can see the
> drives.
> On the Binary instance, once I add the drive and try to bring the instance
> back online, SQL Server will not come back up. In cluster manager, the
> status just says "Online Pending".
> If I go to the services applet and try to start it, I get a message the th
e
> service started and stopped. The instance will failover to another node.
> The error log actually looks like SQL Server is still running, and I can s
ee
> sqlservr.exe in Task Manager. I can also connect to it using Query Analyz
er.
> When I run this: "select * from ::fn_servershareddrives()", the correct
> drive letters show up in the results. From Enterprise Manager, It looks l
ike
> the instance is stopped. I can also navigate to the drive.
> Has anyone successfully clustered a case sensitive instance? What could I
> be doing wrong?
>

Binary sort order and clustering

I am trying to create a four node cluster. One of my instances has a Binary
sort order. The SQL Server cluster install and SP4 worked. Now I am trying
to add additional drives for SQL Server to use. I am able to do this for my
case insensitive instances, and those SQL Server instances can see the
drives.
On the Binary instance, once I add the drive and try to bring the instance
back online, SQL Server will not come back up. In cluster manager, the
status just says "Online Pending".
If I go to the services applet and try to start it, I get a message the the
service started and stopped. The instance will failover to another node.
The error log actually looks like SQL Server is still running, and I can see
sqlservr.exe in Task Manager. I can also connect to it using Query Analyzer.
When I run this: "select * from ::fn_servershareddrives()", the correct
drive letters show up in the results. From Enterprise Manager, It looks like
the instance is stopped. I can also navigate to the drive.
Has anyone successfully clustered a case sensitive instance? What could I
be doing wrong?Never mind. It was something besides adding the drive and nothing to do with
the collation.
"Kathi Kellenberger" wrote:
> I am trying to create a four node cluster. One of my instances has a Binary
> sort order. The SQL Server cluster install and SP4 worked. Now I am trying
> to add additional drives for SQL Server to use. I am able to do this for my
> case insensitive instances, and those SQL Server instances can see the
> drives.
> On the Binary instance, once I add the drive and try to bring the instance
> back online, SQL Server will not come back up. In cluster manager, the
> status just says "Online Pending".
> If I go to the services applet and try to start it, I get a message the the
> service started and stopped. The instance will failover to another node.
> The error log actually looks like SQL Server is still running, and I can see
> sqlservr.exe in Task Manager. I can also connect to it using Query Analyzer.
> When I run this: "select * from ::fn_servershareddrives()", the correct
> drive letters show up in the results. From Enterprise Manager, It looks like
> the instance is stopped. I can also navigate to the drive.
> Has anyone successfully clustered a case sensitive instance? What could I
> be doing wrong?
>

Binary Primary Key

I have a 256 bit hash value to identify chunks of data. Would it be a good idea to create a 32-byte binary field as the primary key or encode the bytes to a string?

Well, to me if your natural key really is binary then that is the way I would designate the primary key -- as binary. I'd still like to hear other opinions, though

Binary parameters to stored procedures?

I have a stored procedure that takes a byte string as an argument:
CREATE PROCEDURE Reporting_TicketSelectGroups
@.publicPart NVARCHAR(400),
@.checkField BINARY(46),
@.langCode VARCHAR(9)
AS
...
I've created a DataSet with the name of the stored proc as as its query
string and with this expression as its parameter value for @.checkField:
=Code.CheckField(Parameters!ticket.Value)
This in turn refers to a function in the Code tab of the Report
Properties property sheet:
Public Function CheckField(ByVal aTicket As String) As Byte()
...
Return Convert.FromBase64String(...)
End Function
The idea is that there is a parameter called ticket and it is split in
to two parts, one part being in binary, and these two parts are then
used as parameters to the various queries used in the report. When I
attempt to preview this report, I get this error message:
An error has occurred during report processing.
Query execution failed for data set 'Groups'.
Implict conversion from data type nvarchar to binary is not allowed.
Use the CONVERT function to run this query.
I'm assuming the last two sentences come from SQL Server and indicate
that my byte[] value is being converted to string on the way -- either
that or I have stuffed it up in some way. Can anyone tell me whether
this approach should work, or is simply not possible to pass binary
parameters from RS?
--
Damian CugleyI wrote:
> I have a stored procedure that takes a byte string as an argument:
> [...] Can anyone tell me whether
> this approach should work, or is simply not possible to pass binary
> parameters from RS?
I gather from the deafening silence that it is possible to pass neither
binary parameters nor other formats like UUIDs.
My workaround was straightforward enough, once I had decided to do it: I
wrote a base64 (RFC 1521) codec in T-SQL so I can pass the data safely
as a character string.

binary data insert fails using dblib

who still uses the old dblib can help me?
thanks in advance:

1.create table & procedure in db:
test_table(uniqueidentifier a,varbinary50 b)
CREATE PROCEDURE insert_table
@.b_in varbinary
AS
insert into test_table(b) values (@.b_in)
GO

2.write program use dblib:
wchar_t str[120]=L"ABC";
dbrpcparam(dbproc[i], "@.b_in", (BYTE)NULL, SQLVARBINARY,
-1, 6, &str)

3.I can find the program executed successfully,but only 1 Byte is inserted:
a b
---------------
199D71BE-327A-4BC1-AEC8-ACB0C96076CA 0x41

how to insert the whole string into the database?See if you can spot the difference in the code below (tsk...the answer is there...):

declare @.i varbinary
set @.i = 0xffffffff
select @.i, datalength(@.i)
go
declare @.i varbinary(10)
set @.i = 0xffffffff
select @.i, datalength(@.i)
go|||Thanks! I have made a serious mistake *_*

big update problem!

ADDED:
I am also able to create and populate a fairly large table in a matter of
minutes however updating to this one table is costing a lot of time.
Now granted this table in question is much larger then most tables in the DB
and larger then the tables I create but not 10 times larger!
Also, this table gets a lot of activity. Could our problem be the table
itself?
"Sean" wrote:
[vbcol=seagreen]
> I have a mini .net application that I have created to make some pretty
> complex transformationsdatabase.
> All the code, .net datatables and logic etc takes 3 minutes to run on the
> entire database. However, when I put in the update statements the same
> process takes
> 3 1/2 hours!
> So I know its not becuase I am using datatables or that my select statemen
ts
> are poor etc etc etc. Its 100% the update statements.
> Any clues? is this normal? are updates statements the most expensive in time?[/vbc
ol]Yes, and it could be a hardware problem or the phase of the moon. With no
information about what the table looks like, what you are trying to do and
what else is running, there's no way to tell. This is like calling your
mechanic and saying it takes to long for me to get to work, what should I
do? The main difference between update statements and select statements is
they take update locks and write to disk. I would look at blocking waiting
to lock something that's in use first but that's just idle speculation.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:6E7394B4-A544-4111-A35B-4661DF0C459C@.microsoft.com...[vbcol=seagreen]
> ADDED:
> I am also able to create and populate a fairly large table in a matter of
> minutes however updating to this one table is costing a lot of time.
> Now granted this table in question is much larger then most tables in the
> DB
> and larger then the tables I create but not 10 times larger!
> Also, this table gets a lot of activity. Could our problem be the table
> itself?
> "Sean" wrote:
>|||Well there is currently only 3 people accessing the server and only one (me)
accessing this particular database.
by my estimations it is taking about 1-3 seconds to update a row and in this
context each row has to be updated seperately.
Having said all that I think the functionality we are gaining might not be
worth the dev time which is a subject I will have for our meeting.
"Roger Wolter[MSFT]" wrote:

> Yes, and it could be a hardware problem or the phase of the moon. With no
> information about what the table looks like, what you are trying to do and
> what else is running, there's no way to tell. This is like calling your
> mechanic and saying it takes to long for me to get to work, what should I
> do? The main difference between update statements and select statements i
s
> they take update locks and write to disk. I would look at blocking waitin
g
> to lock something that's in use first but that's just idle speculation.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Sean" <Sean@.discussions.microsoft.com> wrote in message
> news:6E7394B4-A544-4111-A35B-4661DF0C459C@.microsoft.com...
>
>|||I have a mini .net application that I have created to make some pretty
complex transformationsdatabase.
All the code, .net datatables and logic etc takes 3 minutes to run on the
entire database. However, when I put in the update statements the same
process takes
3 1/2 hours!
So I know its not becuase I am using datatables or that my select statements
are poor etc etc etc. Its 100% the update statements.
Any clues? is this normal? are updates statements the most expensive in time
?|||ADDED:
I am also able to create and populate a fairly large table in a matter of
minutes however updating to this one table is costing a lot of time.
Now granted this table in question is much larger then most tables in the DB
and larger then the tables I create but not 10 times larger!
Also, this table gets a lot of activity. Could our problem be the table
itself?
"Sean" wrote:
[vbcol=seagreen]
> I have a mini .net application that I have created to make some pretty
> complex transformationsdatabase.
> All the code, .net datatables and logic etc takes 3 minutes to run on the
> entire database. However, when I put in the update statements the same
> process takes
> 3 1/2 hours!
> So I know its not becuase I am using datatables or that my select statemen
ts
> are poor etc etc etc. Its 100% the update statements.
> Any clues? is this normal? are updates statements the most expensive in time?[/vbc
ol]|||Yes, and it could be a hardware problem or the phase of the moon. With no
information about what the table looks like, what you are trying to do and
what else is running, there's no way to tell. This is like calling your
mechanic and saying it takes to long for me to get to work, what should I
do? The main difference between update statements and select statements is
they take update locks and write to disk. I would look at blocking waiting
to lock something that's in use first but that's just idle speculation.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:6E7394B4-A544-4111-A35B-4661DF0C459C@.microsoft.com...[vbcol=seagreen]
> ADDED:
> I am also able to create and populate a fairly large table in a matter of
> minutes however updating to this one table is costing a lot of time.
> Now granted this table in question is much larger then most tables in the
> DB
> and larger then the tables I create but not 10 times larger!
> Also, this table gets a lot of activity. Could our problem be the table
> itself?
> "Sean" wrote:
>|||Well there is currently only 3 people accessing the server and only one (me)
accessing this particular database.
by my estimations it is taking about 1-3 seconds to update a row and in this
context each row has to be updated seperately.
Having said all that I think the functionality we are gaining might not be
worth the dev time which is a subject I will have for our meeting.
"Roger Wolter[MSFT]" wrote:

> Yes, and it could be a hardware problem or the phase of the moon. With no
> information about what the table looks like, what you are trying to do and
> what else is running, there's no way to tell. This is like calling your
> mechanic and saying it takes to long for me to get to work, what should I
> do? The main difference between update statements and select statements i
s
> they take update locks and write to disk. I would look at blocking waitin
g
> to lock something that's in use first but that's just idle speculation.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Sean" <Sean@.discussions.microsoft.com> wrote in message
> news:6E7394B4-A544-4111-A35B-4661DF0C459C@.microsoft.com...
>
>|||Sean wrote:
> Well there is currently only 3 people accessing the server and only one (m
e)
> accessing this particular database.
> by my estimations it is taking about 1-3 seconds to update a row and in th
is
> context each row has to be updated seperately.
> Having said all that I think the functionality we are gaining might not be
> worth the dev time which is a subject I will have for our meeting.
>
1-3 seconds to update a record? How many indexes are on this table? Is
there a clustered index? Is the column you're updating part of the
clustered index key? Are there update triggers on the table?|||Sean wrote:
> Well there is currently only 3 people accessing the server and only one (m
e)
> accessing this particular database.
> by my estimations it is taking about 1-3 seconds to update a row and in th
is
> context each row has to be updated seperately.
> Having said all that I think the functionality we are gaining might not be
> worth the dev time which is a subject I will have for our meeting.
>
1-3 seconds to update a record? How many indexes are on this table? Is
there a clustered index? Is the column you're updating part of the
clustered index key? Are there update triggers on the table?|||Basically none of the above and its safe to assume no optimization strategie
s
have been done for this database.
We have a primary key on this table but that is it really.
I have studied some on clustering because I wanted to go from MCAD to MCSD
but I dropped that database study so in short I am database stupid outside o
f
basic T-SQL statements.
If you guys think clustering etc will help a lot I will look into it because
this table is getting big.
Thanks
"Tracy McKibben" wrote:

> Sean wrote:
> 1-3 seconds to update a record? How many indexes are on this table? Is
> there a clustered index? Is the column you're updating part of the
> clustered index key? Are there update triggers on the table?
>

Big table

Hi,

I am writing a small dating site and now I am designing the DB.

At some point I realized that I will need to create a table with more
than 12 columns and I felt that it is not such a good idea.
I've tried normalizing the database, but It was with no effect.
So let's sat that I have the following table:

CREATE TABLE users
(
id int CONSTRAINT pk_user_id PRIMARY KEY,
username varchar(100),
password varchar(100),
isAccVerificated bit,
verificationNumber int,
f_name nvarchar(250),
l_name nvarchar(250),
e-mail varchar(250),
age int,
location l_name nvarchar(250),
visitors int,
isMale bit
picture_data binary
)

"picture_data" contain the real picture in byre array.

So my question is what is preferably to do.
I believe this is not such a good idea to leave this table like this.

Thanks in advance.12 columns is a perfectly reasonable number if you need them. I don't
think most people would call that large. Your defined sizes of those
columns are a different matter. You surely don't need 250 characters
each for first and last name! It's wise to choose sensible maximum
sizes for character columns - if you put the space in there, someone
will use it.

Going by the column names it doesn't look like you have any obvious
transitive dependencies but you do appear to have some other problems:

ID is the only key, which it shouldn't be if it's an artificial key.
How about enforcing the constraint that the username or email address
be unique and non-NULL? Usually that makes sense for sites that require
registration.

All your columns except ID are nullable! Do you really want people to
register anonymously? What's the point of a row with only an ID but no
other information.

isMale? Why not call this Gender or Sex and use the ISO codes for Sex,
which are 1=Male and 2=Female?

Store date of birth rather than age. Otherwise you have the problem of
keeping the age up to date.

Don't store passwords in the database; store secure hashes instead.
Password recovery mechanisms are insecure and bad practice, even where
high levels of security aren't a requirement (people tend to re-use
their passwords so you could end-up exposing the password to someone's
E-Banking account!)

--
David Portas
SQL Server MVP
--|||John,

Along with what David said, I'd avoid storing the pictures in the database.
For one thing, surely you want the members to be able to post multiple
pictures, and this design won't allow for that. Store them in the file
system instead.

Take a look at:
http://www.aspfaq.com/show.asp?id=2149

-Andy

<John.Arthur@.gmail.com> wrote in message
news:1113326413.314223.31090@.o13g2000cwo.googlegro ups.com...
> Hi,
> I am writing a small dating site and now I am designing the DB.
> At some point I realized that I will need to create a table with more
> than 12 columns and I felt that it is not such a good idea.
> I've tried normalizing the database, but It was with no effect.
> So let's sat that I have the following table:
> CREATE TABLE users
> (
> id int CONSTRAINT pk_user_id PRIMARY KEY,
> username varchar(100),
> password varchar(100),
> isAccVerificated bit,
> verificationNumber int,
> f_name nvarchar(250),
> l_name nvarchar(250),
> e-mail varchar(250),
> age int,
> location l_name nvarchar(250),
> visitors int,
> isMale bit
> picture_data binary
> )
> "picture_data" contain the real picture in byre array.
> So my question is what is preferably to do.
> I believe this is not such a good idea to leave this table like this.
> Thanks in advance.|||You can easily normalize the pictures into another table so that
multiple pictures could be
stored under the same account. Personally, I like that approach better
than cluttering the
file system.

-- Dave|||True. To each his own... :)

"Dave" <dafergu2@.hotmail.com> wrote in message
news:1113329911.088937.55740@.l41g2000cwc.googlegro ups.com...
> You can easily normalize the pictures into another table so that
> multiple pictures could be
> stored under the same account. Personally, I like that approach better
> than cluttering the
> file system.
> -- Dave

BIDS programming

Hi,

I want to create a wizard to help build my packages for certain situations, something like the export and import wizard.

I couldn't find the API to do it. can you help?

Thanks

Noa

Search Books Online for Integration Services Programming.

Lots o' content there.

K

|||

Can you be more specific?

I only found programming custom components to SSIS, not a wizard to ease use.

|||

SQL Server Books Online does not have documentation on programming your own Wizard application. I think that you'll find some information on this in the Visual Studio documentation.

As for creating a package programmatically -- which is what you want your wizard to do, as I understand -- you will find sections in BOL on "Building Packages Programmatically" and "Building the Data Flow Programmatically" to get you started.

We are all learners when it comes to the vast and flexible new Integration Services APIs.

-Doug

|||

Noa wrote:

Can you be more specific?

I only found programming custom components to SSIS, not a wizard to ease use.

You will need general VS documentation. See topics VsWizard Interface, IDTWizard Inteface.

Also there is a topic Walkthrough: Creating a Wizard in Dev Tools & Languages > VS > IDE > Customizing and Automating the Development Environment > Automation and Extensibility for Visual Studio > Creating Add-ins and Wizards.

BIDS programming

Hi,

I want to create a wizard to help build my packages for certain situations, something like the export and import wizard.

I couldn't find the API to do it. can you help?

Thanks

Noa

Search Books Online for Integration Services Programming.

Lots o' content there.

K

|||

Can you be more specific?

I only found programming custom components to SSIS, not a wizard to ease use.

|||

SQL Server Books Online does not have documentation on programming your own Wizard application. I think that you'll find some information on this in the Visual Studio documentation.

As for creating a package programmatically -- which is what you want your wizard to do, as I understand -- you will find sections in BOL on "Building Packages Programmatically" and "Building the Data Flow Programmatically" to get you started.

We are all learners when it comes to the vast and flexible new Integration Services APIs.

-Doug

|||

Noa wrote:

Can you be more specific?

I only found programming custom components to SSIS, not a wizard to ease use.

You will need general VS documentation. See topics VsWizard Interface, IDTWizard Inteface.

Also there is a topic Walkthrough: Creating a Wizard in Dev Tools & Languages > VS > IDE > Customizing and Automating the Development Environment > Automation and Extensibility for Visual Studio > Creating Add-ins and Wizards.

BIDS - How to turn-off auto naming of fields

Hi:

When I create a report, the wizard auto-renames fields.

E.g. if Table_COLUMN_Name=CustomerName, the list column header in the report will change to Customer Name. The wizard figures out Friendly names based on capitalization, and underscores and so on.

Similar behavior occurs even in SSAS projects Dimensions Wizard.

Is there a way to turn of this extra cuteness?

TIA

Kar

Hi:

Request help once again on this.

TIA

Kar

BIDS - How to turn-off auto naming of fields

Hi:

When I create a report, the wizard auto-renames fields.

E.g. if Table_COLUMN_Name=CustomerName, the list column header in the report will change to Customer Name. The wizard figures out Friendly names based on capitalization, and underscores and so on.

Similar behavior occurs even in SSAS projects Dimensions Wizard.

Is there a way to turn of this extra cuteness?

TIA

Kar

Hi:

Request help once again on this.

TIA

Kar

Bidirectional Synchronization for SQL Server Mobile?

I create a distributed database for mobile application. I replicate a table that distribute on mobile device. I follow instruction how to create distributor, publication, replication, web synchronization, and subscriber database. I have done fine for synchronization between mobile database into desktop database (in this case SQL Server 2005 Standard Edition). But the problem is how can setup publication so it can bidirectional, not only from mobile database into desktop database, but also from desktop database into mobile database. So in the mobile database can have same data with desktop database even on mobile database lost some old data.

Its like data exchange between both engine. Desktop and mobile have same data. For filtering I can put filter on the desktop server for replicated table, so don't worry how I split the data.

Thanks a lot.

Look into Merge replication, or transactional replication with updatable subscriptions.

Martin

BI Portal 2003 connecting to SSAS 2005

Hi,

I seem to have a problem connecting to the analysis server 2005 when I create a data source in BIP 2003. When I supply the servername, it says that "the server does not exist or access denied". However, when I try to use the Advanced option and create a connection string, I encounter an error message stating the ff:

Line: 465
Char: 4
Error: the object doesn't support this property or method
Code: 0
URL: http://localhost:8080/_layouts/1033/Menu.htc

How can I make a data source connection? Help is very much appreciated.

Thanks in advance,
May Lanie

If you would like to connect to Analysis Services using HTTP, you need to make sure you setup HTTP connectivity to Analysis Server. Here is whitepaper on how to do that: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx

If you would like to connect to AS using TCP/IP, here is set of instructions on how to troubleshoot connectivity problems http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello May,

Were you able to resolve this issue? I am experiencing the same issue. Please let me know either way. I will let you know what I find.

Thanks

BI Portal 2003 connecting to SSAS 2005

Hi,

I seem to have a problem connecting to the analysis server 2005 when I create a data source in BIP 2003. When I supply the servername, it says that "the server does not exist or access denied". However, when I try to use the Advanced option and create a connection string, I encounter an error message stating the ff:

Line: 465
Char: 4
Error: the object doesn't support this property or method
Code: 0
URL: http://localhost:8080/_layouts/1033/Menu.htc

How can I make a data source connection? Help is very much appreciated.

Thanks in advance,
May Lanie

If you would like to connect to Analysis Services using HTTP, you need to make sure you setup HTTP connectivity to Analysis Server. Here is whitepaper on how to do that: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx

If you would like to connect to AS using TCP/IP, here is set of instructions on how to troubleshoot connectivity problems http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello May,

Were you able to resolve this issue? I am experiencing the same issue. Please let me know either way. I will let you know what I find.

Thanks

BI on Windows XP

I want to create report through Microsoft Visual Studio 2005 (Business
Intelligence Project (Report Server Project) in Windows XP.
Which SQL Edition I can install in windows XP that gives me facility to
create report via Business Intelligence.
ThanksFirst, keep in mind that you are installing the BI Tools, you are not
installing SQL Server, you are not installing Reporting Services. Those are
server based and while they can be installed on XP (I know developers
edition, not sure what other editions) they are not needed for development.
The BI Tools are the same as far as I know for all editions. You can preview
the report, design the report. It is not until you are ready to deploy the
report to a server that RS even has to be installed somewhere.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rogers" <naissani@.hotmail.com> wrote in message
news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>I want to create report through Microsoft Visual Studio 2005 (Business
>Intelligence Project (Report Server Project) in Windows XP.
> Which SQL Edition I can install in windows XP that gives me facility to
> create report via Business Intelligence.
> Thanks
>|||Alright, that means when I installed SQL Server 2005 Developer Edition on
XP, the BI will also be installed?
Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u4wyxqXFIHA.3980@.TK2MSFTNGP03.phx.gbl...
> First, keep in mind that you are installing the BI Tools, you are not
> installing SQL Server, you are not installing Reporting Services. Those
> are server based and while they can be installed on XP (I know developers
> edition, not sure what other editions) they are not needed for
> development. The BI Tools are the same as far as I know for all editions.
> You can preview the report, design the report. It is not until you are
> ready to deploy the report to a server that RS even has to be installed
> somewhere.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rogers" <naissani@.hotmail.com> wrote in message
> news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>>I want to create report through Microsoft Visual Studio 2005 (Business
>>Intelligence Project (Report Server Project) in Windows XP.
>> Which SQL Edition I can install in windows XP that gives me facility to
>> create report via Business Intelligence.
>> Thanks
>>
>|||No, the install is a two step process. There is server side install which
includes reporting services (if you selected to install it) and then there
is installing client side tools. You have to do separate installs. Normally
the BI tools would not be on the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rogers" <naissani@.hotmail.com> wrote in message
news:ugJQ2LKHIHA.6068@.TK2MSFTNGP05.phx.gbl...
> Alright, that means when I installed SQL Server 2005 Developer Edition on
> XP, the BI will also be installed?
> Thanks
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:u4wyxqXFIHA.3980@.TK2MSFTNGP03.phx.gbl...
>> First, keep in mind that you are installing the BI Tools, you are not
>> installing SQL Server, you are not installing Reporting Services. Those
>> are server based and while they can be installed on XP (I know developers
>> edition, not sure what other editions) they are not needed for
>> development. The BI Tools are the same as far as I know for all editions.
>> You can preview the report, design the report. It is not until you are
>> ready to deploy the report to a server that RS even has to be installed
>> somewhere.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rogers" <naissani@.hotmail.com> wrote in message
>> news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>>I want to create report through Microsoft Visual Studio 2005 (Business
>>Intelligence Project (Report Server Project) in Windows XP.
>> Which SQL Edition I can install in windows XP that gives me facility to
>> create report via Business Intelligence.
>> Thanks
>>
>>
>

BI Development Studio not showing "create new project" on file menu

I just installed Reporting Services 2005 but when I start up SQL
Server Business Intelligence Development Studio I'm stuck. I don't
even have "create new project" as an option on my file menu, instead I
have "create team project" or "create file".
I previously had Visual Studio with Team Foundation Server on my
machine, but I only used it to log bugs. When I installed SS2005 and
reporting services I actually uninstalled the copy of Visual Studio I
had on my machine but that hasn't helped.
I don't want to create a teams project (and I don't haver permissions
anyway), I just want to use reporting services but it seems stuck in
some TFS mode. I'd take out the TFS part if I could figure out how
to.
Any ideas? Thanks in advance.Try to uninstall the TFS and reinstall visual studio 2005
Amarnath
"doug.andersen@.gmail.com" wrote:
> I just installed Reporting Services 2005 but when I start up SQL
> Server Business Intelligence Development Studio I'm stuck. I don't
> even have "create new project" as an option on my file menu, instead I
> have "create team project" or "create file".
> I previously had Visual Studio with Team Foundation Server on my
> machine, but I only used it to log bugs. When I installed SS2005 and
> reporting services I actually uninstalled the copy of Visual Studio I
> had on my machine but that hasn't helped.
> I don't want to create a teams project (and I don't haver permissions
> anyway), I just want to use reporting services but it seems stuck in
> some TFS mode. I'd take out the TFS part if I could figure out how
> to.
> Any ideas? Thanks in advance.
>

BI Dev Studio Licensing

I have a client that we're hosting a website for and we have a few reports
that we've done for them. They're wanting to create and publish their own
reports now and I'm wondering what to buy. They picked up Visual Studio Standard
Edition because on the MSDN site it says Standard does Reporting Services,
but after installing it, there's no Reporting Services Project type. I tried
having them install the client tools for SQL 2005 but the installer said
Reporting Services tools were already installed, not making much sense. How
exactly do I get them the BI Development Studio and does that require another
SQL 2005 license?SQL Server 2005 is licensed by the Server. There is no license for the
development tools. Unlike RS 2000, it ships with a version of VS if it is
not installed. If you have VS 2005 installed then it will install into that.
It doesn't make sense that it says the tools are already installed. I have
VS 2005 (because I needed VB.Net) and then installed VS 2005 BI on top of
that. VS 2005 has controls for Reporting Services IF you are creating your
own website or windows app. If all you want to do is create reports what you
want to do is install the BI client tools found on the SQL Server 2005 CD.
They can uninstall VS and any BI tools they find and then try again.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Josh Belden" <joshuabelden@.hotmail.com> wrote in message
news:dee73200137b98c7f6131ce52f7c@.news.microsoft.com...
>I have a client that we're hosting a website for and we have a few reports
>that we've done for them. They're wanting to create and publish their own
>reports now and I'm wondering what to buy. They picked up Visual Studio
>Standard Edition because on the MSDN site it says Standard does Reporting
>Services, but after installing it, there's no Reporting Services Project
>type. I tried having them install the client tools for SQL 2005 but the
>installer said Reporting Services tools were already installed, not making
>much sense. How exactly do I get them the BI Development Studio and does
>that require another SQL 2005 license?
>

BI Dev Studio I see no DATAFLOW DESTINATIONS in the toolbox

I just installed sql2005 and bi dev studio on a vista box. Then VS 2005 and all svc packs.
I create a new SSIS package but don't see any Data Flow Destinations in the toolbox while on the dataflow tab. I choose "show all" and don't see any data flow destinations anywhere.
I can use the wizard to create packages, and it adds destinations just fine.
Anyone have any idea what may be wrong?

A few things to try:

1. Run devenv.exe /setup

2. Refresh toolbox

3. Choose toolbox items

HTH.