How to let end users customize report chart in SSRS?
currently,i am working on sql server business intelligence to generate reports. i did all the staff that i want to be in the report except the " ability for the[ end user] to customize the report without making another request to the server to generate another report based on another request. first i did this through a parameter of type Boolean and wrote an expression to check the parameter before generating the report,but my project leader said i don't want to make a request each time instead i want to bring all possible data and let the end user decide what to show. in other words, my report contains a chart of three series i want the end user have the ability to show a set of them or all of them in client side + one request. how can i do it through sql server business intelligence 2008 is it possible to add a check box for each series and when the user check them only those which are checked will be shown on the chart directly without sending request to the server to reprocess the new request !! help me quickly my team is waiting !!
July 17th, 2011 12:56am

What is Your SSRS project based on ? SQL Server DataBase or SQL Server Analysis Service ? AFAIK you can design the SSRS report with many conditions which the end user can input their own value in . if It's based on SQL Server DataBase the conditions looks like parameters of procedure that you use in SSRS if it's based on SSAS , The conditions looks like MDX code Kuldeep
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2011 2:43am

based on SQL Server DataBase . and as i said i don't want to use the parameter ; because with them i should send request to the server each time in order to customize the chart . i tried different way such as creating all possible companion that the user will pick then but them one over other and use text box for each one and set the visibility setting to be assigned to one of the text box . so in the result i will have multiple [+] with multiple chart and if the user want to see one he clicks on one of them . but i couldn't complete the cause because i can’t do the reverse action such as hide after showing . is there any way that could help my case without using parameters ? is it possible to add check box element in the report to customize the chart series ? is it possible to bring all the data of the report then extract the needed data from it then build my report and keep doing this multiple times without sending second request to the server? how can i include controls or html elements in the report? i have a query which returns three different fields and i want to set the min value for the x-axis to be the min value among the three columns of the database in the expression such as : =min(field1,field2 ,field3) or min(min(field1),min(field2) ,min(field3));because i don't know the syntax ? thank you for your quick repose
July 17th, 2011 6:03am

based on SQL Server DataBase . and as i said i don't want to use the parameter ; because with them i should send request to the server each time in order to customize the chart . i tried different way such as creating all possible companion that the user will pick then but them one over other and use text box for each one and set the visibility setting to be assigned to one of the text box . so in the result i will have multiple [+] with multiple chart and if the user want to see one he clicks on one of them . but i couldn't complete the cause because i can’t do the reverse action such as hide after showing . is there any way that could help my case without using parameters ? is it possible to add check box element in the report to customize the chart series ? is it possible to bring all the data of the report then extract the needed data from it then build my report and keep doing this multiple times without sending second request to the server? how can i include controls or html elements in the report? i have a query which returns three different fields and i want to set the min value for the x-axis to be the min value among the three columns of the database in the expression such as : =min(field1,field2 ,field3) or min(min(field1),min(field2) ,min(field3));because i don't know the syntax ? thank you for your quick repose
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2011 12:41am

Hi MFM, According to your description, you would like to customize the chart without send request to database server. Please reference the bellow question I answered. 1. Is there any way that could help my case without using parameters? Yes. You can show all the users needed chart in your report, with each chart there is a relevant textbox to control its visibility, set ToggleItem property of each chart to the corresponding textbox. Please refer to the steps below: (1). Select one chart and press F4 to switch to the properties panel. (2). Set ToggleItem to the corresponding Textbox, which you want to use to control the chart’s visibility. 2. Is it possible to add check box element in the report to customize the chart series? How can i include controls or html elements in the report? No. SSRS only support partial html elements, which is used to format text string. But you can build an Asp.Net project, in which you can use ReportViewer control to refer to the relevant report through URL, and all the html elements is available in it. 3. Is it possible to bring all the data of the report then extract the needed data from it then build my report and keep doing this multiple times without sending second request to the server? Yes. You could create a dataset which caches all the data the users needed, then specify Filters to filter the special data to customize chart, at last setting Cache a temporary copy of the report for the corresponding report in report manager. Please refer to the article below to learn how to Cache a report: http://msdn.microsoft.com/en-us/library/ms178821.aspx 4. I have a query which returns three different fields and i want to set the min value for the x-axis to be the min value among the three columns of the database in the expression such as : =min(field1,field2 ,field3) or min(min(field1),min(field2) ,min(field3));because i don't know the syntax ? You can edit your expression like this: =IIf(Fields!field1.Value>Fields!Field2.Value,IIf(Fields!Field2.Value>Fields!Field3.Value,Fields!Field3.Value,Fields!Field2.Value),IIf(Fields!Field1.Value>Fields!Field3.Value,Fields!Field3.Value, Fields! Field1.Value) If you have anything unclear, please feel free to let me know. thanks, Bill Lu
July 25th, 2011 2:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics