Print Error in RS2005

Hi All
I have 2 questions regarding the printing of the report.
1) I have an asp.net apps in which there are some links which point to
the report.when comming to the printing of the report only one user
facing the problem while printing the report from the print button icon
from the report.he is getting eror "an error occurred during
printing(0X8007F304)"
He is using other application which contain reports and he can able to
print the report from same print button.
I did search on google for this particular error and in one forum they
said to do this
1. Closed all instance of Internet Explorer.
2. Opened Windows Explorer and went to C:\Windows\Downloaded Program
Files\
3. Right clicked on RSClientPrintClass and chose "Remove"
4. Went to my Reporting Services report and tried to print
5. Said "Install" when prompted to install the Reporting Services Print
Control
6. Printing commenced!
Am i supposed to do it on the server or else on the user PC (Kind of a
dumb question)
2) whats the purpose of the percertange box in the tool bar.is it
useful for the viewing the report by decreasing or printing the report
on a decreased percentage view.I thought by decreasing the
precentage,report size also decreases as it does if we decrease the
percentage and print it from the file menu options.
Thanks
vkvHi ,
Some new problem came in to picture.I did the same thing
removing the rsprintclientcalss and installed activex it worked for the
reports that are on th rs2005.
But the application that contains reports which are on rs2000 getting
an error as "An error occured during printing. (0x80004005).
Does rs2005 print activex should work for 2000?.Are there any options
like both the versions activex controls are downloaded so that both the
versions printing works.
Thanks
vkv

primary key vs. unique index

Hello,
What's the difference between primary key and unique index? At this point,
they are the same to me, but I could be wrong. Thank you in advance for
your comments.When you create a primary key, sqlserver will implement an unique index on
the column(s).
-oj
http://www.rac4sql.net
"Zeng" <zzy@.nonospam.com> wrote in message
news:%23X%23glov3DHA.3656@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hello,
> What's the difference between primary key and unique index? At this

---

point,

quote:

---

> they are the same to me, but I could be wrong. Thank you in advance for
> your comments.
>

---

|||Hi,
If you create a primary key, by default it will create clustered index (if
there doesn't exist any) on that column(s) and if you create a unique key
then by default it will create non-clustered index on the column(s).
- Kanth
"Zeng" <zzy@.nonospam.com> wrote in message
news:%23X%23glov3DHA.3656@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hello,
> What's the difference between primary key and unique index? At this

---

point,

quote:

---

> they are the same to me, but I could be wrong. Thank you in advance for
> your comments.
>

---

|||A primary key a logical concept which is declared for integrity reasons.
Indexes are physical artifacts added mostly for performance reasons. A table
can have only one primary key while a table can have more than one indexes.
Primary key columns must be non-nullable while unique index columns can be
nullable even though only one NULL is allowed (even for unique index on
multiple columns). Primary keys guarantee uniqueness irrespective of any
operations in the table while certain option on unique indexes can ignore
new or updated data that would create a duplicate key in the index. In SQL
Server, a declaration of primary key results in the creation of an index, by
default.
- Anith
( Please reply to newsgroups only )|||1. Primary Key is a field or group of fields within the table that uniquely
identifies thge record.
2. It cannot be repeated in any sybsequent row no matter how many rows are
added.
3 .Groups of primary key = Composite key.
1. SQL Server automatically creates an index for the table's PRIMARY KEY.
2. Totally we can have 250 Indexes. {Includes only 1 Clustered + 249 Non
Clustered}
3. Unique index contains no Duplicate values.
Bhaskaran.B
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:#NdUGex3DHA.2460@.TK2MSFTNGP10.phx.gbl...

quote:

---

> A primary key a logical concept which is declared for integrity reasons.
> Indexes are physical artifacts added mostly for performance reasons. A

---

table

quote:

---

> can have only one primary key while a table can have more than one

---

indexes.

quote:

---

> Primary key columns must be non-nullable while unique index columns can be
> nullable even though only one NULL is allowed (even for unique index on
> multiple columns). Primary keys guarantee uniqueness irrespective of any
> operations in the table while certain option on unique indexes can ignore
> new or updated data that would create a duplicate key in the index. In SQL
> Server, a declaration of primary key results in the creation of an index,

---

by

quote:

---

> default.
> --
> - Anith
> ( Please reply to newsgroups only )
>

---

|||1. Primary Key is a field or group of fields within the table that uniquely
identifies thge record.
2. It cannot be repeated in any sybsequent row no matter how many rows are
added.
3 .Groups of primary key = Composite key.
1. SQL Server automatically creates an index for the table's PRIMARY KEY.
2. Totally we can have 250 Indexes. {Includes only 1 Clustered + 249 Non
Clustered}
3. Unique index contains no Duplicate values.
Bhaskaran.B
----
"Zeng" <zzy@.nonospam.com> wrote in message
news:#X#glov3DHA.3656@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hello,
> What's the difference between primary key and unique index? At this

---

point,

quote:

---

> they are the same to me, but I could be wrong. Thank you in advance for
> your comments.
>

---

|||It's all clear to me now. Thank you everybody!
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:%23NdUGex3DHA.2460@.TK2MSFTNGP10.phx.gbl...

quote:

---

> A primary key a logical concept which is declared for integrity reasons.
> Indexes are physical artifacts added mostly for performance reasons. A

---

table

quote:

---

> can have only one primary key while a table can have more than one

---

indexes.

quote:

---

> Primary key columns must be non-nullable while unique index columns can be
> nullable even though only one NULL is allowed (even for unique index on
> multiple columns). Primary keys guarantee uniqueness irrespective of any
> operations in the table while certain option on unique indexes can ignore
> new or updated data that would create a duplicate key in the index. In SQL
> Server, a declaration of primary key results in the creation of an index,

---

by

quote:

---

> default.
> --
> - Anith
> ( Please reply to newsgroups only )
>

---

primary key vs. unique index

Hello,
What's the difference between primary key and unique index? At this point,
they are the same to me, but I could be wrong. Thank you in advance for
your comments.When you create a primary key, sqlserver will implement an unique index on
the column(s).
--
-oj
http://www.rac4sql.net
"Zeng" <zzy@.nonospam.com> wrote in message
news:%23X%23glov3DHA.3656@.TK2MSFTNGP11.phx.gbl...
> Hello,
> What's the difference between primary key and unique index? At this
point,
> they are the same to me, but I could be wrong. Thank you in advance for
> your comments.
>|||Hi,
If you create a primary key, by default it will create clustered index (if
there doesn't exist any) on that column(s) and if you create a unique key
then by default it will create non-clustered index on the column(s).
- Kanth
"Zeng" <zzy@.nonospam.com> wrote in message
news:%23X%23glov3DHA.3656@.TK2MSFTNGP11.phx.gbl...
> Hello,
> What's the difference between primary key and unique index? At this
point,
> they are the same to me, but I could be wrong. Thank you in advance for
> your comments.
>|||A primary key a logical concept which is declared for integrity reasons.
Indexes are physical artifacts added mostly for performance reasons. A table
can have only one primary key while a table can have more than one indexes.
Primary key columns must be non-nullable while unique index columns can be
nullable even though only one NULL is allowed (even for unique index on
multiple columns). Primary keys guarantee uniqueness irrespective of any
operations in the table while certain option on unique indexes can ignore
new or updated data that would create a duplicate key in the index. In SQL
Server, a declaration of primary key results in the creation of an index, by
default.
--
- Anith
( Please reply to newsgroups only )|||1. Primary Key is a field or group of fields within the table that uniquely
identifies thge record.
2. It cannot be repeated in any sybsequent row no matter how many rows are
added.
3 .Groups of primary key = Composite key.
1. SQL Server automatically creates an index for the table's PRIMARY KEY.
2. Totally we can have 250 Indexes. {Includes only 1 Clustered + 249 Non
Clustered}
3. Unique index contains no Duplicate values.
Bhaskaran.B
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:#NdUGex3DHA.2460@.TK2MSFTNGP10.phx.gbl...
> A primary key a logical concept which is declared for integrity reasons.
> Indexes are physical artifacts added mostly for performance reasons. A
table
> can have only one primary key while a table can have more than one
indexes.
> Primary key columns must be non-nullable while unique index columns can be
> nullable even though only one NULL is allowed (even for unique index on
> multiple columns). Primary keys guarantee uniqueness irrespective of any
> operations in the table while certain option on unique indexes can ignore
> new or updated data that would create a duplicate key in the index. In SQL
> Server, a declaration of primary key results in the creation of an index,
by
> default.
> --
> - Anith
> ( Please reply to newsgroups only )
>|||1. Primary Key is a field or group of fields within the table that uniquely
identifies thge record.
2. It cannot be repeated in any sybsequent row no matter how many rows are
added.
3 .Groups of primary key = Composite key.
1. SQL Server automatically creates an index for the table's PRIMARY KEY.
2. Totally we can have 250 Indexes. {Includes only 1 Clustered + 249 Non
Clustered}
3. Unique index contains no Duplicate values.
Bhaskaran.B
----
"Zeng" <zzy@.nonospam.com> wrote in message
news:#X#glov3DHA.3656@.TK2MSFTNGP11.phx.gbl...
> Hello,
> What's the difference between primary key and unique index? At this
point,
> they are the same to me, but I could be wrong. Thank you in advance for
> your comments.
>|||It's all clear to me now. Thank you everybody!
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:%23NdUGex3DHA.2460@.TK2MSFTNGP10.phx.gbl...
> A primary key a logical concept which is declared for integrity reasons.
> Indexes are physical artifacts added mostly for performance reasons. A
table
> can have only one primary key while a table can have more than one
indexes.
> Primary key columns must be non-nullable while unique index columns can be
> nullable even though only one NULL is allowed (even for unique index on
> multiple columns). Primary keys guarantee uniqueness irrespective of any
> operations in the table while certain option on unique indexes can ignore
> new or updated data that would create a duplicate key in the index. In SQL
> Server, a declaration of primary key results in the creation of an index,
by
> default.
> --
> - Anith
> ( Please reply to newsgroups only )
>