I created a Job in sql server, Which executes a SP (usp_WEBJobStep1)every 1 hour. This SP retreives eventIDs from the table for Result = 0.

For each EVentID I get the @whereClause , execute...

Sorry guys for the late response.

But here's what I did for the second SP. In this SP, the EventID is passed and I get the @Whereclaause. I then execute the...

thanks a lot to all of you for your help. For a newbie like me, I was able to learn a lot by just reading your comments and REALLY understanding...

Thanks a lot to all of you guys.

Yes Ian is right,

What is basicaly need is as follows

In the second proc that i listed, I am passing an "@eventID" as...

Thanks for the reply Sushila,

Here's what I am trying to do.

I have a stored Proc (which calls another SP):

Create Procedure usp_WEBJobStep1

DECLARE @WhereClause as varchar(5000)

DECLARE...

Thanks for the reply,

Here's a sample of the code:

DECLARE @WhereClause as varchar(4000)

SELECT @WhereClause = WhereCondition  from Table1 WHERE EventID = 1

DECLARE curDetailRecords CURSOR FOR

(select FirstName From Customers where @WhereClause)

Imran

David,

  Its not a browser pop-up issue. The report server is asking for credentials when i try to access it from my web app. Somehow the credentials are not passed...

Sergio,

Thanks for your help,

I got your email.

Imran

ahhh! Sorry about that. But I dont have access to any web server. I am working from my local machine.

Can I email u...

OK, Let me try once again. Normally in any report we have

1. the input page(Which has the input parameter fields and the the view report Button)  and

2. The...

I am using a table to display the data. I tried putting the title but it always displays that title on the results first page and not on the main...

Thanks for the reply Sergio.

If I use the above code, it displays the name of the report on the results page and not on the main page. I need the...

The datasource is a stored Procedure. The report is working fine, I am not worried about that. i am able input the values and the report is generating successfully.

Only...

I have a simple report which takes 2 parameters. Say FirstName and LastName. When I run the report it prompts for the 2 parameters. On this same page, I want...

I tried that, but that is showing up on the page when I click the View Report.

What i need is the title to show up on the page which lists...