Forum Replies Created

Viewing 15 posts - 1 through 15 (of 20 total)

  • RE: Cursors

    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...

  • RE: Cursors

    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...

  • RE: Cursors

    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...

  • RE: Cursors

    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...

  • RE: Cursors

    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

    AS

    DECLARE @EventID as int

    DECLARE @WhereClause as varchar(5000)

    DECLARE...

  • RE: Cursors

    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

  • RE: passing credentials from asp.net app to RS

    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...

  • RE: Page Header

    Sergio,

    Thanks for your help,

    I got your email.

    Imran

  • RE: Page Header

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

    Can I email u...

  • RE: Page Header

    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...

  • RE: Page Header

    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...

  • RE: Page Header

    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...

  • RE: Page Header

    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...

  • RE: Page Header

    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...

  • RE: Page Header

    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...

Viewing 15 posts - 1 through 15 (of 20 total)