Database

pmarfleet6-Sep-07 4:03

6-Sep-07 4:03

Try restarting the Report Server and see if it makes any difference.

Paul

Bryan Bradford6-Sep-07 4:06

Bryan Bradford

6-Sep-07 4:06

No difference at all.

Thanks,
Bryan

pmarfleet6-Sep-07 4:23

6-Sep-07 4:23

Visual Studio Team System has a performance testing tool for SSRS reports.

If you don't have access to this, all I can suggest is analysing each element of your report to see where the bottleneck is. Are you doing some manipulation of the data in the report after it has been retrieved from the database that might be causing a problem?

Paul

Bryan Bradford6-Sep-07 4:33

Bryan Bradford

6-Sep-07 4:33

The only manipulation that I am doing is in a table I am summing values for a total row. Do you know if Visual Studio Developer edition has those performance tools? How are they accessed? I am great at creating the reports...just ignorant when something like this goes wrong.

Thanks,
Bryan

pmarfleet6-Sep-07 5:25

6-Sep-07 5:25

This article[^] gives you some more information. It is only a feature in Team System though.

running subquery within the same table

Pete O'Hanlon6-Sep-07 8:20

Pete O'Hanlon

6-Sep-07 8:20

Bryan - run the Sql Profiler against your server to see what's going on. This[^] article details what to set up.

Deja View - the feeling that you've seen this post before.

firestoper6-Sep-07 3:31

firestoper

6-Sep-07 3:31

I know this q is very elementary but here it goes.

I'm trying to run a subquery on this table to get the name from ReportsTo Column

EmployeeID Name Hired reportsto
1 Ms. Davolio Nancy May 1 1992 2
2 Dr. Fuller Andrew Aug 14 1992 2
3 Ms. Leverling Janet Apr 1 1992 2
4 Mrs. Peacock Margaret May 3 1993 1

This query doesn't seem to work

Select Name, (select name from employees where employeeid = reportsto) as 'ReportsTo' from employees

Please advice

Re: running subquery within the same table

Michael Potter6-Sep-07 3:39

Michael Potter

6-Sep-07 3:39

You were close. You need to reference the inital table in the subquery for it to work.

SELECT 
    Name, 
    (select name from employees where employeeid = e.reportsto) as 'ReportsTo' 
from 
    employees e

Better set logic (should be faster on large tables):

SELECT
    e1.Name,
    e2.Name as ReportsTo
FROM
    employees e1
LEFT JOIN
    employees e2
    ON (e1.reportsto = e2.employeeid)

Re: running subquery within the same table

firestoper6-Sep-07 3:50

firestoper

6-Sep-07 3:50

Almost

Thanks Mike

Insert multiple values selected from listbox into database

anuradha.rrao6-Sep-07 3:02

anuradha.rrao

6-Sep-07 3:02

Hi,

I have a table, userprofile(fname,lname,address,hobbies). Hobbies is multiple selection from the list box, which binds data at run time. I want to select multiple hobbies and insert it into one single row. I have a faint idea od using a for loop for this purpose. Can you please help me?

Regards,
Anuradha

Re: Insert multiple values selected from listbox into database

Frank Kerrigan6-Sep-07 3:06

Frank Kerrigan

6-Sep-07 3:06

What you should really do is normalise your db and have your tables like this

userprofile(UserID, fname,lname,address)

hobbies(UserID, Hobby)

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: Insert multiple values selected from listbox into database

anuradha.rrao6-Sep-07 3:30

anuradha.rrao

6-Sep-07 3:30

First of all, thanks you for the prompt reply. I actually thought about this earlier- having a user table and a hobby table and another user_x_hobby table where I can insert the Userid against the HobbyId. But then my question was, what query I could run on this. I am new to .Net/SQL and trying to explore new possibilities.

Regards,
Anuradha

Sql Server 2005 Reporting Web Services

uksub6-Sep-07 1:35

uksub

6-Sep-07 1:35

How do I use WebServices as a datasource for my reports? I see where you create a datasource there's an option for "xml". Has anyone used "WebService" to create a custom dataset data extension, and if so how do you do it?

Re: Sql Server 2005 Reporting Web Services

pmarfleet6-Sep-07 10:36

Database connection problem for remote machine

6-Sep-07 10:36

Have a look at this article.

Kissy165-Sep-07 23:09

Kissy16

5-Sep-07 23:09

hai to all,
Here i am trying to connect with the remote machine database.The db connection string has given in web.config file.(tried both with IP address and machine name for data source)
While i am debugging my application,it is giving an errore like
"sql server does not exist or access denied"
What is the solution to this problem???
Am i need to set any setting at any level???
give me sme solution.

kissy

vimal_yet5-Sep-07 23:24

vimal_yet

5-Sep-07 23:24

Is there Database in the new machine ...... if so check whether u gave the correct user name and password to the DB

If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt

Kissy165-Sep-07 23:28

Kissy16

5-Sep-07 23:28

thanks for responding to my post.
Yes the remote machine have the db and i have checked for all the parameters in the connection string which are correct.
<add key="connstring" value="Data Source=104.131.2.91;initial catalog=batch;uid=bt1;pwd=bt201;persist security info=false">

still i am unable to connect to the database.
i am using vs2003 and sqlserver 2000

kissy

John-ph5-Sep-07 23:29

John-ph

5-Sep-07 23:29

Kissy16 wrote:
"sql server does not exist or access denied"

Remote Server May be down or the Sql Server service may be stopped...

Regards
J O H N

"Even eagles need a push." David McNally