Hello All, I have a weird situation. My client wants to show something like: I was able to accomplish something like this: I am not able to get the N value on X-Axis to show itself only once. Is there anyway we can accomplish it in ssrs? Thank you for your time. Thank you, Sammie

It will definitely do it. From the example, it looks like the data is not properly bound to the control. I suggest you: 1. Go to the Query Designer and run the query to make sure it is generating the correct results. 2. Try to recreate the chart - and make sure you drag drop the fields from the dataset to the correct places on the chart control. (You might have to try few times to get it right..) 3. The chart has a facility to set maximum and minimum. Set Minimum =0, Maximum = 100. Good luck

It will definitely do it. From the example, it looks like the data is not properly bound to the control. I suggest you: 1. Go to the Query Designer and run the query to make sure it is generating the correct results. 2. Try to recreate the chart - and make sure you drag drop the fields from the dataset to the correct places on the chart control. (You might have to try few times to get it right..) 3. The chart has a facility to set maximum and minimum. Set Minimum =0, Maximum = 100. Good luck

It will definitely do it. From the example, it looks like the data is not properly bound to the control. I suggest you: 1. Go to the Query Designer and run the query to make sure it is generating the correct results. 2. Try to recreate the chart - and make sure you drag drop the fields from the dataset to the correct places on the chart control. (You might have to try few times to get it right..) 3. The chart has a facility to set maximum and minimum. Set Minimum =0, Maximum = 100. Good luck

Hello Patrick, Thank you for the reply. I think you are answering for the numbers for being so odd. The numbers represent some other values. The numbers are displaying properly.I am not worried about the numbers. I wanted the layout of the 'N' to be changed. I want to display 'N' only once rather than for every data point as in the first example. Thank you for your time. Thank you,Sammie

Hello Patrick, Thank you for the reply. I think you are answering for the numbers for being so odd. The numbers represent some other values. The numbers are displaying properly.I am not worried about the numbers. I wanted the layout of the 'N' to be changed. I want to display 'N' only once rather than for every data point as in the first example. Thank you for your time. Thank you,Sammie

Hi SammieRS, Thanks for your post. To better understand your issue, please help me clarify the questions below: What’s the dataset fields’ value looks like (such as the values showing on X-Axis)? Moreover, is it possible for you to process the X-Axis value to the desired format in dataset level using T-Sql statement? Format all month N value without the ‘N=’ as prefix except the minimum month value. Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi SammieRS, Thanks for your post. To better understand your issue, please help me clarify the questions below: What’s the dataset fields’ value looks like (such as the values showing on X-Axis)? Moreover, is it possible for you to process the X-Axis value to the desired format in dataset level using T-Sql statement? Format all month N value without the ‘N=’ as prefix except the minimum month value. Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi SammieRS, Thanks for your post. To better understand your issue, please help me clarify the questions below: What’s the dataset fields’ value looks like (such as the values showing on X-Axis)? Moreover, is it possible for you to process the X-Axis value to the desired format in dataset level using T-Sql statement? Format all month N value without the ‘N=’ as prefix except the minimum month value. Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hello Bill, Thank you for your reply. I am not concerned about the values or numbers(Please give no attention to what kinda values or what kinda numbers it is displaying). The months are timeframes and the values are their related numbers and the graph shows some other percentages. The 'N=' is something I added on reporting side. I used vbcrlf function to get it to next line. And said 'N=' some value. I just want to know if I can put a 'N=' infront of those values and not repeat 'N=' for every value. Rather I just want 'N=' to be displayed only once. As you can see that 'N=' is displayed only once in the 1st image. That is what I need to accomplish. Hope you understand me clearly now. Please let me know if any further clarification needed. I really appreciate your time.Sammie

Hello Bill, 1 more thing, I get dataset from a cube, which is from a linked server. it is too complicated to change the query. I was expecting a answer something on SSRS end directly rather than changing the back end query. Thank you for your time. Sammie

Sammie I think Bill may right. To clarify you want to 'N=' to prefix the first value on the x-axis. Please can you confirm that is what you want? If it is, you might be able to do it in the SQL as Bill suggests. Use the ROW_NUMBER function to count the rows. Then you could use a CASE statement to make the first value on the x-axis scale When RowNum = 1 THEN 'NE' + CAST(field1 as char(20)) . TBH, I am not sure if it will work but its a worth a shot. You could place a text box on top of the chart with an "N=" in it. But I suppose you have considered that alternative. You may find it will not line up well, so it's not a good solution in anaesthetic sense. Another question worth asking is how much does your client really want "N=" in that precise position? Enough to justify several days more work and cost? In the end, this is a semantic problem and the position of the "N=" does not affect the functionality although it does affect the "look and feel". Another question is - are the N values a second scale on the graph? If so, why not simply add the N series to the chart and axes on the left and right with different scales? This might look quite different from what the client expects but it still would cut the mustard.PG A bit of experimentation by trial and error often helps get round problems.

Yes Patrick, that is what I wanted. I can not change the query as it is handled by some other person as the client wanted to move the project fast, so, it was not worth it to send him a task to change it and readjust everything. Textbox was not a option as I have to use it outside the graph and it would mess with my other elements. Thank you Patrick and Bill. I found a work around. I used Title and readjusted it to fit at that particular point. Thank you for your time and effort. Sammie