Thursday, March 29, 2012
Drawing line between table rows and columns
Drawing Circles and line and text note in report
would ask. In MS Word, you are able to select an option to â'drawâ' a line or
object on the screen. thought that it would be useful to allow a user to add
a circle or line and a text note to the report prior to printing it. I want
to know whether this is possibleExample: if I wanted to circle the name of
one employee on the report before printing it.
Is this possible with the SQL report writer?
Thanks!Currently there is no feature in RS for users to be able to modify the report in anyway after the report is generated, but would like to have this feature in the later versions.
>--Original Message--
>I am not sure if this is possible with the reporting tool, but I thought I >would ask. In MS Word, you are able to select an option to =E2?odraw=E2?=9D a line or >object on the screen. thought that it would be useful to allow a user to add >a circle or line and a text note to the report prior to printing it. I want >to know whether this is possibleExample: if I wanted to circle the name of >one employee on the report before printing it.
>Is this possible with the SQL report writer?
> >Thanks!
> >
>.
>
Draw Horizontal Line at Threshold
percentage and the report is sorted in ascending order by this
percentage. I want to draw a single red horizontal line at a
threshold, let's say 95% so that any record lower than 95% would be
above the line and any record higher would be below the line. How can
I do this?On Apr 4, 6:54 am, robertpet...@.hotmail.com wrote:
> I have a table in reporting services. I have a field that calcuates a
> percentage and the report is sorted in ascending order by this
> percentage. I want to draw a single red horizontal line at a
> threshold, let's say 95% so that any record lower than 95% would be
> above the line and any record higher would be below the line. How can
> I do this?
I would suggest adding an extra query/stored procedure return field/
column to include in the report that is used as a flag for the
percentages. Have the flag set for the minimum row at or above 95%.
Then in the report, set the table properties (F4) (BorderColor->Top
and BorderStyle->Top) according to that flag. Something like these
expressions should work:
For BorderColor:Top:
=iif(Fields!Flag.Value = 1, "Red", "White")
For BorderStyle:Top:
=iif(Fields!Flag.Value = 1, "Solid", "None")
Hope this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultantsql
Tuesday, March 27, 2012
Downloading sql server 2005
I am a beginner who downloaded Microsoft SQL server 2005 (for reporting services) to my Windows XP Professional (32-bit systems), but it asks me to install the service packs as well...
Its confusing to know which ones... So Windows XP Service Pack 2 is already installed.
I could not find Windows 2000 Service Pack 4 for my version though.
Downloaded Windows Server 2003 Service Pack 1, which requires Windows Server 2003 as well... true?
Do I also need Asp.net and IIS?
I would be very grateful for some help... to clarify which components needed.
With your setup you need to:
1. Install IIS and .net 2.0
2. Install SQL Server 2005 Developer or Standard edition. The Developer edition has all features of the Enterprise edition and can run on Windows XP.
Downloading RS
Hello,
I have SQL Server Standard installed in one of our Windows Server 2003, where should I request or download real version of Reporting Services? I do not want to install trial version to avoid re-installation in the future.
Thanks,
You need a minimum of SQL Server Developer edition for RS|||Yes, but even more than that - you have to "fill in" a form and MS will send the CD to you for a "full" production version of MSRS!This is the only way I know of in order to get a full licensed copy of MSRS - and not have to worry about the "trial" version!
I have made numerous post about this exact topic - but the "moderator" keeps rejecting! - but -
Since it is a "lucky" Irish day -
Best Regards
Downloading Reporting services
I have downloaded an eval version of Reporting services
from microsoft.com . But the file is corrupted and will
not run on my pc. Can any one help where can I get the
latest and greatest version other than microsoft.com ?
Thanks a lot for your help.
- SThis link details how you can get a version of RS besides downloading.
What problem were you seeing running the downloaded version?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sunil" <sunilor@.hotmail.com> wrote in message
news:244801c49cc6$44b5cf80$a401280a@.phx.gbl...
> Hello,
> I have downloaded an eval version of Reporting services
> from microsoft.com . But the file is corrupted and will
> not run on my pc. Can any one help where can I get the
> latest and greatest version other than microsoft.com ?
>
> Thanks a lot for your help.
> - S|||Forgot to post the link. :)
http://www.microsoft.com/sql/reporting/howtobuy/default.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sunil" <sunilor@.hotmail.com> wrote in message
news:244801c49cc6$44b5cf80$a401280a@.phx.gbl...
> Hello,
> I have downloaded an eval version of Reporting services
> from microsoft.com . But the file is corrupted and will
> not run on my pc. Can any one help where can I get the
> latest and greatest version other than microsoft.com ?
>
> Thanks a lot for your help.
> - S
Sunday, March 25, 2012
Download/Install SQL RS 2005 Alone--not the whole chunk of SQL2005
Is there anywhere that I could download trial version of SQL 2005 Reporting
services alone...not the whole junk of SQL Server 2005. I need just the
Reporting services. another question is I have SQL 2005 Developer Edition
CTP(community tchnology preview) DVD and I am looking at a way to upgrade
only reporting services from 2000 to 2005.But the set up wont let me do just
that. It insists that I upgrade the server also. Please let me know!!!Hi,
You can only download the complete package of SQL Server 2005 and I believe
it will be by its release. Reporting Service 2005 is a part of SQL Server
2005. Compare it to the Analysis Server part: you can't download it seperate
from the SQL Server part.
For your upgrading problem: Maybe it is a 'feature' of the CTP install,
haven't tried it this way. But you could try to install the SQL Server 2005
at a new instance and make SRS to install/upgrade at the instance of the 2000
version.
Hope this would help you.
Jan Pieter Posthuma
"Balaji" wrote:
> Hey all,
> Is there anywhere that I could download trial version of SQL 2005 Reporting
> services alone...not the whole junk of SQL Server 2005. I need just the
> Reporting services. another question is I have SQL 2005 Developer Edition
> CTP(community tchnology preview) DVD and I am looking at a way to upgrade
> only reporting services from 2000 to 2005.But the set up wont let me do just
> that. It insists that I upgrade the server also. Please let me know!!!
>
Download Windows server
I am confused ...downloaded Microsoft SQL server 2005 (for reporting services) to my Windows 2002 (32-bit systems), but it asks me to install the service packs as well...
So Windows XP Service Pack 2 is already installed.
And I need to download Windows server 2000 or 2003 R2, but where could I find a free trial version?
Do I also need Asp.net and IIS?
I would be very grateful for some help... to clarify which components needed.
Since you're wanting RS, you'll need to install SQL Server Express with Advanced Services. Here's the link:
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
This product is supported on XP SP2, so you won't need to do any OS upgrades.
Thanks,
Sam Lester (MSFT)
I get the following answer though "Your OS does nor support the Service Pack required for this SQL server release."
So my OS is 2002...
How do I check which SP required?
I did not find any .net Framework 2.0 SP.|||I managed to download SQL Server 2005 Express Edition with Advanced
Services SP1, and noticed Reporting services are available but how about "Analysis services" ?
|||
Analysis Services does not ship with any of the Express SKUs. It is part of the other SKUs (Enterprise, Standard, etc). If you want to play around with it, you can download the evaluation version found here:
http://www.microsoft.com/sql/downloads/trial-software.mspx
Thanks,
Sam Lester (MSFT)
Download SQL Reporting Services
Yes, I had license of MS SQL Server 2000"sam" <samuellai@.ajikl.com.my> wrote in message
news:eBacSBsgFHA.3692@.TK2MSFTNGP09.phx.gbl...
> Where can I download SQL Server 2000 Reporting Service?
> Yes, I had license of MS SQL Server 2000
>
I downloaded it through my company's MSDN Subscription. I checked
Microsoft's website, the only version available there is the evaluation
version. Kind of silly, really, to have a product that you might not have to
license, but it's not available in an easy way...
Anyway, the evaluation edition is here:
http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en
Maybe you can email MS Customer support and ask for it?
Kaisa M. Lindahl|||Just be aware, the evaluation version can't be upgraded - it has to be
reinstalled. And yes you do have to download the full version via your
MSDN subscription or contact Microsoft if you don't.
Chris
Kaisa M. Lindahl wrote:
> "sam" <samuellai@.ajikl.com.my> wrote in message
> news:eBacSBsgFHA.3692@.TK2MSFTNGP09.phx.gbl...
> > Where can I download SQL Server 2000 Reporting Service?
> >
> > Yes, I had license of MS SQL Server 2000
> >
> I downloaded it through my company's MSDN Subscription. I checked
> Microsoft's website, the only version available there is the
> evaluation version. Kind of silly, really, to have a product that you
> might not have to license, but it's not available in an easy way...
> Anyway, the evaluation edition is here:
> http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F
> -4BC7-84AF-149B7637F807&displaylang=en
> Maybe you can email MS Customer support and ask for it?
> Kaisa M. Lindahl
Download Reporting Services for SQL 2000?
page was the 120-days trial for Reporting Service and SP1, SP2.
http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
Is there a place to download the release version instead of the 120 days
trial?
Thanks!
AlbertAlbert,
See
http://www.microsoft.com/sql/reporting/howtobuy/default.mspx#XSLTsection132121120120
for the information you need.
As far as I am aware there is no download option for a non-time
limited version of RS2000.
Andrew Watt
MVP - InfoPath
On Thu, 6 Oct 2005 09:35:07 -0700, Albert
<Albert@.discussions.microsoft.com> wrote:
>We have license for SQL 2000 but all I can find on the Microsoft download
>page was the 120-days trial for Reporting Service and SP1, SP2.
>http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
>Is there a place to download the release version instead of the 120 days
>trial?
>Thanks!
>Albert|||Thanks a lot!
Albert
"Andrew Watt [MVP - InfoPath]" wrote:
> Albert,
> See
> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx#XSLTsection132121120120
> for the information you need.
> As far as I am aware there is no download option for a non-time
> limited version of RS2000.
> Andrew Watt
> MVP - InfoPath
> On Thu, 6 Oct 2005 09:35:07 -0700, Albert
> <Albert@.discussions.microsoft.com> wrote:
> >We have license for SQL 2000 but all I can find on the Microsoft download
> >page was the 120-days trial for Reporting Service and SP1, SP2.
> >
> >http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
> >
> >Is there a place to download the release version instead of the 120 days
> >trial?
> >
> >Thanks!
> >
> >Albert
>|||If you are an MSDN Subscriber, you should be able to download it through the
MSDN Subscriber downloads. It's stored under Server -> SQL Server -> SQL
Server 2000 -> SQL Server 2000 Reporting Services. You can also download SP
1 and 2 from the same place.
It might depend on what subscription level you are on, but if your company
is a subscriber, check it out.
Kaisa M. Lindahl
"Albert" <Albert@.discussions.microsoft.com> wrote in message
news:7509ED44-FE5C-4BBA-B22E-7143B9EAE224@.microsoft.com...
> We have license for SQL 2000 but all I can find on the Microsoft download
> page was the 120-days trial for Reporting Service and SP1, SP2.
> http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
> Is there a place to download the release version instead of the 120 days
> trial?
> Thanks!
> Albert
Download Reporting Services
I have SQL Server 2000 . where I can download Reporting Services and how to install it? because in microsoft.com all explanations are very confused.
thanks
You can download Evaluation Edition and SP2:
SQL Server 2000 Reporting Services Evaluation Edition
SQL Server 2000 Reporting Services Service Pack 2 (SP2)
For SQL Server 2000 Reporting Services installation CD please contact your local Microsoft sales office
download many rdl files from Reporting Server at once
we have uploaded a large number of rdl files on the reporting server. now
when we want to download these files we have to download it one by one.
is there any efficient way to download a large number of files in one shot.
Downloading files one by one makes it too time consuming. So it wud be great
if u can help me out to download all the rdl files at once
I looked in the report manager but no such option is avaliable other than
saving a single file and editing it.
help wud be highy appreciated.
RajivPYou have to use the GetReportDefinition method of the RS Web Service to do
this. There is a sample of how to do this in the documentation. Search for
GetReportDefinition. There is no way I know of doing this from the interface.
Charles Kangai, MCT, MCDBA
"rajivp" wrote:
> GoodDay,
> we have uploaded a large number of rdl files on the reporting server. now
> when we want to download these files we have to download it one by one.
> is there any efficient way to download a large number of files in one shot.
> Downloading files one by one makes it too time consuming. So it wud be great
> if u can help me out to download all the rdl files at once
> I looked in the report manager but no such option is avaliable other than
> saving a single file and editing it.
> help wud be highy appreciated.
> RajivP
Thursday, March 22, 2012
download location
We'd like to get access to Reporting Services for SQL2k. Where can I
download? (all i can find is the download to the trial)Did you get any response on this
I'm in the same boat, I can find the Service Packs, but I can't find the
base software.
Any direction will be much appreciated.
"john doe" wrote:
> We own SQL 2000 Std server license.
> We'd like to get access to Reporting Services for SQL2k. Where can I
> download? (all i can find is the download to the trial)
>
>
Download link still available for SQL Server 2000 Reporting Services from my SQL 2000?
I can't seem to find the download link for SQL Server 2000 Reporting
Services from my SQL 2000. Where is it? I feel like an idiot.
--
SpinI don't recall anything other than the Evaluation Edition ever being
downloadable from http://www.microsoft.com but you can find all the SQL
Server 2000 Reporting Services downloads at
http://www.microsoft.com/sql/technologies/reporting/downloads.mspx,
including the Evaluation Edition.
--
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478crcFeau66U1@.individual.net...
> Hi,
> I can't seem to find the download link for SQL Server 2000 Reporting
> Services from my SQL 2000. Where is it? I feel like an idiot.
> --
> Spin
>
Download link still available for SQL Server 2000 Reporting Services from my SQL 2000?
I can't seem to find the download link for SQL Server 2000 Reporting
Services from my SQL 2000. Where is it? I feel like an idiot.
Spin
I don't recall anything other than the Evaluation Edition ever being
downloadable from http://www.microsoft.com but you can find all the SQL
Server 2000 Reporting Services downloads at
http://www.microsoft.com/sql/technol...ownloads.mspx,
including the Evaluation Edition.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478crcFeau66U1@.individual.net...
> Hi,
> I can't seem to find the download link for SQL Server 2000 Reporting
> Services from my SQL 2000. Where is it? I feel like an idiot.
> --
> Spin
>
Download link still available for SQL Server 2000 Reporting Services from my SQL 2000?
I can't seem to find the download link for SQL Server 2000 Reporting
Services from my SQL 2000. Where is it? I feel like an idiot.
SpinI don't recall anything other than the Evaluation Edition ever being
downloadable from http://www.microsoft.com but you can find all the SQL
Server 2000 Reporting Services downloads at
http://www.microsoft.com/sql/techno...downloads.mspx,
including the Evaluation Edition.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478crcFeau66U1@.individual.net...
> Hi,
> I can't seem to find the download link for SQL Server 2000 Reporting
> Services from my SQL 2000. Where is it? I feel like an idiot.
> --
> Spin
>sql
Download a report from Reporting Services.
Hi,
I have a report that′s already in the reporting service (2000 and 2005 - both systems), that I need edit in order to make some changes, but the person who did the report already deleted the source. I only have the one that had been uploaded to the reporting services. In there i only see an option to upload the report, but not to download.
Is there any way that i can download the report from the reporting services?
Thanks.
Yes, you can download the .RDL file using the "Edit" link on the Report Manager report properties page, the SOAP API method GetReportDefinition, and in Management Studio by right-clicking on the report and selecting "Edit Report".
Keep in mind that the RDL you get out of the server will be exactly the RDL you last published, but it will NOT include changes made to data sources and parameters after the RDL was published.
Sunday, March 11, 2012
Double Sided?
I am using SQL Reporting Services 2000 - is it possible to make a report that prints double sided?This has nothing to do with report settings. This is a printer setting. If it supports double sided priniting then reporting services reports can be printed double sided.|||Hi, yes the printer does support duplex printing, but I can't see how to make a report that prints on two sides.
Double Line border turn to be single in Reporting Service
Thank you for your post, Lev. I just tried that. But it seems not working even I set borderwidth to 5pt. I found double line is OK only when exporting to excel. Does anyone else have the same issue with me?
|||What version of RS are you using? Are you viewing the PDF at 100% zoom? It should work with a width of >3pt.
Thank you.
|||Dear Donovan,
I tried again after your reply. It did work this time. There must be somewhere wrong while I did my test yesterday.
Thank both of you, Lev & Donovan!
Cheers!
|||I am having the exact same problem. I am using RS2005. I set the bottom border to double. I have tried changing the border width and this just makes the single line that is displayed thicker. If I export to Excel, I can see the double line, otherwise in preview, pdf, etc, I only see the single line. Any other ideas?|||Could this be the result of border clipping? Is the report item you placed the double border on inside of another item? A border starts at the edge of a report item and extends out half the width on each side of this edge. If the item with a border is contained inside another item, any of the border that extends beyond the bounds of that container will be clipped. In this way, a double border will appear to show only a single border if half of it is clipped.
If that's not the case, would you please either post a simple demonstration RDL to this thread or open a bug on http://connect.microsoft.com so I can take a look?
Thank you.
|||It looks like the border is being "clipped off". I am using a matrix to display the data. The very last row of the matrix is where I am attempting to set the bottom border as double. If I add another row below this one, the double border is displayed correctly.Double Line border turn to be single in Reporting Service
Thank you for your post, Lev. I just tried that. But it seems not working even I set borderwidth to 5pt. I found double line is OK only when exporting to excel. Does anyone else have the same issue with me?
|||What version of RS are you using? Are you viewing the PDF at 100% zoom? It should work with a width of >3pt.
Thank you.
|||Dear Donovan,
I tried again after your reply. It did work this time. There must be somewhere wrong while I did my test yesterday.
Thank both of you, Lev & Donovan!
Cheers!
|||I am having the exact same problem. I am using RS2005. I set the bottom border to double. I have tried changing the border width and this just makes the single line that is displayed thicker. If I export to Excel, I can see the double line, otherwise in preview, pdf, etc, I only see the single line. Any other ideas?|||Could this be the result of border clipping? Is the report item you placed the double border on inside of another item? A border starts at the edge of a report item and extends out half the width on each side of this edge. If the item with a border is contained inside another item, any of the border that extends beyond the bounds of that container will be clipped. In this way, a double border will appear to show only a single border if half of it is clipped.
If that's not the case, would you please either post a simple demonstration RDL to this thread or open a bug on http://connect.microsoft.com so I can take a look?
Thank you.
|||It looks like the border is being "clipped off". I am using a matrix to display the data. The very last row of the matrix is where I am attempting to set the bottom border as double. If I add another row below this one, the double border is displayed correctly.