How to run the report automatically without clicking on run report button

  • Hello

    I need to show my report on a report viewer, so my report now show the report just when i click on the run report button even if i don't set parameters it shows all the data rows in it,

    What i need exactly is to show these data rows at the first display of the report in my .net application without clicking on run report button.

    thank u in advence.

  • If you have configured defaults for all parameters, the report will execute when it first opens.

  • the problem is that i use stored procedure to creat the report dataset (there are dynamic sql quesry), so my report is able to show all datavalues even if i don't put eny parameter value and i tried to put the default values as blank, the report is not run first it's load,

    hope u can help plz

    thank u

  • Create default values that will work the same way blank does now or allow null.

  • Rezek,

    Are you pulling the report into your .Net app via an Iframe or are you using the Report Viewer control?


    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...

  • Hello,

    I solved the problem, in fact i used dynamic sql to create the reporte parameters so it check if there are eny parameter value before rendering the report,

    so when there are no parameters, is execute the query, and show all the report data rows

    that is done, my next step is to show this report in html format without reportViewer control, 🙂

    yes Ben, i used reportviewer, now i have to get the parameters values, i have to use html controls to creat the parameters textbox and send there values to view the report,

    so can u tell me plz how i can get these parameters values.

    Thank u

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply