Adding a legend to a report

I want to add a legend to a report. In the .Net version of the report, a
button was clicked which brought up a html page. Any suggestions?Why not adding a hyperlink to your RS reports which also points to a html
page?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Delton Blackwell" <deltonblackwell@.hotmail.com> wrote in message
news:OjCNQTTWEHA.3024@.TK2MSFTNGP09.phx.gbl...
> I want to add a legend to a report. In the .Net version of the report, a
> button was clicked which brought up a html page. Any suggestions?
>|||I don't quite understand your question. Would you please elaborate on what
you are attempting to achieve
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Delton Blackwell" <deltonblackwell@.hotmail.com> wrote in message
news:OjCNQTTWEHA.3024@.TK2MSFTNGP09.phx.gbl...
> I want to add a legend to a report. In the .Net version of the report, a
> button was clicked which brought up a html page. Any suggestions?
>

Add database table

Hello everyone, I was wondering if there is a way to dynamically add a table to a SQL database off of a button click coded in C#. I'm not asking for all of the code, I just need a small push in the right direction.

Thank you,
Ryan

You can write up some dynamic SQL in a proc passing the table name as parameter and create the table. But I would be concerned about letting users create objects on the fly. Can you explain more about the business logic? Do you have any process in place to clean up such tables on a periodic basis?

|||

Ok, well I am making a quiz engine and with this I want each client that makes an account on the website to be able to create, edit, and deploy their own quiz on my site. By allowing users to create their quiz in separate tables they will be able to easily edit their quiz because of the separate tables. If I mashed many quizzes into one table I feel it would get too unorganized. The number of quizzes/tables each user can make will be limited so a client cannot easily flood the database. An admin account will be able to edit and or delete every quiz made by any user as well.

Would you mind elaborating more on writing dynamic SQL like you said above. Maybe some code is required here because I'm not very experienced in anything SQL. I understand what you said, but I have no idea where to start.

|||

That doesnt sound like a very good design. You can create the records in one table and identify them by userId or username so when you have to pull out the records you can do so by username. Otherwise there will be LOT of dynamic SQL and it will make the server crawl.. because you dont know what table to select from.

This is an important read before you think of dynamic SQL:The Curse and Blessings of Dynamic SQL

|||

Thank you for pointing out the flaws in my design, I have taken your advice and will be calling rows based on each username. I've already had issues with my new way but I'll make a new post in the correct section. Thank you for the read as well.

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
>> >>
>>

Add a "print" button to Report Manager?

I know that there is a print button with RS 2.0, but is there a way to
add the button on the current version of report manager?
Thanks,
TrintSP2 will have the print functionality. It is coming out very soon, so
please keep an eye out for it in the next couple weeks to month or so.
--
| From: "trint" <trinity.smith@.gmail.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Add a "print" button to Report Manager'
| Date: 29 Mar 2005 04:25:25 -0800
| Organization: http://groups.google.com
| Lines: 5
| Message-ID: <1112099125.393374.154240@.o13g2000cwo.googlegroups.com>
| NNTP-Posting-Host: 65.244.90.165
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1112099129 1365 127.0.0.1 (29 Mar 2005
12:25:29 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Tue, 29 Mar 2005 12:25:29 +0000 (UTC)
| User-Agent: G2/0.2
| Complaints-To: groups-abuse@.google.com
| Injection-Info: o13g2000cwo.googlegroups.com; posting-host=65.244.90.165;
| posting-account=Ih-yCA0AAADzXymSlPU6JhcQ_cZnGStd
| Path:
TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news.glorb.com!postnews.google.com!o13g2000cwo.googlegroups.com!not-fo
r-mail
| Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:46347
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I know that there is a print button with RS 2.0, but is there a way to
| add the button on the current version of report manager?
| Thanks,
| Trint
|
|