Sql Server reporting Services - Chart

  • Hi,

    I my report there are two charts, one is pie chart and another one is bar chart. If i click one porstion of the pie chart depends upon the pie chart data, the bar chart will be loaded.

    Is this is possible? Please help me.

    There is one tool Dundas Chart, there is some option to do like this, but i want to do in .net chart tools.

    Dundas chart is the third party tool supports .Net reporting services, but it is very costly.

    Please help me.

    Regards

    T. Ravindran.

  • U want both the chats to display on 1 report or when u click on pie chat based on that it show the bar chart in another report ???

  • If possible can i show the both the report in one report?

    If we show the bar chart in seperate report means it will display in seperate window are same window.

    Please help me...

    Thanks for your reply.

  • Hi

    i m not sure abt showing both the charts in 1 report

    and coming to going from 1 report to another ....the bar chart will b displayed in the second report (new window will not pop up but the new report will open ....) u can give a link on the second report to go back to 1st report ...

    this can b achived by passing parameter

    create paratmeter in second report and pass that parameter value from 1st report

  • Thanks for you help.

    How can i call that new report in pie chart? there is no option in pie chart properties. If possible please give me some sample.

  • right click on pie chart and go to properties . thr u will find the "Navigation" tab click on that and select "Jump to report" option

    give the name of ur second report and thn click on parameter and finally provide the parameters tht u created in ur second report....

    i hope this will help u

  • Sorry, i am having only these tabs.

    General

    data

    X Axis

    Y Axis

    Legend

    3D Effect

    Filters

    There is no navigation tab...

  • S, i got it, thanks a lot...

  • Hi,

    Is there is any possibility to do that calling both the chart in same report, any other option because my client is asking like that.

    Is there is any possibility in Sql Server 2008 Reporting Services?

  • Try using sub report option

    may b u will hve to hide the sub report by default and when u click on some thing....the sub report should display...just call ur second report in sub report (in 1st report)

  • K, i will try to do that. Thank you very much.

  • are u able to get both the charts in same report ???

  • No. If u known that please help me.

  • Hi Grasshopper,

    How u achieved the navigation in chart. Please let me know

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • I have not solved it yet. If you know please help me. It will be really helpful to me in future.

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

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