Determine what version of RS is insalled

How do you determine what version of Reporting Services is installed int the DB and Web server ( I have the DB on a different server than the Web server)

Thanks

Try typing
http://localhost/Reportserver

Determine what ver/SP is installed for Reporting Services

How can you tell what version of Reporting Services is installed?Just run the url http://localhost/ReportServer or
http://<hostname>/ReportServer|||That is where to look, however I didn't know what the numbers meant. I
found this in another thread:
base install = 743
sp1 = 878
sp2 = 1042|||If you run the url. at the bottom it will display the version information
like following
Microsoft SQL Server Reporting Services Version 8.00.1038.00sql

Determine slow running reports

I've been tasked with optimizing our reporting environment and want to
target the worst performers first. The problem is that our reports are
published directly to the reporting server by reporting analysts
throughout the organization so I have very little knowled as to what's
out there, who uses them, etc. Is there a way to query reporting
services to determine historical exectuion times? IOW, give me the top
10 reports ordered by avg exectuion time descending or something of
that nature.In your data source defenition - instead of single query use a stored
procedure or just type in something like that:
declare @.start smalldatetime
declare @.end smalldatetime
set @.start = getdate()
-- your query
set @.end=getdate()
-- and at the end log the execution time like that
insert logtable values (reportname, username, getdate(), @.end-@.start)
"Randy Knight" <knight.randy@.gmail.com> wrote in message
news:1128523651.640818.14420@.o13g2000cwo.googlegroups.com...
> I've been tasked with optimizing our reporting environment and want to
> target the worst performers first. The problem is that our reports are
> published directly to the reporting server by reporting analysts
> throughout the organization so I have very little knowled as to what's
> out there, who uses them, etc. Is there a way to query reporting
> services to determine historical exectuion times? IOW, give me the top
> 10 reports ordered by avg exectuion time descending or something of
> that nature.
>|||That would be great if I had control of the reports but as I said, the
reports are published by analysts from all over the company. I just
wondered if RS put some statistics or anything like that in the
ReportServer database. It would seem to be useful ... how many times
report is run, avg execution times, etc.
Guess I'll resort to good ol' SQL Profiler :)|||SQL 2005 has just what you need... You must install the samples from the SQL
install CD.. This will give you a directory in program files/microsoft sql
server 2005/Report samples/Server management Samples. --
THe directions are included... You can get all kinds of performance related
reports, who runs what, how long it takes, how many times each report has
been run...
Hope this helps
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Randy Knight" wrote:
> I've been tasked with optimizing our reporting environment and want to
> target the worst performers first. The problem is that our reports are
> published directly to the reporting server by reporting analysts
> throughout the organization so I have very little knowled as to what's
> out there, who uses them, etc. Is there a way to query reporting
> services to determine historical exectuion times? IOW, give me the top
> 10 reports ordered by avg exectuion time descending or something of
> that nature.
>

Determine month from inside month row grouping

Hi guys,

i have a matrix that has two row groups, the first is month, the next is year. This is for year on year reporting, so the first two cells in each row are like this:

April 2005

April 2006

April 2007

May 2005

May 2006

May 2007

etc

in one of the columns of the matrix, i need to calculate a "per hour" figure, so i need to determine how many hours are in the month that groups this row.

So what i need to know is: how can i tell what month this row is? I don't care if the month is represented as text ("April") or an int (4), because the pseudo code for the expression will be:

<monthly dollar amount> / (24 * DateDiff("d", CDate("2006-<this month>-01"), DateAdd("M", CDate("2006-<this month>-01"), 1)))

Thanks for any suggestions!

sluggy

Duh, that was a stupid question... the answer was just to use the month dataset member as per usual This was the final expression for getting the number of hours in the month:

24 * DateDiff("d", CDate("2006-" + Fields!Calendar_Month.Value + "01"), DateAdd("M", 1, CDate("2006-" + Fields!Calendar_Month.Value + "01")))

Determine Edition in Reporting Services 2000

This may be a simple question, but I need to determine which edition of
Reporting Services I have installed on my SQL Server 2000 server. I have
already confirmed that I am running Enterprise Edition for SQL Server itself,
but cannot find anything that will give me version/edition information for
Reporting Services.
Any help would be greatly appreciated.
Daniel InmanNow I feel stupid. All you need to do is go into Add/Remove programs.
"Daniel Inman" wrote:
> This may be a simple question, but I need to determine which edition of
> Reporting Services I have installed on my SQL Server 2000 server. I have
> already confirmed that I am running Enterprise Edition for SQL Server itself,
> but cannot find anything that will give me version/edition information for
> Reporting Services.
> Any help would be greatly appreciated.
> Daniel Inman
>|||An even simpler alternative is to go to the following url:
http://rsservername/reportserver/
Of course, replace "rsservername" with the real name of your Reporting
Services Server. You'll see the version number at the bottom of that
screen.
Daniel Inman wrote:
> Now I feel stupid. All you need to do is go into Add/Remove programs.
> "Daniel Inman" wrote:
> > This may be a simple question, but I need to determine which edition of
> > Reporting Services I have installed on my SQL Server 2000 server. I have
> > already confirmed that I am running Enterprise Edition for SQL Server itself,
> > but cannot find anything that will give me version/edition information for
> > Reporting Services.
> >
> > Any help would be greatly appreciated.
> >
> > Daniel Inman
> >sql

Detailed error reporting. How to?

The best I can get out of my detail log is this which is no help. How do I find out what really happened. My windows app log is no help either

Date 5/24/2006 9:51:41 PM
Log Job History (DTS_xx)

Step ID 1
Server xx
Job Name DTS_xx
Step Name DTS_xx
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: xx\administrator. The package execution failed. The step failed.

This KB article discusses various options:
http://support.microsoft.com/kb/918760|||

Michael - I'm glad your online right now. All that I'm trying to do is run stored procs on my database. My ssis package uses the correct login but I keep getting the error I posted. This was running fine on my 2000 box.

So I tried a few other things. I recreated the package on my production server and it works. Seems to be the problem is when I move it from my dev box to production its loosing something.

desperate for help! PLEASE!

I installed the reporting service and everytime I start a new porject in
visual studio .net, I get a message saying that it is unable to load the
RSReportDesigner.config file.
I can't find any help online and I can't get into the beta newsgroup...
HELP PLEASE.
Thanks.
EmadI found out what was the problem. The evaluation version does NOT work on
windows XP only 2000. Strange!!!!
-Emad
"Emad Ibrahim" <iemad@.nospam.hotmail.com> wrote in message
news:uOw3uKI4DHA.632@.TK2MSFTNGP12.phx.gbl...
> I installed the reporting service and everytime I start a new porject in
> visual studio .net, I get a message saying that it is unable to load the
> RSReportDesigner.config file.
> I can't find any help online and I can't get into the beta newsgroup...
> HELP PLEASE.
> Thanks.
> Emad
>

desperate for help! PLEASE!

I installed the reporting service and everytime I start a new porject in
visual studio .net, I get a message saying that it is unable to load the
RSReportDesigner.config file.
I can't find any help online and I can't get into the beta newsgroup...
HELP PLEASE.
Thanks.
EmadI found out what was the problem. The evaluation version does NOT work on
windows XP only 2000. Strange!!!!
-Emad
"Emad Ibrahim" <iemad@.nospam.hotmail.com> wrote in message
news:uOw3uKI4DHA.632@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I installed the reporting service and everytime I start a new porject in
> visual studio .net, I get a message saying that it is unable to load the
> RSReportDesigner.config file.
> I can't find any help online and I can't get into the beta newsgroup...
> HELP PLEASE.
> Thanks.
> Emad
>

---

Designing SQL2K RS reports using VS 2005 Express

Anyone:
Is it possible to install the SQL Server 2000 Reporting Services design
component for Visual Studio 2003 into Visual Studio 2005 Express to design
reports that will be deployed to Reporting Services running on SQL Server
2000? Thank you in advance for your time.No, this is not possible. RS 2000 Report Designer requires VS 2003.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nikolai Sonin" <NikolaiSonin@.discussions.microsoft.com> wrote in message
news:B5728FFD-6C1A-4C59-A3A7-C415C4436DFD@.microsoft.com...
> Anyone:
> Is it possible to install the SQL Server 2000 Reporting Services
> design
> component for Visual Studio 2003 into Visual Studio 2005 Express to design
> reports that will be deployed to Reporting Services running on SQL Server
> 2000? Thank you in advance for your time.|||I have an MSDN subscription and just installed both SQL Server 2005 Beta
tools and Visual Studio 2005 Beta 2 - I'm assuming:
1.) That SQL Server 2005 has a Report Designer
2.) That the SQL Server 2005 Report Designer will plug into Visual
Studio 2005
3.) That the SQL Server 2005 Report Designer inside of Visual Studio
2005 will work on SQL Server 2000 Databases
4.) That there is some way of importing reports designed in SQL Server
2000 Report Designer into the SQL Server 2005 Report Designer.
Could you tell me which of these are true?
"Albert Yen [MSFT]" wrote:
> No, this is not possible. RS 2000 Report Designer requires VS 2003.
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Nikolai Sonin" <NikolaiSonin@.discussions.microsoft.com> wrote in message
> news:B5728FFD-6C1A-4C59-A3A7-C415C4436DFD@.microsoft.com...
> > Anyone:
> > Is it possible to install the SQL Server 2000 Reporting Services
> > design
> > component for Visual Studio 2003 into Visual Studio 2005 Express to design
> > reports that will be deployed to Reporting Services running on SQL Server
> > 2000? Thank you in advance for your time.
>
>

Designing reports without Visual Studio .NET 2003

I'm really interested in Reporting Services, but I can't seem to find any
documentation on how to write reports and utilize it without Visual Studio
.NET 2003. Is there any way to do that?
--
Chris Shipley
HSI System Administrator
CAFCA, Inc.
Hartford, CT
http://www.cafca.org
chriss@.crtct.orgHere is some information.
http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
Chris Shipley wrote:
> I'm really interested in Reporting Services, but I can't seem to find any
> documentation on how to write reports and utilize it without Visual Studio
> .NET 2003. Is there any way to do that?
> --
> Chris Shipley
> HSI System Administrator
> CAFCA, Inc.
> Hartford, CT
> http://www.cafca.org
> chriss@.crtct.org
>|||Microsoft also have a sample app for creating RDL.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_tutorials_v1_02ua.asp
Combine this with the sample code for accessing the reporting services web
servic
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_002q.asp
With these two set of examples you can write a program to create rdl,
publish it to the web service and view it within an application. The
complexity will be trying to generate more complex reports as the sample
provided on msdn only generates simple rdl. Easiest way I found to start
writing code to generate more complex rdl was to use the sample RDL program
to generate a report, load this report in vs.net and make some changes then
compare the modified rdl with your original and retro-fit the changes in to
the code. With a lot of time (and hair pulling) you can ultimately generate
fairly complex RDL.
Hope this helps,
Richard
"Jerry" wrote:
> Here is some information.
> http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
>
> Chris Shipley wrote:
> > I'm really interested in Reporting Services, but I can't seem to find any
> > documentation on how to write reports and utilize it without Visual Studio
> > .NET 2003. Is there any way to do that?
> >
> > --
> > Chris Shipley
> > HSI System Administrator
> > CAFCA, Inc.
> > Hartford, CT
> > http://www.cafca.org
> > chriss@.crtct.org
> >
> >
>|||Hey, thanks for that! See, I have this huge database (1.3+ gb) with over
500 users, but there's no good reporting tool for them. I'm looking for a
way to give them a visual report writing tool, perhaps on the web secured
through SSL. But if they have to use VS.NET to create a report, its not
very cost effective.
Anyone out there know of any resources I can look at to achieve my
objective? I'd utilize SQL Reporting Services, but I don't have VS.NET
either. I suppose if I had to, I could learn RDL, but that doesn't seem an
effective method for users. Maybe someone out there is already writing a
VS.NET program for that purpose! :)
--
Chris Shipley
HSI System Administrator
CAFCA
Hartford, CT
Ph: 860-560-5455
http://www.cafca.org/helpdesk
chriss@.crtct.org
"Jerry" <JerryNY32513@.hotmail.com> wrote in message
news:uvPSGLkBFHA.2568@.TK2MSFTNGP11.phx.gbl...
> Here is some information.
> http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
>
> Chris Shipley wrote:
> > I'm really interested in Reporting Services, but I can't seem to find
any
> > documentation on how to write reports and utilize it without Visual
Studio
> > .NET 2003. Is there any way to do that?
> >
> > --
> > Chris Shipley
> > HSI System Administrator
> > CAFCA, Inc.
> > Hartford, CT
> > http://www.cafca.org
> > chriss@.crtct.org
> >
> >|||Several partners provide applications for RS 2000 that will allow the
creation of reports without using VS.NET. Some of them provide web-based
designers, some of them provide tools integrated e.g. into Office. You may
want to check:
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
If you can wait till RS 2005, it will provide an additional report design
tool called "Report Builder". It is a stand-alone application (independent
of the VS.NET report designer) and is focused on end-users. It allows them
to easily create reports without needing to design queries or writing
expressions. Report Builder was briefly shown as one of the new features in
RS 2005 in this webcast:
http://msevents.microsoft.com/cui/eventdetail.aspx?eventid=1032263305&culture=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Shipley" <chriss@.crtct.org> wrote in message
news:%23HOyS7sBFHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hey, thanks for that! See, I have this huge database (1.3+ gb) with over
> 500 users, but there's no good reporting tool for them. I'm looking for a
> way to give them a visual report writing tool, perhaps on the web secured
> through SSL. But if they have to use VS.NET to create a report, its not
> very cost effective.
> Anyone out there know of any resources I can look at to achieve my
> objective? I'd utilize SQL Reporting Services, but I don't have VS.NET
> either. I suppose if I had to, I could learn RDL, but that doesn't seem
an
> effective method for users. Maybe someone out there is already writing a
> VS.NET program for that purpose! :)
> --
> Chris Shipley
> HSI System Administrator
> CAFCA
> Hartford, CT
> Ph: 860-560-5455
> http://www.cafca.org/helpdesk
> chriss@.crtct.org
> "Jerry" <JerryNY32513@.hotmail.com> wrote in message
> news:uvPSGLkBFHA.2568@.TK2MSFTNGP11.phx.gbl...
> > Here is some information.
> >
> > http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
> >
> >
> >
> > Chris Shipley wrote:
> > > I'm really interested in Reporting Services, but I can't seem to find
> any
> > > documentation on how to write reports and utilize it without Visual
> Studio
> > > .NET 2003. Is there any way to do that?
> > >
> > > --
> > > Chris Shipley
> > > HSI System Administrator
> > > CAFCA, Inc.
> > > Hartford, CT
> > > http://www.cafca.org
> > > chriss@.crtct.org
> > >
> > >
>|||Thanks Robert.
Is there a beta version of RS 2005?
--
Chris Shipley
HSI System Administrator
CAFCA
Hartford, CT
Ph: 860-560-5455
http://www.cafca.org
chriss@.crtct.org
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uN%23$chyBFHA.1452@.TK2MSFTNGP11.phx.gbl...
> Several partners provide applications for RS 2000 that will allow the
> creation of reports without using VS.NET. Some of them provide web-based
> designers, some of them provide tools integrated e.g. into Office. You may
> want to check:
> http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
> If you can wait till RS 2005, it will provide an additional report design
> tool called "Report Builder". It is a stand-alone application (independent
> of the VS.NET report designer) and is focused on end-users. It allows them
> to easily create reports without needing to design queries or writing
> expressions. Report Builder was briefly shown as one of the new features
in
> RS 2005 in this webcast:
>
http://msevents.microsoft.com/cui/eventdetail.aspx?eventid=1032263305&culture=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Chris Shipley" <chriss@.crtct.org> wrote in message
> news:%23HOyS7sBFHA.1408@.TK2MSFTNGP10.phx.gbl...
> > Hey, thanks for that! See, I have this huge database (1.3+ gb) with
over
> > 500 users, but there's no good reporting tool for them. I'm looking for
a
> > way to give them a visual report writing tool, perhaps on the web
secured
> > through SSL. But if they have to use VS.NET to create a report, its not
> > very cost effective.
> >
> > Anyone out there know of any resources I can look at to achieve my
> > objective? I'd utilize SQL Reporting Services, but I don't have VS.NET
> > either. I suppose if I had to, I could learn RDL, but that doesn't seem
> an
> > effective method for users. Maybe someone out there is already writing
a
> > VS.NET program for that purpose! :)
> >
> > --
> > Chris Shipley
> > HSI System Administrator
> > CAFCA
> > Hartford, CT
> > Ph: 860-560-5455
> > http://www.cafca.org/helpdesk
> > chriss@.crtct.org
> >
> > "Jerry" <JerryNY32513@.hotmail.com> wrote in message
> > news:uvPSGLkBFHA.2568@.TK2MSFTNGP11.phx.gbl...
> > > Here is some information.
> > >
> > >
http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
> > >
> > >
> > >
> > > Chris Shipley wrote:
> > > > I'm really interested in Reporting Services, but I can't seem to
find
> > any
> > > > documentation on how to write reports and utilize it without Visual
> > Studio
> > > > .NET 2003. Is there any way to do that?
> > > >
> > > > --
> > > > Chris Shipley
> > > > HSI System Administrator
> > > > CAFCA, Inc.
> > > > Hartford, CT
> > > > http://www.cafca.org
> > > > chriss@.crtct.org
> > > >
> > > >
> >
> >
>|||Yes, there is a Beta program for SQL Server 2005 (which includes RS 2005).
More information can be found here:
http://www.microsoft.com/sql/2005/default.asp
If you are a MSDN subscriber you should also have access to SQL Server CTPs
(Community Technology Previews). Report Builder is a completely new product
and not yet available in the December CTP, but it will be included in SQL
Server 2005 Beta 3 and very likely already in one of the upcoming CTPs.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Shipley" <chriss@.crtct.org> wrote in message
news:eApnSOMCFHA.328@.tk2msftngp13.phx.gbl...
> Thanks Robert.
> Is there a beta version of RS 2005?
> --
> Chris Shipley
> HSI System Administrator
> CAFCA
> Hartford, CT
> Ph: 860-560-5455
> http://www.cafca.org
> chriss@.crtct.org
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:uN%23$chyBFHA.1452@.TK2MSFTNGP11.phx.gbl...
> > Several partners provide applications for RS 2000 that will allow the
> > creation of reports without using VS.NET. Some of them provide web-based
> > designers, some of them provide tools integrated e.g. into Office. You
may
> > want to check:
> > http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
> >
> > If you can wait till RS 2005, it will provide an additional report
design
> > tool called "Report Builder". It is a stand-alone application
(independent
> > of the VS.NET report designer) and is focused on end-users. It allows
them
> > to easily create reports without needing to design queries or writing
> > expressions. Report Builder was briefly shown as one of the new features
> in
> > RS 2005 in this webcast:
> >
>
http://msevents.microsoft.com/cui/eventdetail.aspx?eventid=1032263305&culture=en-us
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Chris Shipley" <chriss@.crtct.org> wrote in message
> > news:%23HOyS7sBFHA.1408@.TK2MSFTNGP10.phx.gbl...
> > > Hey, thanks for that! See, I have this huge database (1.3+ gb) with
> over
> > > 500 users, but there's no good reporting tool for them. I'm looking
for
> a
> > > way to give them a visual report writing tool, perhaps on the web
> secured
> > > through SSL. But if they have to use VS.NET to create a report, its
not
> > > very cost effective.
> > >
> > > Anyone out there know of any resources I can look at to achieve my
> > > objective? I'd utilize SQL Reporting Services, but I don't have
VS.NET
> > > either. I suppose if I had to, I could learn RDL, but that doesn't
seem
> > an
> > > effective method for users. Maybe someone out there is already
writing
> a
> > > VS.NET program for that purpose! :)
> > >
> > > --
> > > Chris Shipley
> > > HSI System Administrator
> > > CAFCA
> > > Hartford, CT
> > > Ph: 860-560-5455
> > > http://www.cafca.org/helpdesk
> > > chriss@.crtct.org
> > >
> > > "Jerry" <JerryNY32513@.hotmail.com> wrote in message
> > > news:uvPSGLkBFHA.2568@.TK2MSFTNGP11.phx.gbl...
> > > > Here is some information.
> > > >
> > > >
> http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
> > > >
> > > >
> > > >
> > > > Chris Shipley wrote:
> > > > > I'm really interested in Reporting Services, but I can't seem to
> find
> > > any
> > > > > documentation on how to write reports and utilize it without
Visual
> > > Studio
> > > > > .NET 2003. Is there any way to do that?
> > > > >
> > > > > --
> > > > > Chris Shipley
> > > > > HSI System Administrator
> > > > > CAFCA, Inc.
> > > > > Hartford, CT
> > > > > http://www.cafca.org
> > > > > chriss@.crtct.org
> > > > >
> > > > >
> > >
> > >
> >
> >
>

Designing reports with Reproting Services

I'm no graphic designer but I am really struggling with making a decent looking report.

Does anyone have any ideas or tips when working with reporting services?

Hi,

I'm no expert either, but what works for me is designing a report template which has the basics, and use that as a starting place for all subsequent reports. The template contains a page footer which contains the date the report was run, the name of our office and "page # out of total pages".

Starting with this generic template I add a page header which contains the report name and any selection criteria which is input by the user at run-time. On to content: I output data in the order specified by users and use bold for all headings to increase readability. Where appropriate the Reporting Services' "groupby" feature also increases clarity by allowing you to suppress duplicate values on the print-out.

Hope this helps!

Designing Reports for SQL Reporting Services 2000

My customer has SQL Reporting Services on a server with SQL 2000 Standard Edition. The customer wants to develop his own Reporting Services reports. We have been recommending Visual Basic.NET Standard 2003 for this purpose in that it costs less than $100 (usually). However, with the advent of Visual Studio 2005, the VB.NET 2003 is becoming difficult or impossible to obtain. One option is Visual C#.NET Standard 2003 - I assume it will work - does anyone know for sure?

More importantly, when Visual C#.NET 2003 becomes unvailable, what options are left for developing RS 2000 reports?

Thanks for any suggestions.

Mark

>More importantly, when Visual C#.NET 2003 becomes unvailable, what options are left for developing RS 2000 reports?

None from Microsoft. There are third-party solutions, e.g. Cizer.

|||

You could also write a small tool that performs a RDL structure "downgrade" conversion (see e.g. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=988366&SiteID=1). However note that RS 2000 doesn't support a number of RS 2005 features (e.g. multi value parameters).

-- Robert

designing reports

Hi - we are just putting a proposal/costs together to implement reporting
services.
Might seem daft (!), I know i need the report designer and it works with the
visual studio .net 2003, but does that mean we need to buy visual studio .net
2003 (std/dev/enterprise?) and the designer comes free? Or vice versa? Or
both!
Thanks PaulThe designer comes free with SQL Server (you need a license for SQL Server
anywhere you have the server part of RS installed). But, the designer needs
some version (any version) of VS to install into. If you don't have VS 2003
then the cheapest thing to do is to buy VB.Net ($100).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:ED6BE78D-8085-4A3A-8F01-6BD0408734D9@.microsoft.com...
> Hi - we are just putting a proposal/costs together to implement reporting
> services.
> Might seem daft (!), I know i need the report designer and it works with
the
> visual studio .net 2003, but does that mean we need to buy visual studio
.net
> 2003 (std/dev/enterprise?) and the designer comes free? Or vice versa? Or
> both!
> Thanks Paul|||Thanks for the info Bruce! We have SQL server but are hoping to migrate from
Actuate...
"Bruce L-C [MVP]" wrote:
> The designer comes free with SQL Server (you need a license for SQL Server
> anywhere you have the server part of RS installed). But, the designer needs
> some version (any version) of VS to install into. If you don't have VS 2003
> then the cheapest thing to do is to buy VB.Net ($100).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:ED6BE78D-8085-4A3A-8F01-6BD0408734D9@.microsoft.com...
> > Hi - we are just putting a proposal/costs together to implement reporting
> > services.
> >
> > Might seem daft (!), I know i need the report designer and it works with
> the
> > visual studio .net 2003, but does that mean we need to buy visual studio
> ..net
> > 2003 (std/dev/enterprise?) and the designer comes free? Or vice versa? Or
> > both!
> >
> > Thanks Paul
>
>|||Hi Paul,
We too are evaluating products to migrate from Actuate. I can share our
findings if you're interested.
Bill
"Paul" wrote:
> Thanks for the info Bruce! We have SQL server but are hoping to migrate from
> Actuate...
> "Bruce L-C [MVP]" wrote:
> > The designer comes free with SQL Server (you need a license for SQL Server
> > anywhere you have the server part of RS installed). But, the designer needs
> > some version (any version) of VS to install into. If you don't have VS 2003
> > then the cheapest thing to do is to buy VB.Net ($100).
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Paul" <Paul@.discussions.microsoft.com> wrote in message
> > news:ED6BE78D-8085-4A3A-8F01-6BD0408734D9@.microsoft.com...
> > > Hi - we are just putting a proposal/costs together to implement reporting
> > > services.
> > >
> > > Might seem daft (!), I know i need the report designer and it works with
> > the
> > > visual studio .net 2003, but does that mean we need to buy visual studio
> > ..net
> > > 2003 (std/dev/enterprise?) and the designer comes free? Or vice versa? Or
> > > both!
> > >
> > > Thanks Paul
> >
> >
> >|||Hi Paul,
I have a lot of experience with Actuate (8 years) and am currently getting
up to speed on Reporting Services.
Let me know if you'd like to exchange information/experiences on migrating
from Actuate to Reporting Services.
-- Chris
--
Chris, SSSI
"Paul" wrote:
> Thanks for the info Bruce! We have SQL server but are hoping to migrate from
> Actuate...
> "Bruce L-C [MVP]" wrote:
> > The designer comes free with SQL Server (you need a license for SQL Server
> > anywhere you have the server part of RS installed). But, the designer needs
> > some version (any version) of VS to install into. If you don't have VS 2003
> > then the cheapest thing to do is to buy VB.Net ($100).
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Paul" <Paul@.discussions.microsoft.com> wrote in message
> > news:ED6BE78D-8085-4A3A-8F01-6BD0408734D9@.microsoft.com...
> > > Hi - we are just putting a proposal/costs together to implement reporting
> > > services.
> > >
> > > Might seem daft (!), I know i need the report designer and it works with
> > the
> > > visual studio .net 2003, but does that mean we need to buy visual studio
> > ..net
> > > 2003 (std/dev/enterprise?) and the designer comes free? Or vice versa? Or
> > > both!
> > >
> > > Thanks Paul
> >
> >
> >|||Hi Bill,
I have a lot of experience with Actuate (8 years) and am currently getting
up to speed on Reporting Services.
Let me know if you'd like to exchange information/experiences on migrating
from Actuate to Reporting Services.
-- Chris
Chris, SSSI
"Bill" wrote:
> Hi Paul,
> We too are evaluating products to migrate from Actuate. I can share our
> findings if you're interested.
> Bill
> "Paul" wrote:
> > Thanks for the info Bruce! We have SQL server but are hoping to migrate from
> > Actuate...
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > The designer comes free with SQL Server (you need a license for SQL Server
> > > anywhere you have the server part of RS installed). But, the designer needs
> > > some version (any version) of VS to install into. If you don't have VS 2003
> > > then the cheapest thing to do is to buy VB.Net ($100).
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Paul" <Paul@.discussions.microsoft.com> wrote in message
> > > news:ED6BE78D-8085-4A3A-8F01-6BD0408734D9@.microsoft.com...
> > > > Hi - we are just putting a proposal/costs together to implement reporting
> > > > services.
> > > >
> > > > Might seem daft (!), I know i need the report designer and it works with
> > > the
> > > > visual studio .net 2003, but does that mean we need to buy visual studio
> > > ..net
> > > > 2003 (std/dev/enterprise?) and the designer comes free? Or vice versa? Or
> > > > both!
> > > >
> > > > Thanks Paul
> > >
> > >
> > >

Designing Report in VS.NET2003 - studio is crashing

I am using reporting services 2000 already for 2 years. This problem is occurring on 2-3 reports, I can't say exactly what is the reason.

How I use the report designer is pretty simple and consistent. Report data is usualy produced by calling a stored procedure (on SLQ server 2000), I have a few parameters. Some of Paramaters are dates with a default values calculated to give yesterday's date or today - 7 days. And that is the only code in the report itselft. As soon as I click on Yes/No paramater, that doesn't have default, and is int in proc and report, then complete Visual Studio Environment starts flashing, making bip-bip noise, and is blocked, no access and reponse. I can't close it for a while, I can't bring up task manager, and in general this crash is very much resource intensive, Outlook is freezing, can't open IE, new spreadsheet. I am working on windows Xp platform. Eventually I would manage to close VS thru task manager.

As soon as this report is uploaded to Report Manager, the place where all the reports are available to users, on different server, the same report works fine.

Has anyone experienced this and what would be the reason.

Thanks in advance,
Elizabeta R

did you get out of memory exception.. check ur database may be it contains huge data..

run the query in sql server..

Designer changing report element sizes during a save

This is a repost using MSDN Subscription
Using SQL Server Reporting Services Designer Version 9.00.1399.00
I'm having trouble with a three column report with a page header the width
of the page. The designer is changing the width of elements when it is
saved. As long as you view the report in the designer, the report renders as
you would expect, but when it gets saved, some of the report elements get
changed.
Try this:
New empty Report Server Project
Add new empty report (Add -> New Item -> Select Report)
No datasource
Enable page header
Add a text box (textbox1) to page header. Make it begin at the left
margin/top margin and be almost the width of the page (6in).
Set the height of the page header to the height of the textbox1.
Insert five or six words in textbox1.
Make the report a 3 column report.
Reset the page header width to be 6.5in (1in right/left margins on 8.5in
paper) using the resizer in the page header.
The column width should be 1.83333in (1.83333 * 3 = 5.49999 + [column
spacing] 0.5in + 0.5in = 6.49999in)
Add a text box (textbox2) to the body (in column 1). Make it begin at the
left margin/top margin and be almost the width of the column (1.625in).
Insert a few words in textbox2.
View the report. Appears to be fine.
Save, Close the report, Reopen the report.
The width of the page header is now 6in (was 6.5in), column width is now
1.66667in (was 1.83333in)
Why did the width of the page header change?
Make the width of the page header and textbox1, 6.5in.
Save, Close the report, Reopen the report.
The page header is 6.499999in wide, but textbox1 is the same width as one of
the columns in the body (1.83333in)
Why did the width of the page header and textbox1 change?
Make textbox1 6in wide again.
Make the report 6.5in wide.
Add a new textbox (textbox3) in the page header to the right of textbox1
(starts at 6in, 0.5in wide), same height as the first one.
Insert a few letters in textbox3.
Save, Close the report, Reopen the report.
The report is now 6in wide (instead of 6.5in), columns are 1.66667in wide.
Textbox3 that was just added to the page header cannot be seen. It is at
the right edge of the page header, and has a negative width. It can only be
found using dropdown in the properties window.
Why did textbox3 disappear/get a negative width?
Are these known bugs? Are there any work arounds?Hello,
From your desscription, I tried to reproduce the issue to no avail. To
understand the issue better, will you please send the report project or
report to me? You could remove "online" in my displayed email address. I
know the report will be changed after saving, and reopen, however, you
report shall make me understanding your problem more directly. thank you!
Also, since you did not install SQL 2005 sp1, you may want to install it to
test the sitaution.
If you have other related information, please also let's know. We look
forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Im having the same error!! I have 2 reports that have mutliple columns. When
I save the report, it will change the text boxes in the header to negative
values. I have not found a work around for this error. Anyone have any
suggestions/Have run into the same problem as well?
-Theresa
"AOTX San Antonio" wrote:
> This is a repost using MSDN Subscription
> Using SQL Server Reporting Services Designer Version 9.00.1399.00
> I'm having trouble with a three column report with a page header the width
> of the page. The designer is changing the width of elements when it is
> saved. As long as you view the report in the designer, the report renders as
> you would expect, but when it gets saved, some of the report elements get
> changed.
> Try this:
> New empty Report Server Project
> Add new empty report (Add -> New Item -> Select Report)
> No datasource
> Enable page header
> Add a text box (textbox1) to page header. Make it begin at the left
> margin/top margin and be almost the width of the page (6in).
> Set the height of the page header to the height of the textbox1.
> Insert five or six words in textbox1.
> Make the report a 3 column report.
> Reset the page header width to be 6.5in (1in right/left margins on 8.5in
> paper) using the resizer in the page header.
> The column width should be 1.83333in (1.83333 * 3 = 5.49999 + [column
> spacing] 0.5in + 0.5in = 6.49999in)
> Add a text box (textbox2) to the body (in column 1). Make it begin at the
> left margin/top margin and be almost the width of the column (1.625in).
> Insert a few words in textbox2.
> View the report. Appears to be fine.
> Save, Close the report, Reopen the report.
> The width of the page header is now 6in (was 6.5in), column width is now
> 1.66667in (was 1.83333in)
> Why did the width of the page header change?
> Make the width of the page header and textbox1, 6.5in.
> Save, Close the report, Reopen the report.
> The page header is 6.499999in wide, but textbox1 is the same width as one of
> the columns in the body (1.83333in)
> Why did the width of the page header and textbox1 change?
> Make textbox1 6in wide again.
> Make the report 6.5in wide.
> Add a new textbox (textbox3) in the page header to the right of textbox1
> (starts at 6in, 0.5in wide), same height as the first one.
> Insert a few letters in textbox3.
> Save, Close the report, Reopen the report.
> The report is now 6in wide (instead of 6.5in), columns are 1.66667in wide.
> Textbox3 that was just added to the page header cannot be seen. It is at
> the right edge of the page header, and has a negative width. It can only be
> found using dropdown in the properties window.
> Why did textbox3 disappear/get a negative width?
> Are these known bugs? Are there any work arounds?|||Hello Theresa
,
I have reproduced the issue on my side. It seems that when adding textbox
or change textbox, it does not actually perform an optimization of the
report according to the algorithm that used when saving a report. I found
if I change the textbox1 width to 6 to 6.5, this size is not actually saved
to rdl and the width number is not stored at all. At this time, textbox1
actually has the 6.5 when rendering since it is aligned to the body width
1.83333 automatically.
Please rest assured your feedback is taken seriously this issue has been
reported to the product team. Product team may evaluate the business impact
and decide to fix this or not. If there is any update, we will let you
know.
You may manually edit rdl and set textbox in pageheader to the value it
should be to work around the issue. In the meantime, I also encourage you
submit your feedback on this issue via the link below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hello Every One,
I came across this issue and found a good work around for this.
Whenever you have the textbox's right margin alligned with the right
margin of a rectangle in a Page Header, we see this behavour in a multi
column report.
Work around: We suggest to keep a minimal gap between the textbox right
edge and the container and make the container border as none. This
makes it retain the width attribute in the rdl file and we dont loose
its width after saving.
Best Regards,
Dipanjan Banik
SQL Developer Support
Peter Yang [MSFT] wrote:
> Hello Theresa
> ,
> I have reproduced the issue on my side. It seems that when adding textbox
> or change textbox, it does not actually perform an optimization of the
> report according to the algorithm that used when saving a report. I found
> if I change the textbox1 width to 6 to 6.5, this size is not actually saved
> to rdl and the width number is not stored at all. At this time, textbox1
> actually has the 6.5 when rendering since it is aligned to the body width
> 1.83333 automatically.
> Please rest assured your feedback is taken seriously this issue has been
> reported to the product team. Product team may evaluate the business impact
> and decide to fix this or not. If there is any update, we will let you
> know.
> You may manually edit rdl and set textbox in pageheader to the value it
> should be to work around the issue. In the meantime, I also encourage you
> submit your feedback on this issue via the link below
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================

Design question related to Grouping

Hello,

I am using SQL 2005 Reporting Services to create a user status report. Each page of the report will contain information about 1 user.

On a single page, there are 4 different views of the data (pulling from different tables). Ideally, I would like to group the data (by user for each page, then by category for each of the 4 views on the page). I grouped by user, and the separate pages came out fine. But attempting to group by category, I found that the grouping applies to all the data...and I only want to group a subset of the data.

Is this possible? Will I need to nest select statements to make it happen? Is there a better way to approach this?

Go easy on me...I'm new to this.

Thanks,
Davidi think what your looking for is an outer join.
select * from table1 1
left outer join table2 2 on 1.column = 2.column

Design Question

I am just getting into SQL reporting services and I am looking into upgrading some Access reports with SQL reporting services. In the Access reports there was an interface that allowed the user to select some different options and then generate the report based on some of those options. To generate the report there was a large amount of vba code that created some collector tables that were then used by the report. My question is what would be the best way to recreate this functionality in reporting services. Would it be best to just have an external assembly that I called and passed in the parameters, this assembly would then create and a populate any tables on the sql server that could then be used by the report to display the data? If this is the case how would I go about connecting to the database? Or would it be better to create a custom data processing extension to do this? I have not looked into the data processing extensions much yet so I am not sure if it is even possible to do this.
Thanks for your suggestions
--
Message posted via http://www.sqlmonster.comI am assuming here that the data you are reporting against is in SQL Server.
The way you have solved it today in Access essentially allows you to have
your own temporary tables. Your recordsets in your VBA code acted as
temporary tables. I think you would be better off to create a stored
procedure than to go either of the paths you mention below. A custom data
processing extension is not easy. Doable but non-trivial. One point, when
creating a stored procedure don't try to do a port of your vba code, rewrite
it. Your VBA code is most likely cursor based (walking through recordsets).
When doing SP you should try to do set based logic. Fill in temp tables,
doing joins with the temp table etc. I once took 64 pages of C code and
turned it into 2 pages of a stored procedure. You can use cursors in SP but
that should be a last resort.
With the next beta of Widbey their will be winform and webform controls that
might make this easier.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jason DeWeeese via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:6626b9ec55f6440c865863d7d4c984dd@.SQLMonster.com...
> I am just getting into SQL reporting services and I am looking into
upgrading some Access reports with SQL reporting services. In the Access
reports there was an interface that allowed the user to select some
different options and then generate the report based on some of those
options. To generate the report there was a large amount of vba code that
created some collector tables that were then used by the report. My question
is what would be the best way to recreate this functionality in reporting
services. Would it be best to just have an external assembly that I called
and passed in the parameters, this assembly would then create and a populate
any tables on the sql server that could then be used by the report to
display the data? If this is the case how would I go about connecting to the
database? Or would it be better to create a custom data processing extension
to do this? I have not looked into the data processing extensions much yet
so I am not sure if it is even possible to do this.
> Thanks for your suggestions
> --
> Message posted via http://www.sqlmonster.com|||Thanks for your suggestion, that is one other alternative that I had briefly considered, but had not really looked into. Thanks
--
Message posted via http://www.sqlmonster.com

Design Preview Vs Print Preview

My report that I am writing looks great and pages properly (have the option selected to keep a table together ) when it is in the Reporting Services development preview. But as soon as I click on the print preview, which includes exporting it to a PDF, I get bold lines, other weirdities and the table in the report will split across pages etc.

Ideally, I would like it to print exactly as it looks in the RS preview.

Any ideas?

dotnetnow

While in design-view, right-click and select Properties then Layout tab. This is where you can set margins and page size/orientation, anything you do here will affect the output to PDF.

Design Pages on Report Server

Hi every body

I have developed an reporting solution for a customer with reporting services and using report builder.

When he connect to http://localhost/reports , he see the page like

http://img215.imageshack.us/img215/583/folderhl1.jpg

But i would to custom design of my default page, and other maybe. Where i can do it ?

Thanks all

Regards

Erwan Sarcelet, France

Hi.

There's not much you can do to change the look of report manager. However, if you have purchased Visual Studio 2005, you can build a customized front end for your reports. I have a feeling that is what you are asking for.

|||

Yes, that is what i wanted to know. So i cant modify the Folder.aspx file ?

Thank you Greg.

Erwan

|||

I'm not sure. Try to open it in Visual Studio and see what you can do to it.

However, I'm not really sure I would recommend doing that. I would think that you could potentially cause damage to report manager. That sounds too much like a hack to me.

I would recommend creating your own front end.

Design opinion?

Hi
I am starting the task of creating a data warehouse for my company's OLTP
system and we would like to offload reporting to a reporting schema at a
data warehouse. We have 2 kinds of reports: operational (used daily and
need data just about real time) and analytical (used to determine sales
trends, etc).
For the analytical reports, I think we can just do a nightly ETL load since
the data doesn't need to be too recent. However, I was thinking of using
replication to replicate the table data used in the operational reports,
capturing the data in stored procedures as they come across the pipe and
then performing ETL within the stored procs. That way I think we can have
real time data available for reporting.
Does anyone have an opinion on this scheme?
Thank youI've done this kind of configuration before on SQL 2K. Transactional
replication is about the best you can do since log shipping takes the DB
offline. We preferred to pause replication during the staging portion of
the ETL cycle to avoid blocking and dead locking. This also gave us a
consistent point in time snap shot of the source to work from. Using TSQL
as an ETL tool is fast but has limitations around data transformation and no
access to the bulk load api.
Good luck,
Danny
"Dodo Lurker" <none@.noemailplease> wrote in message
news:BIKdneofYum6-2reRVn-pQ@.comcast.com...
> Hi
> I am starting the task of creating a data warehouse for my company's OLTP
> system and we would like to offload reporting to a reporting schema at a
> data warehouse. We have 2 kinds of reports: operational (used daily and
> need data just about real time) and analytical (used to determine sales
> trends, etc).
> For the analytical reports, I think we can just do a nightly ETL load
> since
> the data doesn't need to be too recent. However, I was thinking of
> using
> replication to replicate the table data used in the operational reports,
> capturing the data in stored procedures as they come across the pipe and
> then performing ETL within the stored procs. That way I think we can have
> real time data available for reporting.
> Does anyone have an opinion on this scheme?
> Thank you
>|||Hello,
Timing is everything.
I would work on getting your data warehouse overnight processes
completed.
In a short period of time new replication options will be available in
SQL Server 2005.
Even the existing options may meet your needs, but with the right
timing you may
have better options available to you.|||Depending on what method you use to migrate data to the warehouse (and also
the volitility of the OLTP data), this may impact the performance of the
OLTP system. Also, once the user expects analysis in real time, any
interruption will be perceived as a system malfunction, and thus your
maintenance requirements and responsilbility have increased. Do they really
need real time analysis? Also, what type of analysis; OLAP?
"Dodo Lurker" <none@.noemailplease> wrote in message
news:BIKdneofYum6-2reRVn-pQ@.comcast.com...
> Hi
> I am starting the task of creating a data warehouse for my company's OLTP
> system and we would like to offload reporting to a reporting schema at a
> data warehouse. We have 2 kinds of reports: operational (used daily and
> need data just about real time) and analytical (used to determine sales
> trends, etc).
> For the analytical reports, I think we can just do a nightly ETL load
> since
> the data doesn't need to be too recent. However, I was thinking of
> using
> replication to replicate the table data used in the operational reports,
> capturing the data in stored procedures as they come across the pipe and
> then performing ETL within the stored procs. That way I think we can have
> real time data available for reporting.
> Does anyone have an opinion on this scheme?
> Thank you
>