Showing posts with label regarding. Show all posts
Showing posts with label regarding. Show all posts

Friday, March 30, 2012

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

Monday, March 12, 2012

Primary Key

I have a Department Table.

Can any one tell me its Primary Key.

I have the order

AutoNumber, D + AutoNumber, Code,

Can you help me regarding this.

Because some people never like to use AutoNumber.

That's why I am confused.

I'm not sure what it is you're trying to find out. Please post again.|||

I have to choose the Primary Key for Department Table.

Common way to choose AutoNumber.

But some people do not prefer AutoNumber.

Do you suggest it or not?

|||

You're right, there is a school of thought which does not approve of using autonumber to generate the primary field on a table. I have in the past used Autonumbers and have never had any problems with them when used as a key field.


As long as the key field doesn't have any relationship to the data within the record (other than to uniquely identify it) then it will be alright.