I own a Windows Small Bussiness 2003 license which includes SQL server 2000
Standard Edition and additionally came with a version of Reporting Services.
I want to learn and use it (Reporting Services) as a beginner but when I
try to install it a message appears indicating that I need to install or
configure previously two products:
a) Visual Studio .Net 2003
b) IIS 5.0
Do I need both of 'em just to begin doing simple reports?
I supposed a simple use like I could obtain through Crystal reports 7.0 or
so on.
Please, help me.
Probably next year we will migrate to a new version of Microsoft SBS
Is it worth to do efforts with the versions I own nowadays or not?
Thanks alot in advance.
--
sanpetusRS 2000 report designer require some copy of VS 2003 to be installed. In the
past VB.net 2003 was the cheapest way to do this (about $100). I don't know
now. Note that the VB 2005 will not work for this.
In RS 2005 it comes with a version of VS 2005 so no additional purchase is
necessary.
RS is a asp.net application and as such it needs IIS. IIS comes with all
servers. It might need to configured though.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sanpetus" <sanpetus@.discussions.microsoft.com> wrote in message
news:14FE57B4-A059-4B0F-8539-C9D64CBAA6B6@.microsoft.com...
>I own a Windows Small Bussiness 2003 license which includes SQL server 2000
> Standard Edition and additionally came with a version of Reporting
> Services.
> I want to learn and use it (Reporting Services) as a beginner but when I
> try to install it a message appears indicating that I need to install or
> configure previously two products:
> a) Visual Studio .Net 2003
> b) IIS 5.0
> Do I need both of 'em just to begin doing simple reports?
> I supposed a simple use like I could obtain through Crystal reports 7.0 or
> so on.
> Please, help me.
> Probably next year we will migrate to a new version of Microsoft SBS
> Is it worth to do efforts with the versions I own nowadays or not?
> Thanks alot in advance.
> --
> sanpetus
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Able to install Report Server component on non-domain web svr?
Hello all,
We are looking at installing Reporting Services at our company here. We wish
to install the Report Server component on an IIS 6 web server that is on our
DMZ network, and hence not in our domain (where the SQL Server resides that
we want to put the RS database.) While reading BOL's "Selecting Components
of Reporting Services to Install" chapter, it notes: "IMPORTANT: Report
server and the SQL Server instance hosting the report server database must
be in the same domain or trusted domain." In our case, they would not be. Is
this a deal-killer, or has someone successfully implemented this type of
architecture out there? Any comments would be greatly appreciated.
TIA,
Will DennisOne solution would be to put the Report Server almost anywhere on your
internal network, then access it via web services on your Internet-facing
server.
Look at the Report Server Control example, just modify the URL parameter.
Jeff
"Willard Dennis" <wdennis@.bayada.com> wrote in message
news:#CgzKzJWEHA.1380@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> We are looking at installing Reporting Services at our company here. We
wish
> to install the Report Server component on an IIS 6 web server that is on
our
> DMZ network, and hence not in our domain (where the SQL Server resides
that
> we want to put the RS database.) While reading BOL's "Selecting Components
> of Reporting Services to Install" chapter, it notes: "IMPORTANT: Report
> server and the SQL Server instance hosting the report server database must
> be in the same domain or trusted domain." In our case, they would not be.
Is
> this a deal-killer, or has someone successfully implemented this type of
> architecture out there? Any comments would be greatly appreciated.
> TIA,
> Will Dennis
>
We are looking at installing Reporting Services at our company here. We wish
to install the Report Server component on an IIS 6 web server that is on our
DMZ network, and hence not in our domain (where the SQL Server resides that
we want to put the RS database.) While reading BOL's "Selecting Components
of Reporting Services to Install" chapter, it notes: "IMPORTANT: Report
server and the SQL Server instance hosting the report server database must
be in the same domain or trusted domain." In our case, they would not be. Is
this a deal-killer, or has someone successfully implemented this type of
architecture out there? Any comments would be greatly appreciated.
TIA,
Will DennisOne solution would be to put the Report Server almost anywhere on your
internal network, then access it via web services on your Internet-facing
server.
Look at the Report Server Control example, just modify the URL parameter.
Jeff
"Willard Dennis" <wdennis@.bayada.com> wrote in message
news:#CgzKzJWEHA.1380@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> We are looking at installing Reporting Services at our company here. We
wish
> to install the Report Server component on an IIS 6 web server that is on
our
> DMZ network, and hence not in our domain (where the SQL Server resides
that
> we want to put the RS database.) While reading BOL's "Selecting Components
> of Reporting Services to Install" chapter, it notes: "IMPORTANT: Report
> server and the SQL Server instance hosting the report server database must
> be in the same domain or trusted domain." In our case, they would not be.
Is
> this a deal-killer, or has someone successfully implemented this type of
> architecture out there? Any comments would be greatly appreciated.
> TIA,
> Will Dennis
>
Ability to load a TextBox with RichText ?
Is it possible (using SQL Server Reporting Services) to load a 'TextBox'
component with the contents of a RichText file (i.e. from a saved file
'testRpt.rtf') ?
Any suggestions would be appreciated.
Thanks in advance ...
SteveNo but yes I can solve your problem!
You can't get RTF text neatly formatted into a Reporting Services Textbox
control. - you could create a .NET function to strip the RTF content and
just display the raw text - but that's not what you really want is it?
So what you can do is create a .NET function in a custom assembly that you
pass the RTF into and have it return an image stream and what you then do is
bind that image data to a Reporting Services Image control.
(in the function you'll need to use the CreateGraphics() method.)
Hope that helps. If you need help on creating custom assemblies Chapter 9 of
our book does a great job showing how to progress and how to get Code Access
Security properly configured. We had intended to include the RTF example
but time and space meant that we didn't. I'll probably be doing an article
on this RTF example in the coming months in the Premium area of our web
site.
Peter Blackburn
www.sqlreportingservices.net
"Steve_S3T" <SteveS3T@.discussions.microsoft.com> wrote in message
news:BC061D8B-5FCC-4465-BE99-233BF1CFB292@.microsoft.com...
> Is it possible (using SQL Server Reporting Services) to load a 'TextBox'
> component with the contents of a RichText file (i.e. from a saved file
> 'testRpt.rtf') ?
> Any suggestions would be appreciated.
> Thanks in advance ...
> Steve|||Due to the fact that there's no direct route with this - I'm going to leave
it well alone. :(
Much least of all because I hate doing excessive coding if there's a more
direct approach - in this case I've found an alternate route via DataDynamics
ActiveReports - cue many groans ...
I'm still waiting on a copy of your book - it's been on order a while now.
I'll give that chapter a look through when the book finally gets to me ...
Steve
"Peter Blackburn (www.sqlreportingservice" wrote:
> No but yes I can solve your problem!
> You can't get RTF text neatly formatted into a Reporting Services Textbox
> control. - you could create a .NET function to strip the RTF content and
> just display the raw text - but that's not what you really want is it?
> So what you can do is create a .NET function in a custom assembly that you
> pass the RTF into and have it return an image stream and what you then do is
> bind that image data to a Reporting Services Image control.
> (in the function you'll need to use the CreateGraphics() method.)
> Hope that helps. If you need help on creating custom assemblies Chapter 9 of
> our book does a great job showing how to progress and how to get Code Access
> Security properly configured. We had intended to include the RTF example
> but time and space meant that we didn't. I'll probably be doing an article
> on this RTF example in the coming months in the Premium area of our web
> site.
> Peter Blackburn
> www.sqlreportingservices.net
>
>
> "Steve_S3T" <SteveS3T@.discussions.microsoft.com> wrote in message
> news:BC061D8B-5FCC-4465-BE99-233BF1CFB292@.microsoft.com...
> > Is it possible (using SQL Server Reporting Services) to load a 'TextBox'
> > component with the contents of a RichText file (i.e. from a saved file
> > 'testRpt.rtf') ?
> > Any suggestions would be appreciated.
> > Thanks in advance ...
> > Steve
>
>
component with the contents of a RichText file (i.e. from a saved file
'testRpt.rtf') ?
Any suggestions would be appreciated.
Thanks in advance ...
SteveNo but yes I can solve your problem!
You can't get RTF text neatly formatted into a Reporting Services Textbox
control. - you could create a .NET function to strip the RTF content and
just display the raw text - but that's not what you really want is it?
So what you can do is create a .NET function in a custom assembly that you
pass the RTF into and have it return an image stream and what you then do is
bind that image data to a Reporting Services Image control.
(in the function you'll need to use the CreateGraphics() method.)
Hope that helps. If you need help on creating custom assemblies Chapter 9 of
our book does a great job showing how to progress and how to get Code Access
Security properly configured. We had intended to include the RTF example
but time and space meant that we didn't. I'll probably be doing an article
on this RTF example in the coming months in the Premium area of our web
site.
Peter Blackburn
www.sqlreportingservices.net
"Steve_S3T" <SteveS3T@.discussions.microsoft.com> wrote in message
news:BC061D8B-5FCC-4465-BE99-233BF1CFB292@.microsoft.com...
> Is it possible (using SQL Server Reporting Services) to load a 'TextBox'
> component with the contents of a RichText file (i.e. from a saved file
> 'testRpt.rtf') ?
> Any suggestions would be appreciated.
> Thanks in advance ...
> Steve|||Due to the fact that there's no direct route with this - I'm going to leave
it well alone. :(
Much least of all because I hate doing excessive coding if there's a more
direct approach - in this case I've found an alternate route via DataDynamics
ActiveReports - cue many groans ...
I'm still waiting on a copy of your book - it's been on order a while now.
I'll give that chapter a look through when the book finally gets to me ...
Steve
"Peter Blackburn (www.sqlreportingservice" wrote:
> No but yes I can solve your problem!
> You can't get RTF text neatly formatted into a Reporting Services Textbox
> control. - you could create a .NET function to strip the RTF content and
> just display the raw text - but that's not what you really want is it?
> So what you can do is create a .NET function in a custom assembly that you
> pass the RTF into and have it return an image stream and what you then do is
> bind that image data to a Reporting Services Image control.
> (in the function you'll need to use the CreateGraphics() method.)
> Hope that helps. If you need help on creating custom assemblies Chapter 9 of
> our book does a great job showing how to progress and how to get Code Access
> Security properly configured. We had intended to include the RTF example
> but time and space meant that we didn't. I'll probably be doing an article
> on this RTF example in the coming months in the Premium area of our web
> site.
> Peter Blackburn
> www.sqlreportingservices.net
>
>
> "Steve_S3T" <SteveS3T@.discussions.microsoft.com> wrote in message
> news:BC061D8B-5FCC-4465-BE99-233BF1CFB292@.microsoft.com...
> > Is it possible (using SQL Server Reporting Services) to load a 'TextBox'
> > component with the contents of a RichText file (i.e. from a saved file
> > 'testRpt.rtf') ?
> > Any suggestions would be appreciated.
> > Thanks in advance ...
> > Steve
>
>
Sunday, March 25, 2012
A weird problem of Reporting Service
My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.
We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:
When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.
That means, the report is generated correctly, but we can't open it.
We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.
So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?
Thank you very much!
Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?that's because the server turns on the http compression, stupid IE doesn't understand it.
one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.
this just works fine for us
A weird problem of Reporting Service
My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.
We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:
When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.
That means, the report is generated correctly, but we can't open it.
We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.
So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?
Thank you very much!
Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?that's because the server turns on the http compression, stupid IE doesn't understand it.
one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.
this just works fine for us
A weird problem of Reporting Service
My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.
We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:
When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.
That means, the report is generated correctly, but we can't open it.
We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.
So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?
Thank you very much!
Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?that's because the server turns on the http compression, stupid IE doesn't understand it.
one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.
this just works fine for us
sql
Tuesday, March 20, 2012
A typo in the managed newsgroup URL
in MSDN managed newsgroup list:
http://msdn.microsoft.com/subscriptions/managednewsgroups/list.aspx
There is a typo in the URL for Reporting services Browser view.
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=micrsoft.public.sqlserver.reportingsvcs
Instead of microsoft, it's micrsoft. Thus results in a broken link.
Please fix it.
MichaelHi Michael,
Thanks for your kindly figuring this out and I have reported this typo and
hope it will be fixed soon :)
Thanks so much, once more.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
Just keep you update that it was fixed :-) and thanks again for your kindly
point it out.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
http://msdn.microsoft.com/subscriptions/managednewsgroups/list.aspx
There is a typo in the URL for Reporting services Browser view.
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=micrsoft.public.sqlserver.reportingsvcs
Instead of microsoft, it's micrsoft. Thus results in a broken link.
Please fix it.
MichaelHi Michael,
Thanks for your kindly figuring this out and I have reported this typo and
hope it will be fixed soon :)
Thanks so much, once more.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
Just keep you update that it was fixed :-) and thanks again for your kindly
point it out.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Sunday, February 19, 2012
A problem with a chart
Dear all,
I'm kinda new to reporting services and I have a small problem. Currently I'm using RS 2000, and I have a bar chart on my report. It displays names on the x-axis (I group by the name) and total number of hours on the y-axis (the value). I need to change that total number of hours with a percentage from the whole number of hours worked. My problem is I'm not capable of getting the total number of hours worked per all users since I'm grouping by users. How could I do that?
Any help regarding that issue is appreciated.You can calculate the total number of hours by using an aggregate function with an explicit scope name of the name of the chart reportitem. E.g.:
=Sum(Fields!Hours.Value, "chart1")
The percentage can be calculated as =Sum(Fields!Hours.Value) / Sum(Fields!Hours.Value, "chart1")
-- Robert
A problem with a chart
Dear all,
I'm kinda new to reporting services and I have a small problem. Currently I'm using RS 2000, and I have a bar chart on my report. It displays names on the x-axis (I group by the name) and total number of hours on the y-axis (the value). I need to change that total number of hours with a percentage from the whole number of hours worked. My problem is I'm not capable of getting the total number of hours worked per all users since I'm grouping by users. How could I do that?
Any help regarding that issue is appreciated.You can calculate the total number of hours by using an aggregate function with an explicit scope name of the name of the chart reportitem. E.g.:
=Sum(Fields!Hours.Value, "chart1")
The percentage can be calculated as =Sum(Fields!Hours.Value) / Sum(Fields!Hours.Value, "chart1")
-- Robert
A problem when opening PDF and EXCEL report
Hi, All
This is really weird. Here is the full story:
My company has a test site to test the application we are developing,
and the Reporting Server is on the same machine. Each developer has the
full application on their own machine so that they can test other parts
individually and check in to the test site later. But we are all using
the same webservice server (that test site machine) and the same report
database.
Now, when I run the report part locally, by locally, I mean I am
running the application in my own machine, but that application is
still loading the remote webservice to generate the report from the
remote database. The report generation is working correctly, I can open
the report and view.
But, if I run that part in the test site, it has a problem. It still
generates a report, but it will prompt a download window, and the
report extension name is always ASPX, (for pdf and excel file). If I
click Open, it will use Visual Studio to open it. If I click Save, and
change the extension name, it's a correct report.
More interesting, for PDF report, if the client machine has Adobe
Reader 7.0, it won't even prompt, instead, it would just show an empty
window, you know those empty windows, you can see the background
through that window, and if you move the window, the background will
follow. Yup, a kind of normal window. It only has that prompt window if
the client has Adobe Reader 6.0
Anyone has a clue how to solve this? Any help is appreciated, thank you
very much!
--
Best Regards!
SowenI saw this during the beta for 2005, but it cleared up once I went with the
released version of 2005. Has this machine ever had the beta on it?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139930602.042085.322510@.f14g2000cwb.googlegroups.com...
> Hi, All
> This is really weird. Here is the full story:
> My company has a test site to test the application we are developing,
> and the Reporting Server is on the same machine. Each developer has the
> full application on their own machine so that they can test other parts
> individually and check in to the test site later. But we are all using
> the same webservice server (that test site machine) and the same report
> database.
> Now, when I run the report part locally, by locally, I mean I am
> running the application in my own machine, but that application is
> still loading the remote webservice to generate the report from the
> remote database. The report generation is working correctly, I can open
> the report and view.
> But, if I run that part in the test site, it has a problem. It still
> generates a report, but it will prompt a download window, and the
> report extension name is always ASPX, (for pdf and excel file). If I
> click Open, it will use Visual Studio to open it. If I click Save, and
> change the extension name, it's a correct report.
> More interesting, for PDF report, if the client machine has Adobe
> Reader 7.0, it won't even prompt, instead, it would just show an empty
> window, you know those empty windows, you can see the background
> through that window, and if you move the window, the background will
> follow. Yup, a kind of normal window. It only has that prompt window if
> the client has Adobe Reader 6.0
> Anyone has a clue how to solve this? Any help is appreciated, thank you
> very much!
> --
> Best Regards!
> Sowen
>|||hi, Bruce
thanks for your reply.
But we are still using VS 2003, SQL 2000 and .NET framework 1.1|||Ahh, OK. What Service Pack are you on?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139933336.752696.258260@.g44g2000cwa.googlegroups.com...
> hi, Bruce
> thanks for your reply.
> But we are still using VS 2003, SQL 2000 and .NET framework 1.1
>|||for reporting service, SP2
for 2003 server, SP1,|||How are your viewing the report? In your own app? Report Manager? If your
own app are you using URL integration or web services? If in your own app,
does it work properly when you use Report Manager?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139934523.097245.13230@.g44g2000cwa.googlegroups.com...
> for reporting service, SP2
> for 2003 server, SP1,
>|||via URL. sth like
http://localhost/mmis/ReportViewer/tabid/140/desktopdefault/+/Default.aspx,
(we are using DNN too.)
the code generating the report is correct.
It works properly if I run all application on my own machine's IIS.
It only has those problems if I run it on our test site (remotely)|||OK, I think what is happening is the Server 2003 internet security. Try
putting in the name of the machine instead of localhost and add the local
machine to the safezone.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139936364.847940.143500@.g44g2000cwa.googlegroups.com...
> via URL. sth like
> http://localhost/mmis/ReportViewer/tabid/140/desktopdefault/+/Default.aspx,
> (we are using DNN too.)
> the code generating the report is correct.
> It works properly if I run all application on my own machine's IIS.
> It only has those problems if I run it on our test site (remotely)
>|||do you mean adding our test site url in IE security trusted site?|||Here is what I suggest you do. Go to the test server. Open up IE and go to
report manager and make sure your reports and exports etc work as you they
should. Until you know it all works from report manager I wouldn't waste
much time wondering why it isn't working from your app. My guess is that you
will see some of the same issues there. Windows 2003 SP1 really protects
what web sites you can go to. You most likely need to add to trusted sites
in IE on the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139937391.453464.226010@.z14g2000cwz.googlegroups.com...
> do you mean adding our test site url in IE security trusted site?
>|||it works on our test site.
It is frustrated that the same code actually works on our another
remote test site, I just found out.
Is there any security configuration issue I should pay attention to?
It's strange that the same thing working on one machine but not another
machine.|||I mean it works on the test site report manager. I can see everything
running properly. But I have the same problem if I run the ASP.NET
program to create the PDF or EXCEL report, the prompt window asks me to
download a ASPX file.
But if I run the same code on another test machine, there is no such a
problem.
strange...
This is really weird. Here is the full story:
My company has a test site to test the application we are developing,
and the Reporting Server is on the same machine. Each developer has the
full application on their own machine so that they can test other parts
individually and check in to the test site later. But we are all using
the same webservice server (that test site machine) and the same report
database.
Now, when I run the report part locally, by locally, I mean I am
running the application in my own machine, but that application is
still loading the remote webservice to generate the report from the
remote database. The report generation is working correctly, I can open
the report and view.
But, if I run that part in the test site, it has a problem. It still
generates a report, but it will prompt a download window, and the
report extension name is always ASPX, (for pdf and excel file). If I
click Open, it will use Visual Studio to open it. If I click Save, and
change the extension name, it's a correct report.
More interesting, for PDF report, if the client machine has Adobe
Reader 7.0, it won't even prompt, instead, it would just show an empty
window, you know those empty windows, you can see the background
through that window, and if you move the window, the background will
follow. Yup, a kind of normal window. It only has that prompt window if
the client has Adobe Reader 6.0
Anyone has a clue how to solve this? Any help is appreciated, thank you
very much!
--
Best Regards!
SowenI saw this during the beta for 2005, but it cleared up once I went with the
released version of 2005. Has this machine ever had the beta on it?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139930602.042085.322510@.f14g2000cwb.googlegroups.com...
> Hi, All
> This is really weird. Here is the full story:
> My company has a test site to test the application we are developing,
> and the Reporting Server is on the same machine. Each developer has the
> full application on their own machine so that they can test other parts
> individually and check in to the test site later. But we are all using
> the same webservice server (that test site machine) and the same report
> database.
> Now, when I run the report part locally, by locally, I mean I am
> running the application in my own machine, but that application is
> still loading the remote webservice to generate the report from the
> remote database. The report generation is working correctly, I can open
> the report and view.
> But, if I run that part in the test site, it has a problem. It still
> generates a report, but it will prompt a download window, and the
> report extension name is always ASPX, (for pdf and excel file). If I
> click Open, it will use Visual Studio to open it. If I click Save, and
> change the extension name, it's a correct report.
> More interesting, for PDF report, if the client machine has Adobe
> Reader 7.0, it won't even prompt, instead, it would just show an empty
> window, you know those empty windows, you can see the background
> through that window, and if you move the window, the background will
> follow. Yup, a kind of normal window. It only has that prompt window if
> the client has Adobe Reader 6.0
> Anyone has a clue how to solve this? Any help is appreciated, thank you
> very much!
> --
> Best Regards!
> Sowen
>|||hi, Bruce
thanks for your reply.
But we are still using VS 2003, SQL 2000 and .NET framework 1.1|||Ahh, OK. What Service Pack are you on?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139933336.752696.258260@.g44g2000cwa.googlegroups.com...
> hi, Bruce
> thanks for your reply.
> But we are still using VS 2003, SQL 2000 and .NET framework 1.1
>|||for reporting service, SP2
for 2003 server, SP1,|||How are your viewing the report? In your own app? Report Manager? If your
own app are you using URL integration or web services? If in your own app,
does it work properly when you use Report Manager?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139934523.097245.13230@.g44g2000cwa.googlegroups.com...
> for reporting service, SP2
> for 2003 server, SP1,
>|||via URL. sth like
http://localhost/mmis/ReportViewer/tabid/140/desktopdefault/+/Default.aspx,
(we are using DNN too.)
the code generating the report is correct.
It works properly if I run all application on my own machine's IIS.
It only has those problems if I run it on our test site (remotely)|||OK, I think what is happening is the Server 2003 internet security. Try
putting in the name of the machine instead of localhost and add the local
machine to the safezone.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139936364.847940.143500@.g44g2000cwa.googlegroups.com...
> via URL. sth like
> http://localhost/mmis/ReportViewer/tabid/140/desktopdefault/+/Default.aspx,
> (we are using DNN too.)
> the code generating the report is correct.
> It works properly if I run all application on my own machine's IIS.
> It only has those problems if I run it on our test site (remotely)
>|||do you mean adding our test site url in IE security trusted site?|||Here is what I suggest you do. Go to the test server. Open up IE and go to
report manager and make sure your reports and exports etc work as you they
should. Until you know it all works from report manager I wouldn't waste
much time wondering why it isn't working from your app. My guess is that you
will see some of the same issues there. Windows 2003 SP1 really protects
what web sites you can go to. You most likely need to add to trusted sites
in IE on the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139937391.453464.226010@.z14g2000cwz.googlegroups.com...
> do you mean adding our test site url in IE security trusted site?
>|||it works on our test site.
It is frustrated that the same code actually works on our another
remote test site, I just found out.
Is there any security configuration issue I should pay attention to?
It's strange that the same thing working on one machine but not another
machine.|||I mean it works on the test site report manager. I can see everything
running properly. But I have the same problem if I run the ASP.NET
program to create the PDF or EXCEL report, the prompt window asks me to
download a ASPX file.
But if I run the same code on another test machine, there is no such a
problem.
strange...
Thursday, February 16, 2012
A probable dumb question.
Does anyone know if you can run SQL 2005 Reporting Services on a SQL2000
Server? I want certain features of RS2005, but we are not ready to upgrade
SQL.Yes. That is how I am running. Just pick Reporting Services only when
upgrading. SQL Server will be left at 2000. You do need a 2005 license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:eK5uQFN7FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Does anyone know if you can run SQL 2005 Reporting Services on a SQL2000
> Server? I want certain features of RS2005, but we are not ready to upgrade
> SQL.
>
Server? I want certain features of RS2005, but we are not ready to upgrade
SQL.Yes. That is how I am running. Just pick Reporting Services only when
upgrading. SQL Server will be left at 2000. You do need a 2005 license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:eK5uQFN7FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Does anyone know if you can run SQL 2005 Reporting Services on a SQL2000
> Server? I want certain features of RS2005, but we are not ready to upgrade
> SQL.
>
A newbie to Reporting Services seeking advice
I have been a long time Crystal Reports user but now due to a new
application, I want to switch over to SQL Server Reporting Services.
My question is whether I can do what I want with Reporting services.
My app is a 2 tier winforms app. The client will query the database through
a VPN. The database is a SQL Server 2005 database. Can my app call reports
located in a directory on the server and display them in a viewer in my app
and then the client either prints to their local machine or saves to file
ex. pdf file? The client does have an IIS server running on the same
machine as the database.
BillIf I understand your question correctly, yes, you can host a server-
based report inside of a client app and also output them to PDF by
using the ReportViewer control.
Start here: http://www.gotreportviewer.com/
On Apr 14, 12:44 am, "BillG" <billgo...@.charter.net> wrote:
> I have been a long time Crystal Reports user but now due to a new
> application, I want to switch over to SQL Server Reporting Services.
> My question is whether I can do what I want with Reporting services.
> My app is a 2 tier winforms app. The client will query the database through
> a VPN. The database is a SQL Server 2005 database. Can my app call reports
> located in a directory on the server and display them in a viewer in my app
> and then the client either prints to their local machine or saves to file
> ex. pdf file? The client does have an IIS server running on the same
> machine as the database.
> Bill
application, I want to switch over to SQL Server Reporting Services.
My question is whether I can do what I want with Reporting services.
My app is a 2 tier winforms app. The client will query the database through
a VPN. The database is a SQL Server 2005 database. Can my app call reports
located in a directory on the server and display them in a viewer in my app
and then the client either prints to their local machine or saves to file
ex. pdf file? The client does have an IIS server running on the same
machine as the database.
BillIf I understand your question correctly, yes, you can host a server-
based report inside of a client app and also output them to PDF by
using the ReportViewer control.
Start here: http://www.gotreportviewer.com/
On Apr 14, 12:44 am, "BillG" <billgo...@.charter.net> wrote:
> I have been a long time Crystal Reports user but now due to a new
> application, I want to switch over to SQL Server Reporting Services.
> My question is whether I can do what I want with Reporting services.
> My app is a 2 tier winforms app. The client will query the database through
> a VPN. The database is a SQL Server 2005 database. Can my app call reports
> located in a directory on the server and display them in a viewer in my app
> and then the client either prints to their local machine or saves to file
> ex. pdf file? The client does have an IIS server running on the same
> machine as the database.
> Bill
Saturday, February 11, 2012
A little help IIF
Hi all,
I have to rewrite a few reports from Cognos to Reporting Services. I was
hoping someone could help me with some of it. Does the "IN" work in reporting
services? The error code I get is [BC30455] Argument not specified for
parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart
As Object, FalsePart As Object) As Object'.
I can not figure out what else it could be besides the IN. Is there something
else I can use?
=IIF( Fields!COST_ELEM_CTGY.Value ="G", "2G&AC",
(IIF( Fields!COST_ELEM_CTGY.Value IN "C", "P", "R", "V", "X"), "3OTHERS"),
(IIF( Parameters!WBSPrompt.Value = "W",
"1WBS")),
(IIF( Fields!COST_ELEM_CTGY.Value = "O" ,
"1OTHER",
"1FUNCTION")))
Thanks in Advanced,
Kerrie
--
Message posted via http://www.sqlmonster.comReporting service uses VB.net so the switch function or the choose
should work. Switch can be set up to return any object, Choose returns
an index. The msdn examples for these functions are:
Function MatchUp (CityName As String) As String
Return Microsoft.VisualBasic.Switch(CityName = "London", "English",
_
CityName = "Rome", "Italian", CityName = "Paris", "French")
End Function
Function GetChoice(Ind As Integer) As String
GetChoice = CStr(Choose(Ind, "Speedy", "United", "Federal"))
End Function
I have to rewrite a few reports from Cognos to Reporting Services. I was
hoping someone could help me with some of it. Does the "IN" work in reporting
services? The error code I get is [BC30455] Argument not specified for
parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart
As Object, FalsePart As Object) As Object'.
I can not figure out what else it could be besides the IN. Is there something
else I can use?
=IIF( Fields!COST_ELEM_CTGY.Value ="G", "2G&AC",
(IIF( Fields!COST_ELEM_CTGY.Value IN "C", "P", "R", "V", "X"), "3OTHERS"),
(IIF( Parameters!WBSPrompt.Value = "W",
"1WBS")),
(IIF( Fields!COST_ELEM_CTGY.Value = "O" ,
"1OTHER",
"1FUNCTION")))
Thanks in Advanced,
Kerrie
--
Message posted via http://www.sqlmonster.comReporting service uses VB.net so the switch function or the choose
should work. Switch can be set up to return any object, Choose returns
an index. The msdn examples for these functions are:
Function MatchUp (CityName As String) As String
Return Microsoft.VisualBasic.Switch(CityName = "London", "English",
_
CityName = "Rome", "Italian", CityName = "Paris", "French")
End Function
Function GetChoice(Ind As Integer) As String
GetChoice = CStr(Choose(Ind, "Speedy", "United", "Federal"))
End Function
A List Of Issues with Reporting Services
A few work-mates attended a 2-day hands-on lab/workshop on Reporting
Services, and according to them these were the issues presented by the
trainer := 1) RS is still in its infancy, unstable , unsuitable and unreliable for
enterprise deployments
2) Could turn into a long drawn-out development and product support times
3)The Report Designer is Error-prone, inadequate means of doing functions
4)For the average user to design a report, they require a Visual STudio .Net
2003 license.
Would someone please clarify these issues for us, please '
with kind regards
Paul Matthews
paul.matthews@.dhs.vic.gov.auIt's probably not very productive to make overly general statements like
these.
There may be problems with RS. But it is still a fantastic product. For many
types of reports, at least the ones I've tried, these statements--with the
exception of 4)--are certainly not true. The fact a lot of people have
started using it and moving it into production has led me to concentrate on
figuring out how to support the product. My overall experience has been
postive so far.
Linchi
"Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> Services, and according to them these were the issues presented by the
> trainer :=> 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> enterprise deployments
> 2) Could turn into a long drawn-out development and product support times
> 3)The Report Designer is Error-prone, inadequate means of doing functions
> 4)For the average user to design a report, they require a Visual STudio
.Net
> 2003 license.
> Would someone please clarify these issues for us, please '
> with kind regards
> Paul Matthews
> paul.matthews@.dhs.vic.gov.au|||Hi,
These are not my opinions and not my statements.
According to few people who attended a 2-day workshop,
this is the "impression" the trainer gave them.
For my part, I have really enjoyed using RS,
and I am determined to learn more about RS
but I just needed some clarification , re these issues, that have been
raised, since I am no expert on RS.
We are in the process of deciding on reporting tools, so any clarification
on these issues would be of great help to us.
Regards
Paul
"Linchi Shea" wrote:
> It's probably not very productive to make overly general statements like
> these.
> There may be problems with RS. But it is still a fantastic product. For many
> types of reports, at least the ones I've tried, these statements--with the
> exception of 4)--are certainly not true. The fact a lot of people have
> started using it and moving it into production has led me to concentrate on
> figuring out how to support the product. My overall experience has been
> postive so far.
> Linchi
> "Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
> news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> > A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> > Services, and according to them these were the issues presented by the
> > trainer :=> > 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> > enterprise deployments
> > 2) Could turn into a long drawn-out development and product support times
> > 3)The Report Designer is Error-prone, inadequate means of doing functions
> > 4)For the average user to design a report, they require a Visual STudio
> ..Net
> > 2003 license.
> >
> > Would someone please clarify these issues for us, please '
> >
> > with kind regards
> > Paul Matthews
> > paul.matthews@.dhs.vic.gov.au
>
>|||Paul,
I wish I was on that lab/workshop...You don't mention it but how much real
life experience the trainer had with RS? Did he swear in Crystal I wonder
:-)
Anyway, please find my comments inline for whatever they are worth for.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> Services, and according to them these were the issues presented by the
> trainer :=> 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> enterprise deployments
Teo: We had quite a number of RS-based enterprise-level projects at HP and
our experience is entirely positive. I wonder what alternative the trainer
has suggested if RS is not an option?
> 2) Could turn into a long drawn-out development and product support times
Teo: As with everything new, there is a learning curve involved. Product
support times - example, please?
> 3)The Report Designer is Error-prone, inadequate means of doing functions
Teo: Again, example please? RS can integrate with native and custom .NET
assemblies, which means that you can leverage the full power of .NET. Is
this inadequate?
> 4)For the average user to design a report, they require a Visual STudio
.Net
> 2003 license.
Teo: Using the VS.NET Report Designer is one and perhaps the most popular
option of authoring reports. You can use third-party tools, author RDL
programatically, etc. BTW, you don't have to buy the whole VS.NET stack to
get the Report Designer. Instead, you can purchase only VB.NET. How must is
this: $90? Can we compare this with the cost of other so called enterprise
reporting tools? Finally, the next version of RS will not require VS.NET
since you will be able to author reports in the SQL Server 2005 Development
Studio.
> Would someone please clarify these issues for us, please '
> with kind regards
> Paul Matthews
> paul.matthews@.dhs.vic.gov.au|||1) RS is still in its infancy, unstable , unsuitable and unreliable for
enterprise deployments
boy SOMEBODY needs to tell the corporations which have already deployed
it successfully in an enterprise environment that it doesn't work!
2) Could turn into a long drawn-out development and product support times
have no idea what this means
3)The Report Designer is Error-prone, inadequate means of doing functions
no major errors here that we have seen. But yes you must be
'programmer' oriented to do anything but the simplest reports
4)For the average user to design a report, they require a Visual STudio
.Net
2003 license.
YES
"Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> Services, and according to them these were the issues presented by the
> trainer :=> 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> enterprise deployments
> 2) Could turn into a long drawn-out development and product support times
> 3)The Report Designer is Error-prone, inadequate means of doing functions
> 4)For the average user to design a report, they require a Visual STudio
.Net
> 2003 license.
> Would someone please clarify these issues for us, please '
> with kind regards
> Paul Matthews
> paul.matthews@.dhs.vic.gov.au|||To add something else, the main issue I have seen is people that have a set
idea on how they want to solve the problem instead of solving it a different
way. There are many Crystal Report users that are ecstatic over switching.
Others who it totally bums them that something CR does you can't do (or
can't do in the same way).
If you want to integrate into an existing ASP.net site then between URL
integration and web services you can do very tight and seamless (to the
user) integration. Integrated security works great (a big issue with
Enterprise reporting). Drill through is extemely easy and powerful.
I have been live since the end of the beta. A few issues but nothing I
couldn't work around. I at first had my "server" a PC runing 2000 Pro and I
had some stability issues. Since I moved it to a Windows 2003 Server machine
all the stability issues have gone away.
As far as stability of the development environment. I have never crashed it
and lost any work so I don't know what the guy is talking about.
As far as doing functions. The code behind is very easy to do, it just does
not have integrated debugging of the code behind in the report. I tend to
create another Winapp with a button to test out the code before I cut and
paste it. But the real point here is that you will find that there is very
little need to embed any custom code. The expression support includes a lot
of vb.net libraries built in and usually I can solve issues with expressions
and no need for custom coding.
If you have anybody that is a dotnet programmer then you can have your own
custom assemblys that can be called.
The trainers sound to me like they haven't used it and don't know the
product.
Bruce L-C
"Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> Services, and according to them these were the issues presented by the
> trainer :=> 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> enterprise deployments
> 2) Could turn into a long drawn-out development and product support times
> 3)The Report Designer is Error-prone, inadequate means of doing functions
> 4)For the average user to design a report, they require a Visual STudio
.Net
> 2003 license.
> Would someone please clarify these issues for us, please '
> with kind regards
> Paul Matthews
> paul.matthews@.dhs.vic.gov.au
Services, and according to them these were the issues presented by the
trainer := 1) RS is still in its infancy, unstable , unsuitable and unreliable for
enterprise deployments
2) Could turn into a long drawn-out development and product support times
3)The Report Designer is Error-prone, inadequate means of doing functions
4)For the average user to design a report, they require a Visual STudio .Net
2003 license.
Would someone please clarify these issues for us, please '
with kind regards
Paul Matthews
paul.matthews@.dhs.vic.gov.auIt's probably not very productive to make overly general statements like
these.
There may be problems with RS. But it is still a fantastic product. For many
types of reports, at least the ones I've tried, these statements--with the
exception of 4)--are certainly not true. The fact a lot of people have
started using it and moving it into production has led me to concentrate on
figuring out how to support the product. My overall experience has been
postive so far.
Linchi
"Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> Services, and according to them these were the issues presented by the
> trainer :=> 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> enterprise deployments
> 2) Could turn into a long drawn-out development and product support times
> 3)The Report Designer is Error-prone, inadequate means of doing functions
> 4)For the average user to design a report, they require a Visual STudio
.Net
> 2003 license.
> Would someone please clarify these issues for us, please '
> with kind regards
> Paul Matthews
> paul.matthews@.dhs.vic.gov.au|||Hi,
These are not my opinions and not my statements.
According to few people who attended a 2-day workshop,
this is the "impression" the trainer gave them.
For my part, I have really enjoyed using RS,
and I am determined to learn more about RS
but I just needed some clarification , re these issues, that have been
raised, since I am no expert on RS.
We are in the process of deciding on reporting tools, so any clarification
on these issues would be of great help to us.
Regards
Paul
"Linchi Shea" wrote:
> It's probably not very productive to make overly general statements like
> these.
> There may be problems with RS. But it is still a fantastic product. For many
> types of reports, at least the ones I've tried, these statements--with the
> exception of 4)--are certainly not true. The fact a lot of people have
> started using it and moving it into production has led me to concentrate on
> figuring out how to support the product. My overall experience has been
> postive so far.
> Linchi
> "Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
> news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> > A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> > Services, and according to them these were the issues presented by the
> > trainer :=> > 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> > enterprise deployments
> > 2) Could turn into a long drawn-out development and product support times
> > 3)The Report Designer is Error-prone, inadequate means of doing functions
> > 4)For the average user to design a report, they require a Visual STudio
> ..Net
> > 2003 license.
> >
> > Would someone please clarify these issues for us, please '
> >
> > with kind regards
> > Paul Matthews
> > paul.matthews@.dhs.vic.gov.au
>
>|||Paul,
I wish I was on that lab/workshop...You don't mention it but how much real
life experience the trainer had with RS? Did he swear in Crystal I wonder
:-)
Anyway, please find my comments inline for whatever they are worth for.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> Services, and according to them these were the issues presented by the
> trainer :=> 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> enterprise deployments
Teo: We had quite a number of RS-based enterprise-level projects at HP and
our experience is entirely positive. I wonder what alternative the trainer
has suggested if RS is not an option?
> 2) Could turn into a long drawn-out development and product support times
Teo: As with everything new, there is a learning curve involved. Product
support times - example, please?
> 3)The Report Designer is Error-prone, inadequate means of doing functions
Teo: Again, example please? RS can integrate with native and custom .NET
assemblies, which means that you can leverage the full power of .NET. Is
this inadequate?
> 4)For the average user to design a report, they require a Visual STudio
.Net
> 2003 license.
Teo: Using the VS.NET Report Designer is one and perhaps the most popular
option of authoring reports. You can use third-party tools, author RDL
programatically, etc. BTW, you don't have to buy the whole VS.NET stack to
get the Report Designer. Instead, you can purchase only VB.NET. How must is
this: $90? Can we compare this with the cost of other so called enterprise
reporting tools? Finally, the next version of RS will not require VS.NET
since you will be able to author reports in the SQL Server 2005 Development
Studio.
> Would someone please clarify these issues for us, please '
> with kind regards
> Paul Matthews
> paul.matthews@.dhs.vic.gov.au|||1) RS is still in its infancy, unstable , unsuitable and unreliable for
enterprise deployments
boy SOMEBODY needs to tell the corporations which have already deployed
it successfully in an enterprise environment that it doesn't work!
2) Could turn into a long drawn-out development and product support times
have no idea what this means
3)The Report Designer is Error-prone, inadequate means of doing functions
no major errors here that we have seen. But yes you must be
'programmer' oriented to do anything but the simplest reports
4)For the average user to design a report, they require a Visual STudio
.Net
2003 license.
YES
"Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> Services, and according to them these were the issues presented by the
> trainer :=> 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> enterprise deployments
> 2) Could turn into a long drawn-out development and product support times
> 3)The Report Designer is Error-prone, inadequate means of doing functions
> 4)For the average user to design a report, they require a Visual STudio
.Net
> 2003 license.
> Would someone please clarify these issues for us, please '
> with kind regards
> Paul Matthews
> paul.matthews@.dhs.vic.gov.au|||To add something else, the main issue I have seen is people that have a set
idea on how they want to solve the problem instead of solving it a different
way. There are many Crystal Report users that are ecstatic over switching.
Others who it totally bums them that something CR does you can't do (or
can't do in the same way).
If you want to integrate into an existing ASP.net site then between URL
integration and web services you can do very tight and seamless (to the
user) integration. Integrated security works great (a big issue with
Enterprise reporting). Drill through is extemely easy and powerful.
I have been live since the end of the beta. A few issues but nothing I
couldn't work around. I at first had my "server" a PC runing 2000 Pro and I
had some stability issues. Since I moved it to a Windows 2003 Server machine
all the stability issues have gone away.
As far as stability of the development environment. I have never crashed it
and lost any work so I don't know what the guy is talking about.
As far as doing functions. The code behind is very easy to do, it just does
not have integrated debugging of the code behind in the report. I tend to
create another Winapp with a button to test out the code before I cut and
paste it. But the real point here is that you will find that there is very
little need to embed any custom code. The expression support includes a lot
of vb.net libraries built in and usually I can solve issues with expressions
and no need for custom coding.
If you have anybody that is a dotnet programmer then you can have your own
custom assemblys that can be called.
The trainers sound to me like they haven't used it and don't know the
product.
Bruce L-C
"Paul Matthews" <Paul Matthews@.discussions.microsoft.com> wrote in message
news:A7BD2838-F26E-4188-B397-4546475742A1@.microsoft.com...
> A few work-mates attended a 2-day hands-on lab/workshop on Reporting
> Services, and according to them these were the issues presented by the
> trainer :=> 1) RS is still in its infancy, unstable , unsuitable and unreliable for
> enterprise deployments
> 2) Could turn into a long drawn-out development and product support times
> 3)The Report Designer is Error-prone, inadequate means of doing functions
> 4)For the average user to design a report, they require a Visual STudio
.Net
> 2003 license.
> Would someone please clarify these issues for us, please '
> with kind regards
> Paul Matthews
> paul.matthews@.dhs.vic.gov.au
Thursday, February 9, 2012
A good book to start with
I am not a very begginer with sql server and I am familiar with some
concepts in sql server like DTS packages,Reporting services and database
objects .I'd like to start learning OLAP and data mining and I just wondered
if somebody can give me a path and introduce me a good book to start with.
Thanks
RayRayAll wrote:
"I'd like to start learning OLAP and data mining and I just wondered if
somebody can give me a path and introduce me a good book to start
with."
I recommend any of the following:
"Data Mining: Concepts and Techniques"
by Jiawei Han, Micheline Kamber
ISBN: 1558604898
"Data Mining : Practical Machine Learning Tools and Techniques"
by Ian H. Witten, Eibe Frank
ISBN: 0120884070, 1558605525
"Predictive Data Mining : A Practical Guide"
by Sholom M. Weiss, Nitin Indurkhya
ISBN: 1558604030
"Solving Data Mining Problems Through Pattern Recognition"
by Ruby L. Kennedy et al
ISBN: 0130950831
-Will Dwinnell
http://will.dwinnell.com|||A more basic and general view (recommended) is:
- MS Olap Unleashed (right, for SQL 7, but pretty usefull)
- MDX Solutions, George Spofford
Michael
"RayAll" <RayAll@.microsft.com> escribi en el mensaje
news:emNYRu8LFHA.1308@.TK2MSFTNGP15.phx.gbl...
>I am not a very begginer with sql server and I am familiar with some
>concepts in sql server like DTS packages,Reporting services and database
>objects .I'd like to start learning OLAP and data mining and I just
>wondered if somebody can give me a path and introduce me a good book to
>start with.
> Thanks
> Ray
>|||Again, back with SQL7, but very good, try Erik Thompsen's book
Microsoft OLAP Solutions
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MPS" <mps@.udd.cl> wrote in message
news:uyTcyRIMFHA.1300@.TK2MSFTNGP10.phx.gbl...
> A more basic and general view (recommended) is:
> - MS Olap Unleashed (right, for SQL 7, but pretty usefull)
> - MDX Solutions, George Spofford
> Michael
> "RayAll" <RayAll@.microsft.com> escribi en el mensaje
> news:emNYRu8LFHA.1308@.TK2MSFTNGP15.phx.gbl...
>
>|||Another really good book that'll get your thinking started in the right way:
Fast Track to MDX
Mark Whitehorn, Robert Zare and Mosha Pasumansky
"RayAll" <RayAll@.microsft.com> wrote in message
news:emNYRu8LFHA.1308@.TK2MSFTNGP15.phx.gbl...
>I am not a very begginer with sql server and I am familiar with some
>concepts in sql server like DTS packages,Reporting services and database
>objects .I'd like to start learning OLAP and data mining and I just
>wondered if somebody can give me a path and introduce me a good book to
>start with.
> Thanks
> Ray
>
concepts in sql server like DTS packages,Reporting services and database
objects .I'd like to start learning OLAP and data mining and I just wondered
if somebody can give me a path and introduce me a good book to start with.
Thanks
RayRayAll wrote:
"I'd like to start learning OLAP and data mining and I just wondered if
somebody can give me a path and introduce me a good book to start
with."
I recommend any of the following:
"Data Mining: Concepts and Techniques"
by Jiawei Han, Micheline Kamber
ISBN: 1558604898
"Data Mining : Practical Machine Learning Tools and Techniques"
by Ian H. Witten, Eibe Frank
ISBN: 0120884070, 1558605525
"Predictive Data Mining : A Practical Guide"
by Sholom M. Weiss, Nitin Indurkhya
ISBN: 1558604030
"Solving Data Mining Problems Through Pattern Recognition"
by Ruby L. Kennedy et al
ISBN: 0130950831
-Will Dwinnell
http://will.dwinnell.com|||A more basic and general view (recommended) is:
- MS Olap Unleashed (right, for SQL 7, but pretty usefull)
- MDX Solutions, George Spofford
Michael
"RayAll" <RayAll@.microsft.com> escribi en el mensaje
news:emNYRu8LFHA.1308@.TK2MSFTNGP15.phx.gbl...
>I am not a very begginer with sql server and I am familiar with some
>concepts in sql server like DTS packages,Reporting services and database
>objects .I'd like to start learning OLAP and data mining and I just
>wondered if somebody can give me a path and introduce me a good book to
>start with.
> Thanks
> Ray
>|||Again, back with SQL7, but very good, try Erik Thompsen's book
Microsoft OLAP Solutions
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MPS" <mps@.udd.cl> wrote in message
news:uyTcyRIMFHA.1300@.TK2MSFTNGP10.phx.gbl...
> A more basic and general view (recommended) is:
> - MS Olap Unleashed (right, for SQL 7, but pretty usefull)
> - MDX Solutions, George Spofford
> Michael
> "RayAll" <RayAll@.microsft.com> escribi en el mensaje
> news:emNYRu8LFHA.1308@.TK2MSFTNGP15.phx.gbl...
>
>|||Another really good book that'll get your thinking started in the right way:
Fast Track to MDX
Mark Whitehorn, Robert Zare and Mosha Pasumansky
"RayAll" <RayAll@.microsft.com> wrote in message
news:emNYRu8LFHA.1308@.TK2MSFTNGP15.phx.gbl...
>I am not a very begginer with sql server and I am familiar with some
>concepts in sql server like DTS packages,Reporting services and database
>objects .I'd like to start learning OLAP and data mining and I just
>wondered if somebody can give me a path and introduce me a good book to
>start with.
> Thanks
> Ray
>
A Few Questions
We are looking at RS2005 as a possible reporting tool, and trying to figure
out a few things with not much luck, so I'll try asking here. The questions:
1. How can you hit multiple data sources within one data set?
We have cases where we want to take information from two different
databases, say a MS SQL and an Oracle, and join information from these two
into one dataset, is this possible and if so how?
2. How do you a new field within the report set?
Say in one of the fields (call it field x) being returned you want to create
another field (call it field y) and populate it with a certain set of
values. For example, if field x = "A" then we want to populate field y with
a value of 10. If field x = "F" then we want to populate field y with a
value of 15.
3. How do you deal with multiple selects in one statement. Example TYPE in
(10,20,30,70,90)?
In Reporting services you would have to use multiple OR statements. This
would be bad if we had a lot of other inclusions or exclusions.
ThanksOn Mar 16, 9:22 am, "Nobody" <trin...@.nobody.com> wrote:
> We are looking at RS2005 as a possible reporting tool, and trying to figure
> out a few things with not much luck, so I'll try asking here. The questions:
> 1. How can you hit multiple data sources within one data set?
> We have cases where we want to take information from two different
> databases, say a MS SQL and an Oracle, and join information from these two
> into one dataset, is this possible and if so how?
> 2. How do you a new field within the report set?
> Say in one of the fields (call it field x) being returned you want to create
> another field (call it field y) and populate it with a certain set of
> values. For example, if field x = "A" then we want to populate field y with
> a value of 10. If field x = "F" then we want to populate field y with a
> value of 15.
> 3. How do you deal with multiple selects in one statement. Example TYPE in
> (10,20,30,70,90)?
> In Reporting services you would have to use multiple OR statements. This
> would be bad if we had a lot of other inclusions or exclusions.
> Thanks
1. Refer to Amarnath's response on a previous post concerning this
question:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9dc8aa59b6f9271f/d54db9f92d839b88?lnk=gst&q=oracle+sql+server&rnum=2#d54db9f92d839b88
2. For field y, in Layout view, select field y, right-click it and
select 'Expression...' in the Edit Expression dialog, enter in either
of the following:
=switch(Fields!x.Value = "A", 10, Fields!x.Value = "F", 15, true, 0)
-or-
=iif(Fields!x.Value = "A", 10, 15)
3. This question is not very clear to me. So I'll do the best I can
here:
In the report query the SQL syntax should be: select ... from ...
where TYPE in (10,20,30,70,90)
In the report in general, a multi-select parameter can be used for the
TYPE options and use a temporary table, while loop (or cursor) and
keyword 'patindex' (in the report stored procedure/query) to parse the
values in the multi-select parameter that is returned. The results
should be put into a temp table and then 'select ... from ... where
TYPE in (select TYPE from #TempTable)' should do the trick.
Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thanks, I'll pass that on to the person here that had those questions.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1174103874.201065.41030@.n76g2000hsh.googlegroups.com...
> 1. Refer to Amarnath's response on a previous post concerning this
> question:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9dc8aa59b6f9271f/d54db9f92d839b88?lnk=gst&q=oracle+sql+server&rnum=2#d54db9f92d839b88
> 2. For field y, in Layout view, select field y, right-click it and
> select 'Expression...' in the Edit Expression dialog, enter in either
> of the following:
> =switch(Fields!x.Value = "A", 10, Fields!x.Value = "F", 15, true, 0)
> -or-
> =iif(Fields!x.Value = "A", 10, 15)
> 3. This question is not very clear to me. So I'll do the best I can
> here:
> In the report query the SQL syntax should be: select ... from ...
> where TYPE in (10,20,30,70,90)
> In the report in general, a multi-select parameter can be used for the
> TYPE options and use a temporary table, while loop (or cursor) and
> keyword 'patindex' (in the report stored procedure/query) to parse the
> values in the multi-select parameter that is returned. The results
> should be put into a temp table and then 'select ... from ... where
> TYPE in (select TYPE from #TempTable)' should do the trick.
> Hope this is helpful.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>
out a few things with not much luck, so I'll try asking here. The questions:
1. How can you hit multiple data sources within one data set?
We have cases where we want to take information from two different
databases, say a MS SQL and an Oracle, and join information from these two
into one dataset, is this possible and if so how?
2. How do you a new field within the report set?
Say in one of the fields (call it field x) being returned you want to create
another field (call it field y) and populate it with a certain set of
values. For example, if field x = "A" then we want to populate field y with
a value of 10. If field x = "F" then we want to populate field y with a
value of 15.
3. How do you deal with multiple selects in one statement. Example TYPE in
(10,20,30,70,90)?
In Reporting services you would have to use multiple OR statements. This
would be bad if we had a lot of other inclusions or exclusions.
ThanksOn Mar 16, 9:22 am, "Nobody" <trin...@.nobody.com> wrote:
> We are looking at RS2005 as a possible reporting tool, and trying to figure
> out a few things with not much luck, so I'll try asking here. The questions:
> 1. How can you hit multiple data sources within one data set?
> We have cases where we want to take information from two different
> databases, say a MS SQL and an Oracle, and join information from these two
> into one dataset, is this possible and if so how?
> 2. How do you a new field within the report set?
> Say in one of the fields (call it field x) being returned you want to create
> another field (call it field y) and populate it with a certain set of
> values. For example, if field x = "A" then we want to populate field y with
> a value of 10. If field x = "F" then we want to populate field y with a
> value of 15.
> 3. How do you deal with multiple selects in one statement. Example TYPE in
> (10,20,30,70,90)?
> In Reporting services you would have to use multiple OR statements. This
> would be bad if we had a lot of other inclusions or exclusions.
> Thanks
1. Refer to Amarnath's response on a previous post concerning this
question:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9dc8aa59b6f9271f/d54db9f92d839b88?lnk=gst&q=oracle+sql+server&rnum=2#d54db9f92d839b88
2. For field y, in Layout view, select field y, right-click it and
select 'Expression...' in the Edit Expression dialog, enter in either
of the following:
=switch(Fields!x.Value = "A", 10, Fields!x.Value = "F", 15, true, 0)
-or-
=iif(Fields!x.Value = "A", 10, 15)
3. This question is not very clear to me. So I'll do the best I can
here:
In the report query the SQL syntax should be: select ... from ...
where TYPE in (10,20,30,70,90)
In the report in general, a multi-select parameter can be used for the
TYPE options and use a temporary table, while loop (or cursor) and
keyword 'patindex' (in the report stored procedure/query) to parse the
values in the multi-select parameter that is returned. The results
should be put into a temp table and then 'select ... from ... where
TYPE in (select TYPE from #TempTable)' should do the trick.
Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thanks, I'll pass that on to the person here that had those questions.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1174103874.201065.41030@.n76g2000hsh.googlegroups.com...
> 1. Refer to Amarnath's response on a previous post concerning this
> question:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9dc8aa59b6f9271f/d54db9f92d839b88?lnk=gst&q=oracle+sql+server&rnum=2#d54db9f92d839b88
> 2. For field y, in Layout view, select field y, right-click it and
> select 'Expression...' in the Edit Expression dialog, enter in either
> of the following:
> =switch(Fields!x.Value = "A", 10, Fields!x.Value = "F", 15, true, 0)
> -or-
> =iif(Fields!x.Value = "A", 10, 15)
> 3. This question is not very clear to me. So I'll do the best I can
> here:
> In the report query the SQL syntax should be: select ... from ...
> where TYPE in (10,20,30,70,90)
> In the report in general, a multi-select parameter can be used for the
> TYPE options and use a temporary table, while loop (or cursor) and
> keyword 'patindex' (in the report stored procedure/query) to parse the
> values in the multi-select parameter that is returned. The results
> should be put into a temp table and then 'select ... from ... where
> TYPE in (select TYPE from #TempTable)' should do the trick.
> Hope this is helpful.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>
A few questions
Hello all:
We have recently adopted this platform for our reporting. A couple of
issues I am having:
1. We would like the grouped columns to start on the same row as the parent,
so that there is not a break before the grouped items begin. Any way to do
this?
2. Our parameters include a boolean representing a column's visibility. I
am having trouble showing and hiding columns and having the table appear
correctly. If I set the column visibility to an expression it does hid ethe
contents of the column, but not the column itself. Any ideas?
Thanks a lot.
MikeI figured out solutions to both of these problems, but am still working on
some issues:
1. I actually place the coulmn values in the parent group and then in the
details level I wrote a visibility expression that checked if the row number
was the first in that group and if it was I set it's visibility to hidden.
=Iif(RowNumber("GROUPNAME") = 1,true,false)
2. Setting the columns visibility does hide the column (I simply had some
sort of error in my visibility expression), but a) the line borders still
exist if you have a border around a table, and b) the space remains and the
columns do not resize to fill the page, thus leaving an ugly space in the
report.. I am working on ways to deal with this. Any ideas would be
useful.
3. There seems to be differences in the PDF rendering in Acrobat 5.0 and
Acrobat 6.0. Especially when it comes to line thicknesses. Has anyone had
these problems?
Mike
"Michael Solomons" <mikesolo@.optonline.net> wrote in message
news:eCuh8$1YEHA.3016@.tk2msftngp13.phx.gbl...
> Hello all:
> We have recently adopted this platform for our reporting. A couple of
> issues I am having:
> 1. We would like the grouped columns to start on the same row as the
parent,
> so that there is not a break before the grouped items begin. Any way to
do
> this?
> 2. Our parameters include a boolean representing a column's visibility. I
> am having trouble showing and hiding columns and having the table appear
> correctly. If I set the column visibility to an expression it does hid
ethe
> contents of the column, but not the column itself. Any ideas?
> Thanks a lot.
> Mike
>
We have recently adopted this platform for our reporting. A couple of
issues I am having:
1. We would like the grouped columns to start on the same row as the parent,
so that there is not a break before the grouped items begin. Any way to do
this?
2. Our parameters include a boolean representing a column's visibility. I
am having trouble showing and hiding columns and having the table appear
correctly. If I set the column visibility to an expression it does hid ethe
contents of the column, but not the column itself. Any ideas?
Thanks a lot.
MikeI figured out solutions to both of these problems, but am still working on
some issues:
1. I actually place the coulmn values in the parent group and then in the
details level I wrote a visibility expression that checked if the row number
was the first in that group and if it was I set it's visibility to hidden.
=Iif(RowNumber("GROUPNAME") = 1,true,false)
2. Setting the columns visibility does hide the column (I simply had some
sort of error in my visibility expression), but a) the line borders still
exist if you have a border around a table, and b) the space remains and the
columns do not resize to fill the page, thus leaving an ugly space in the
report.. I am working on ways to deal with this. Any ideas would be
useful.
3. There seems to be differences in the PDF rendering in Acrobat 5.0 and
Acrobat 6.0. Especially when it comes to line thicknesses. Has anyone had
these problems?
Mike
"Michael Solomons" <mikesolo@.optonline.net> wrote in message
news:eCuh8$1YEHA.3016@.tk2msftngp13.phx.gbl...
> Hello all:
> We have recently adopted this platform for our reporting. A couple of
> issues I am having:
> 1. We would like the grouped columns to start on the same row as the
parent,
> so that there is not a break before the grouped items begin. Any way to
do
> this?
> 2. Our parameters include a boolean representing a column's visibility. I
> am having trouble showing and hiding columns and having the table appear
> correctly. If I set the column visibility to an expression it does hid
ethe
> contents of the column, but not the column itself. Any ideas?
> Thanks a lot.
> Mike
>
Subscribe to:
Posts (Atom)