Adding a horizontal bar chart to results

I want to add a horizontal bar chart to each line of my results:
Question Choice Percentage Chart
1 Yes %75 |||||||||| |
2 No %25 |||| |
Is there a way to do this in SQL Server Reporting Services?
BrandonYou could write custom function to generate bitmap image.
Email me if you want an example
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brandon Tyler" <tyler_brandon[NOSPAMO]@.hotmail.com> wrote in message
news:%23ZVseeDGFHA.1044@.TK2MSFTNGP14.phx.gbl...
>I want to add a horizontal bar chart to each line of my results:
> Question Choice Percentage Chart
> 1 Yes %75 |||||||||| |
> 2 No %25 |||| |
> Is there a way to do this in SQL Server Reporting Services?
> Brandon
>|||You could do it with charts: add a table and a table group based on Question
/ Choice and drop a chart into the group *header*.
Though, Lev's suggestion is in many cases better from a performance point of
view, etc.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:ufj20qGGFHA.3648@.TK2MSFTNGP09.phx.gbl...
> You could write custom function to generate bitmap image.
> Email me if you want an example
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Brandon Tyler" <tyler_brandon[NOSPAMO]@.hotmail.com> wrote in message
> news:%23ZVseeDGFHA.1044@.TK2MSFTNGP14.phx.gbl...
>>I want to add a horizontal bar chart to each line of my results:
>> Question Choice Percentage Chart
>> 1 Yes %75 |||||||||| |
>> 2 No %25 |||| |
>> Is there a way to do this in SQL Server Reporting Services?
>> Brandon
>>
>|||Lev,
I am interested in that code! How do I get hold of it? I do not have email
address for you. Mine is wiseteufel[AT]yahoo.com. Thanks in advance.
--
Message posted via http://www.sqlmonster.com|||Hello James,
I've posted it here: http://blogs.msdn.com/levs/archive/2005/02/24.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Woo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:b213f85c9f314f1e82c6c9606d00936b@.SQLMonster.com...
> Lev,
> I am interested in that code! How do I get hold of it? I do not have email
> address for you. Mine is wiseteufel[AT]yahoo.com. Thanks in advance.
> --
> Message posted via http://www.sqlmonster.com|||thanks. looks very nice.
--
Message posted via http://www.sqlmonster.comsql

add additional right scale on chart report

Hi there,

I have a case. I have 3 numeric fields and 1 category field to be displayed on bar chart reports. the problem is 2 of the 3 numeric fields have significant different scale value. so I need to add additonal scale at the right side of bar chart to represent 1 numeric fields + the 2 other numeric fields at the left side scale (Y). Please advice. Thanks.

R'gards

Toni

A secondary y-axis is currently not supported natively. Adding this feature in RS charts natively is under consideration for a future release.

Note: RS 2005 also has the new CustomReportItem feature. This enables ISVs to offer add-on components which integrate with RS 2005 and e.g. provide secondary y-axis in charts already today. E.g. Dundas Software offers such a product which needs to be licensed separately.

-- Robert

Add a print button on to Reportviewer of srs

Hi,
I have generated reports using SQL server reporting services 2000. I need to
put a print button in the report tool bar which will prints the content
displayed in the report(only the report content). Can any body tell me how to
enable the print option in the tool bar of repotviewer.
Thanks in advance
AjayAjay,
To my knowledge, you need to export to PDF, then print from acrobat reader.
Ask for a second opinion though...
--
TIM ELLISON
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||Ajay,
It is simple ... you can't :-(
However, if you are willing to hold you breath a couple of months, Service
Pack 2 will come with a print control and you will have the much coveted
print button.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
> to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
> to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
Thanks
"Teo Lachev [MVP]" wrote:
> Ajay,
> It is simple ... you can't :-(
> However, if you are willing to hold you breath a couple of months, Service
> Pack 2 will come with a print control and you will have the much coveted
> print button.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/|||The last think I heard is that it will be slated to January - February
timeframe.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Keenz" <Keenz@.discussions.microsoft.com> wrote in message
news:E60EFA77-809F-476B-BE01-FD58778ABF05@.microsoft.com...
> When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
> Thanks
> "Teo Lachev [MVP]" wrote:
>> Ajay,
>> It is simple ... you can't :-(
>> However, if you are willing to hold you breath a couple of months,
>> Service
>> Pack 2 will come with a print control and you will have the much coveted
>> print button.
>> --
>> Hope this helps.
>> ---
>> Teo Lachev, MVP [SQL Server], MCSD, MCT
>> Author: "Microsoft Reporting Services in Action"
>> Publisher website: http://www.manning.com/lachev
>> Buy it from Amazon.com: http://shrinkster.com/eq
>> Home page and blog: http://www.prologika.com/|||Has the new service pack release for print option in the report veiwer .
Please need the information urgently.
Thanks
Ajay kumar
"Ajay Kumar" wrote:
> Hi,
> I have generated reports using SQL server reporting services 2000. I need to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||SP2 will contain a new print button on the tool bar. We are currently in
beta.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> Has the new service pack release for print option in the report veiwer .
> Please need the information urgently.
> Thanks
> Ajay kumar
> "Ajay Kumar" wrote:
>> Hi,
>> I have generated reports using SQL server reporting services 2000. I need
>> to
>> put a print button in the report tool bar which will prints the content
>> displayed in the report(only the report content). Can any body tell me
>> how to
>> enable the print option in the tool bar of repotviewer.
>> Thanks in advance
>> Ajay|||Any news from service pack 2 ?
Greetz
"Daniel Reib [MSFT]" wrote:
> SP2 will contain a new print button on the tool bar. We are currently in
> beta.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> >
> > Has the new service pack release for print option in the report veiwer .
> >
> > Please need the information urgently.
> >
> > Thanks
> > Ajay kumar
> >
> > "Ajay Kumar" wrote:
> >
> >> Hi,
> >>
> >> I have generated reports using SQL server reporting services 2000. I need
> >> to
> >> put a print button in the report tool bar which will prints the content
> >> displayed in the report(only the report content). Can any body tell me
> >> how to
> >> enable the print option in the tool bar of repotviewer.
> >>
> >> Thanks in advance
> >>
> >> Ajay
> >>
>
>|||Not sure what you are asking. SP2 was released last week.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:6D56A681-91A3-4E37-8910-E63F38D321DF@.microsoft.com...
> Any news from service pack 2 ?
> Greetz
> "Daniel Reib [MSFT]" wrote:
>> SP2 will contain a new print button on the tool bar. We are currently in
>> beta.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
>> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
>> >
>> > Has the new service pack release for print option in the report veiwer
>> > .
>> >
>> > Please need the information urgently.
>> >
>> > Thanks
>> > Ajay kumar
>> >
>> > "Ajay Kumar" wrote:
>> >
>> >> Hi,
>> >>
>> >> I have generated reports using SQL server reporting services 2000. I
>> >> need
>> >> to
>> >> put a print button in the report tool bar which will prints the
>> >> content
>> >> displayed in the report(only the report content). Can any body tell me
>> >> how to
>> >> enable the print option in the tool bar of repotviewer.
>> >>
>> >> Thanks in advance
>> >>
>> >> Ajay
>> >>
>>