Post reply

show a report in html format without reportViewer control

  • April 21, 2008 at 1:10 am

    #181551

    Hello,

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

    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

  • April 22, 2008 at 6:37 am

    #805464

    rezek23000 (4/21/2008)

    Hello,

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

    I am guessing you mean you want to set the values so that you can execute the report ?? If the report view has got a query running in the parameter you would have to know what the query is so that you can execute it and present the same options. If this list is coded in the report definition I am not sure if there is a way to query it. There are some samples available for SSRS that help expose some of the API's. I found mine in C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services.

    Is your intent to execute and "render" the report onto your local IIS server so that it can be presented to the user ? Why are you relectant to use it ?

    Frank

  • April 22, 2008 at 11:48 am

    #805661

    thank u frank 🙂

    actually i mean that i need to hide the paramaters prompts in the report viewer when i access it throw my ASP application, unstead i have to use textboxes to get the parameters values and a button to run the report,

    it's because i can handle the parameters textboxs and choose the color and width, unlike the parameters prompts.

    i have done this today, now i want to add a filter button near each parameter, so that i can choose the

    Interval of values : for exemple i have a parameter called "year" and when i click on the filter button, it show a popup window wich ask use the put the speacific values like

    year > 1995, year < 2007,

    the question is whow can i do this? should i define a new dataset ?? of just write a new query in the application ??

    thank u if u have any idea.

    yours

    🙂

  • April 22, 2008 at 12:20 pm

    #805680

    Hi again,

    >the question is whow can i do this? should i define a new dataset ?? of just write a new query in the application ??

    I think if you want the look of the report to work the same (from your app as opposed to report viewer) I would create a new dataset and just do a "select distinct year_val from your_table".

    Frank

  • April 22, 2008 at 12:49 pm

    #805696

    ok thank u firend i'll try that,

    🙂

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

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