| Groups | Blog | Home |
sql server reporting services : percent in diagramms
http://www.stammer.at/sql/sql.html under this email adress you'll find a picture of 2 reports containing bars. My diagramm shows a qustion with up to 5 possible answers. when I display just one question my diagramm works fine. I just like the diagramm to go up to 100% and not end with the highest bar.(When using the bars with the 100% every bar displays 100% instead of their real values). when I like to make a diagramm containing all Questions(they are grouped in the diagramm) the percent calculation works fine in the table (the percent values are situated in the last column of the table) but not in the graph. All bars are at 100%. below you can see the used formuala to calculate the percentage: =(Fields!PPQ_Count.Value)/((Sum(Fields!PPQ_Count.Value))/100) in my percent fields I just show 1 number after the comma with N2 but now it is not possible to add & "%" in the table fields? thanks for your help
Yeah this is one of my questions. when adding the % sign my number
formater doesn't work any more. I then have the % sign added but lots of numbers after the comma. Ben Watts schrieb: [quoted text, click to view] > So you are trying to add the percent sign to your number?
> > "florian" <florian.stammer@gmail.com> wrote in message > news:1153842300.488894.291770@i42g2000cwa.googlegroups.com... > > Hi, > > > > http://www.stammer.at/sql/sql.html > > > > under this email adress you'll find a picture of 2 reports containing > > bars. > > > > My diagramm shows a qustion with up to 5 possible answers. > > > > when I display just one question my diagramm works fine. I just like > > the diagramm to go up to 100% and not end with the highest bar.(When > > using the bars with the 100% every bar displays 100% instead of their > > real values). > > > > when I like to make a diagramm containing all Questions(they are > > grouped in the diagramm) the percent calculation works fine in the > > table (the percent values are situated in the last column of the table) > > but not in the graph. All bars are at 100%. > > > > below you can see the used formuala to calculate the percentage: > > =(Fields!PPQ_Count.Value)/((Sum(Fields!PPQ_Count.Value))/100) > > > > in my percent fields I just show 1 number after the comma with N2 but > > now it is not possible to add & "%" in the table fields? > > > > thanks for your help > >
So you are trying to add the percent sign to your number?
[quoted text, click to view] "florian" <florian.stammer@gmail.com> wrote in message news:1153842300.488894.291770@i42g2000cwa.googlegroups.com... > Hi, > > http://www.stammer.at/sql/sql.html > > under this email adress you'll find a picture of 2 reports containing > bars. > > My diagramm shows a qustion with up to 5 possible answers. > > when I display just one question my diagramm works fine. I just like > the diagramm to go up to 100% and not end with the highest bar.(When > using the bars with the 100% every bar displays 100% instead of their > real values). > > when I like to make a diagramm containing all Questions(they are > grouped in the diagramm) the percent calculation works fine in the > table (the percent values are situated in the last column of the table) > but not in the graph. All bars are at 100%. > > below you can see the used formuala to calculate the percentage: > =(Fields!PPQ_Count.Value)/((Sum(Fields!PPQ_Count.Value))/100) > > in my percent fields I just show 1 number after the comma with N2 but > now it is not possible to add & "%" in the table fields? > > thanks for your help >
You can turn that into a percent value using "P" in the fomat. And if you
keep doing it the same way and not using that format option you want to multiply it by 100 instead of dividing it by a hundred. Put parenthesis around your division and then mulitply all that by 100. [quoted text, click to view] "florian" <florian.stammer@gmail.com> wrote in message news:1153842300.488894.291770@i42g2000cwa.googlegroups.com... > Hi, > > http://www.stammer.at/sql/sql.html > > under this email adress you'll find a picture of 2 reports containing > bars. > > My diagramm shows a qustion with up to 5 possible answers. > > when I display just one question my diagramm works fine. I just like > the diagramm to go up to 100% and not end with the highest bar.(When > using the bars with the 100% every bar displays 100% instead of their > real values). > > when I like to make a diagramm containing all Questions(they are > grouped in the diagramm) the percent calculation works fine in the > table (the percent values are situated in the last column of the table) > but not in the graph. All bars are at 100%. > > below you can see the used formuala to calculate the percentage: > =(Fields!PPQ_Count.Value)/((Sum(Fields!PPQ_Count.Value))/100) > > in my percent fields I just show 1 number after the comma with N2 but > now it is not possible to add & "%" in the table fields? > > thanks for your help >
If you do use the P in the format box, then take away the 100. SSRS
automatically does that for you, when you choose p [quoted text, click to view] "Ben Watts" <ben.watts@aaronnickellhomes.com> wrote in message news:uPTo1YAsGHA.652@TK2MSFTNGP04.phx.gbl... > You can turn that into a percent value using "P" in the fomat. And if you > keep doing it the same way and not using that format option you want to > multiply it by 100 instead of dividing it by a hundred. Put parenthesis > around your division and then mulitply all that by 100. > > "florian" <florian.stammer@gmail.com> wrote in message > news:1153842300.488894.291770@i42g2000cwa.googlegroups.com... >> Hi, >> >> http://www.stammer.at/sql/sql.html >> >> under this email adress you'll find a picture of 2 reports containing >> bars. >> >> My diagramm shows a qustion with up to 5 possible answers. >> >> when I display just one question my diagramm works fine. I just like >> the diagramm to go up to 100% and not end with the highest bar.(When >> using the bars with the 100% every bar displays 100% instead of their >> real values). >> >> when I like to make a diagramm containing all Questions(they are >> grouped in the diagramm) the percent calculation works fine in the >> table (the percent values are situated in the last column of the table) >> but not in the graph. All bars are at 100%. >> >> below you can see the used formuala to calculate the percentage: >> =(Fields!PPQ_Count.Value)/((Sum(Fields!PPQ_Count.Value))/100) >> >> in my percent fields I just show 1 number after the comma with N2 but >> now it is not possible to add & "%" in the table fields? >> >> thanks for your help >> > >
any ideas to my other problems?
Ben Watts schrieb: [quoted text, click to view] > If you do use the P in the format box, then take away the 100. SSRS
> automatically does that for you, when you choose p > "Ben Watts" <ben.watts@aaronnickellhomes.com> wrote in message > news:uPTo1YAsGHA.652@TK2MSFTNGP04.phx.gbl... > > You can turn that into a percent value using "P" in the fomat. And if you > > keep doing it the same way and not using that format option you want to > > multiply it by 100 instead of dividing it by a hundred. Put parenthesis > > around your division and then mulitply all that by 100. > > > > "florian" <florian.stammer@gmail.com> wrote in message > > news:1153842300.488894.291770@i42g2000cwa.googlegroups.com... > >> Hi, > >> > >> http://www.stammer.at/sql/sql.html > >> > >> under this email adress you'll find a picture of 2 reports containing > >> bars. > >> > >> My diagramm shows a qustion with up to 5 possible answers. > >> > >> when I display just one question my diagramm works fine. I just like > >> the diagramm to go up to 100% and not end with the highest bar.(When > >> using the bars with the 100% every bar displays 100% instead of their > >> real values). > >> > >> when I like to make a diagramm containing all Questions(they are > >> grouped in the diagramm) the percent calculation works fine in the > >> table (the percent values are situated in the last column of the table) > >> but not in the graph. All bars are at 100%. > >> > >> below you can see the used formuala to calculate the percentage: > >> =(Fields!PPQ_Count.Value)/((Sum(Fields!PPQ_Count.Value))/100) > >> > >> in my percent fields I just show 1 number after the comma with N2 but > >> now it is not possible to add & "%" in the table fields? > >> > >> thanks for your help > >> > > > >
Ok using "p" does the trick in my tables but I'm still don't getting
the diagramm right. Can anybody help me with this? florian schrieb: [quoted text, click to view] > any ideas to my other problems?
> > Ben Watts schrieb: > > > If you do use the P in the format box, then take away the 100. SSRS > > automatically does that for you, when you choose p > > "Ben Watts" <ben.watts@aaronnickellhomes.com> wrote in message > > news:uPTo1YAsGHA.652@TK2MSFTNGP04.phx.gbl... > > > You can turn that into a percent value using "P" in the fomat. And if you > > > keep doing it the same way and not using that format option you want to > > > multiply it by 100 instead of dividing it by a hundred. Put parenthesis > > > around your division and then mulitply all that by 100. > > > > > > "florian" <florian.stammer@gmail.com> wrote in message > > > news:1153842300.488894.291770@i42g2000cwa.googlegroups.com... > > >> Hi, > > >> > > >> http://www.stammer.at/sql/sql.html > > >> > > >> under this email adress you'll find a picture of 2 reports containing > > >> bars. > > >> > > >> My diagramm shows a qustion with up to 5 possible answers. > > >> > > >> when I display just one question my diagramm works fine. I just like > > >> the diagramm to go up to 100% and not end with the highest bar.(When > > >> using the bars with the 100% every bar displays 100% instead of their > > >> real values). > > >> > > >> when I like to make a diagramm containing all Questions(they are > > >> grouped in the diagramm) the percent calculation works fine in the > > >> table (the percent values are situated in the last column of the table) > > >> but not in the graph. All bars are at 100%. > > >> > > >> below you can see the used formuala to calculate the percentage: > > >> =(Fields!PPQ_Count.Value)/((Sum(Fields!PPQ_Count.Value))/100) > > >> > > >> in my percent fields I just show 1 number after the comma with N2 but > > >> now it is not possible to add & "%" in the table fields? > > >> > > >> thanks for your help > > >> > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |