New to Reporting Services

I am used to using Crystal Reports, but now with having Visual Studio 2005 and SQL Server 2005, I am trying to get along and use Reporting Services.

I need to understand or have somebody point me to a website or good book that I can use to learn about Report Server and the reports.

Here is the actual problem that I am having: I have built a report into the company intranet. This report works if I run it locally, however the print button does not show up understandably. Somebody mentioned making it a server-side report. So I imported the report into the Report Server of the SQL Server. At first I was getting an error message "The path of the item "\Reports\report.rdlc" is not valid. The path must be less than 260 characters long and restrictions apply. (rsInvalidItemPath)"

I believe I solved that error, but now when the page displays I do not get an error message, but I also do not have a report. The reportViewer is empty.

I then noticed that maybe I had to copy the report to IIS (I am using IIS 5.1). So I used the copy tool to copy the report to the directory for the report server in IIS (reportserver$sql). I have the property for the Server URL set to this directory and I have the report path set to \Reports\report.rdlc. Now I am getting an error message about "the item cannot be found."

Thanks for any information and help.

In SSRS all reports are actually stored inside of the Reporting Services database. As far I know, copying a file to the reporting server will not do anything for you. You need to 'Deploy' the report to the reporting services server from inside the report designer or BIDS (Business Intelligence Design Studio or something like that). However, you could also deploy the report from inside of reporting services web interface. I would also recommend the apress book on reporting services 2005. I bought the book because it was the first rs2005 book out of the gate. But it is actually really good. I started out with no knowledge of SSRS2005 and very limited knowledge of reporting technologies in general. This book made reporting services easy to learn.

Pro SQL Server 2005 Reporting Services

http://www.amazon.com/gp/product/1590594983/sr=1-4/qid=1138689829/ref=pd_bbs_4/002-0186147-5716036?%5Fencoding=UTF8

New to Reporting Services

hi
I am new to reporting services of SQL Server. I just read an article about
it. In our organization, we are using Crystal Reports to develop reports for
our system. Backend is of course SQL Server 2000.
Can anyone please guide me that from where I should start to explore this
new technology?
Also is it necessary to use the reporting services of SQL Server 2000 via
VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
Thanks in advance.
Syed Hussain Itiba NaqviI would purchase the book "Hitchiker's Guide to SQL Server 2000 Reporting
Services."
You can get a good deal at www.BookPool.com
David
"Syed Hussain Itiba Naqvi" <Syed Hussain Itiba
Naqvi@.discussions.microsoft.com> wrote in message
news:6E7B4BEB-9417-448F-B430-D29411BA114D@.microsoft.com...
> hi
> I am new to reporting services of SQL Server. I just read an article about
> it. In our organization, we are using Crystal Reports to develop reports
> for
> our system. Backend is of course SQL Server 2000.
> Can anyone please guide me that from where I should start to explore this
> new technology?
> Also is it necessary to use the reporting services of SQL Server 2000 via
> VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
> Thanks in advance.
> Syed Hussain Itiba Naqvi|||Syed,
Reporting Services comes in two parts.
1. The Server
2. Development Tools.
Ideally The Server components need to be on the same box as a SQL instance
(if you want to run it under the same license - see licensing for further
details) and the same box should have Web Server on also. RS uses the SQL
instance to store it's two new DBs to run the service.
The Development tools can be loaded onto any development machine, but
require VS.NET 2003. Once installed it adds Business Intelligence Projects to
the available solutions, and the Report Designer runs inside of VS.NET IDE
(as does the Crystal designer).
The cool thing about the designer is that you can preview (in like
real-time) the report results from inside the IDE, and also, by deploying it
to your localhost, you can see how the Reporting Server will handle it also,
all prior to deploying it to the 'real' server.
two books to get: Professional SQL Server Reporting Services - WROX and
Step-by-Step SQL Server 2000 Reporting Services - Microsoft. These two books
hold so much instructional info for the beginner.
Also, contact your local Microsoft Area Rep, they will assist you greatly. I
did, and they web-demo'd the technology to myself and my Managers during a
conference call. They have been excellent and very supportive.
Hope this assists,
Tony
"Syed Hussain Itiba Naqvi" wrote:
> hi
> I am new to reporting services of SQL Server. I just read an article about
> it. In our organization, we are using Crystal Reports to develop reports for
> our system. Backend is of course SQL Server 2000.
> Can anyone please guide me that from where I should start to explore this
> new technology?
> Also is it necessary to use the reporting services of SQL Server 2000 via
> VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
> Thanks in advance.
> Syed Hussain Itiba Naqvi

New to Replication

I have a SQL 2000 database used in a data entry / transactional mode. We
have few users, but they do occassionally run reports which are server
intensive. It is a small business. We would like to begin using the data in
the database on the website. I'm wondering if I should replicate the DB on
the same server. Does that really provide any performance protection for the
data entry folks? We don't think the traffic on the Internet will be intense
to begin with because it will only be for members. Does a snapshot
replication make sense (we only need a refresh each night) or should I just
let the web hit the data entry db? Thanks
Hi,
I understand that some of your users occasionally ran reports on your
server. The operations impacted your server performance. You want to know
if you can replicate the DB on the same server to improve the performance.
If I have misunderstood, please let me know.
Generally producing report is CPU, memory and I/O intensive, so I recommend
that you replicate your database to a different server (dedicated for
report server) and have your web application use this report server for
producing report. Since reports are for history data, snapshot replication
is enough.
For implementing replication, please refer to:
Implementing Replication (Enterprise Manager)
http://msdn2.microsoft.com/en-us/library/aa216618(sql.80).aspx
Implementing Master-Slave Snapshot Replication Using SQL Server
http://msdn2.microsoft.com/en-us/library/ms998561.aspx
Planning for Snapshot Replication
http://msdn2.microsoft.com/en-us/library/aa237481(SQL.80).aspx
If you have any other questions or concerns, please let me know. Have a
nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||That answers my question. Thanks Charles!
"Charles Wang[MSFT]" wrote:

> Hi,
> I understand that some of your users occasionally ran reports on your
> server. The operations impacted your server performance. You want to know
> if you can replicate the DB on the same server to improve the performance.
> If I have misunderstood, please let me know.
> Generally producing report is CPU, memory and I/O intensive, so I recommend
> that you replicate your database to a different server (dedicated for
> report server) and have your web application use this report server for
> producing report. Since reports are for history data, snapshot replication
> is enough.
> For implementing replication, please refer to:
> Implementing Replication (Enterprise Manager)
> http://msdn2.microsoft.com/en-us/library/aa216618(sql.80).aspx
> Implementing Master-Slave Snapshot Replication Using SQL Server
> http://msdn2.microsoft.com/en-us/library/ms998561.aspx
> Planning for Snapshot Replication
> http://msdn2.microsoft.com/en-us/library/aa237481(SQL.80).aspx
> If you have any other questions or concerns, please let me know. Have a
> nice day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>
>
>
>
>
>
sql

New to M'soft - doing feasibility study of migrating from Brio to

I was really impressed with the ease MSRS reports can be created, but at the
end of it I have come to a roadblock with MSRS not supporting Multi select in
Parameters and also no graphical handle to place the parameters where I want.
So I am concluding that MSRS is not a go forward reporting tool for us.
Do any of you guys think there is a way around'
Also there is no way of jazzing up the reports menu on the Reportserver.
Is there an option of using ASP.net to build the parameters there and then
pass on to the report server' can somebody put down an example.
We have 100 reports to migrate. And I'm running out of time to decide to go
or not to go wit MSRS.. please put in your thoughts/ solutions if any
Thanks
GNUToday you can easily integrate with ASP.Net. You can use either URL
integration or web services. Very strong support for this.
With service pack 2 there will be support for client side printing (SP2 will
be out within the next month or two). The next version of RS will be out
with the next version of SQL Server (Yukon). I am hoping Yukon RS will have
multi-select but I don't know.
I suggest looking at the books on line (you can get to it on the msdn
website I believe). Also, check out all the material available here:
http://www.microsoft.com/sql/reporting/productinfo/default.asp
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"GNU" <GNU@.discussions.microsoft.com> wrote in message
news:A7CF6172-BB99-40D5-8573-9C71B3208B22@.microsoft.com...
> I was really impressed with the ease MSRS reports can be created, but at
the
> end of it I have come to a roadblock with MSRS not supporting Multi select
in
> Parameters and also no graphical handle to place the parameters where I
want.
> So I am concluding that MSRS is not a go forward reporting tool for us.
> Do any of you guys think there is a way around'
> Also there is no way of jazzing up the reports menu on the Reportserver.
> Is there an option of using ASP.net to build the parameters there and then
> pass on to the report server' can somebody put down an example.
> We have 100 reports to migrate. And I'm running out of time to decide to
go
> or not to go wit MSRS.. please put in your thoughts/ solutions if any
> Thanks
> GNU
>|||For multi-select parameters, we will have native support for multi-select in
SQL 2005 Reporting Services. You can handle this today by providing your own
parameter UI and dynamically constructing the SQL statement. As for moving
the parameters around, you would have to do this with your own UI.
It is fairly easy to build your own UI in the SQL 2000 version of Reporting
Services using either the Web Services interfaces or URL access. We will
make it even easier in the SQL 2005 version of Reporting Services by using
the new Report Veiwer controls that you can host in your WinForms or ASP.NET
application.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"GNU" <GNU@.discussions.microsoft.com> wrote in message
news:A7CF6172-BB99-40D5-8573-9C71B3208B22@.microsoft.com...
>I was really impressed with the ease MSRS reports can be created, but at
>the
> end of it I have come to a roadblock with MSRS not supporting Multi select
> in
> Parameters and also no graphical handle to place the parameters where I
> want.
> So I am concluding that MSRS is not a go forward reporting tool for us.
> Do any of you guys think there is a way around'
> Also there is no way of jazzing up the reports menu on the Reportserver.
> Is there an option of using ASP.net to build the parameters there and then
> pass on to the report server' can somebody put down an example.
> We have 100 reports to migrate. And I'm running out of time to decide to
> go
> or not to go wit MSRS.. please put in your thoughts/ solutions if any
> Thanks
> GNU
>|||thanks for ur reply.. some more questions..
1) when is SQL 2005 scheduled for release?
2) If I can use ASP.NET will I have to write a lot of code to incorporate
the report in a frame below the asp page so that i can keep changing my
parameters n look up the report data.
3) will it allow export data into Excel/CSV ? as it does when viewed from
report server or will I have to write code for it?
4) where can I find some sample code, I'm new to .Net.
Thanks,
GNU
"Brian Welcker [MSFT]" wrote:
> For multi-select parameters, we will have native support for multi-select in
> SQL 2005 Reporting Services. You can handle this today by providing your own
> parameter UI and dynamically constructing the SQL statement. As for moving
> the parameters around, you would have to do this with your own UI.
> It is fairly easy to build your own UI in the SQL 2000 version of Reporting
> Services using either the Web Services interfaces or URL access. We will
> make it even easier in the SQL 2005 version of Reporting Services by using
> the new Report Veiwer controls that you can host in your WinForms or ASP.NET
> application.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "GNU" <GNU@.discussions.microsoft.com> wrote in message
> news:A7CF6172-BB99-40D5-8573-9C71B3208B22@.microsoft.com...
> >I was really impressed with the ease MSRS reports can be created, but at
> >the
> > end of it I have come to a roadblock with MSRS not supporting Multi select
> > in
> > Parameters and also no graphical handle to place the parameters where I
> > want.
> > So I am concluding that MSRS is not a go forward reporting tool for us.
> > Do any of you guys think there is a way around'
> > Also there is no way of jazzing up the reports menu on the Reportserver.
> > Is there an option of using ASP.net to build the parameters there and then
> > pass on to the report server' can somebody put down an example.
> > We have 100 reports to migrate. And I'm running out of time to decide to
> > go
> > or not to go wit MSRS.. please put in your thoughts/ solutions if any
> > Thanks
> > GNU
> >
> >
>
>|||Answers inline.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"GNU" <GNU@.discussions.microsoft.com> wrote in message
news:2D6F7754-3832-4F25-AAAE-B1F74C4867EA@.microsoft.com...
> thanks for ur reply.. some more questions..
> 1) when is SQL 2005 scheduled for release?
Late summer of 2005.
> 2) If I can use ASP.NET will I have to write a lot of code to incorporate
> the report in a frame below the asp page so that i can keep changing my
> parameters n look up the report data.
Not if you use the Report Viewer controls. You just bind parmeter values in
the control.
> 3) will it allow export data into Excel/CSV ? as it does when viewed from
> report server or will I have to write code for it?
The viewer supports export.
> 4) where can I find some sample code, I'm new to .Net.
There are samples in the product already as well as there will be more
samples in the 2005 release.
> Thanks,
> GNU
>
> "Brian Welcker [MSFT]" wrote:
>> For multi-select parameters, we will have native support for multi-select
>> in
>> SQL 2005 Reporting Services. You can handle this today by providing your
>> own
>> parameter UI and dynamically constructing the SQL statement. As for
>> moving
>> the parameters around, you would have to do this with your own UI.
>> It is fairly easy to build your own UI in the SQL 2000 version of
>> Reporting
>> Services using either the Web Services interfaces or URL access. We will
>> make it even easier in the SQL 2005 version of Reporting Services by
>> using
>> the new Report Veiwer controls that you can host in your WinForms or
>> ASP.NET
>> application.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "GNU" <GNU@.discussions.microsoft.com> wrote in message
>> news:A7CF6172-BB99-40D5-8573-9C71B3208B22@.microsoft.com...
>> >I was really impressed with the ease MSRS reports can be created, but at
>> >the
>> > end of it I have come to a roadblock with MSRS not supporting Multi
>> > select
>> > in
>> > Parameters and also no graphical handle to place the parameters where I
>> > want.
>> > So I am concluding that MSRS is not a go forward reporting tool for us.
>> > Do any of you guys think there is a way around'
>> > Also there is no way of jazzing up the reports menu on the
>> > Reportserver.
>> > Is there an option of using ASP.net to build the parameters there and
>> > then
>> > pass on to the report server' can somebody put down an example.
>> > We have 100 reports to migrate. And I'm running out of time to decide
>> > to
>> > go
>> > or not to go wit MSRS.. please put in your thoughts/ solutions if any
>> > Thanks
>> > GNU
>> >
>> >
>>

new to crystal reports xi to use with vb6

I have crystal xi and i want to use it with vb6 application when i download source code examples no one works always differences in dlls
can someone just give me what dll should i use and if posible some example
i enclose the dll from some source code and the ones i try to use with no success thanks for help
ramon@.soler.com

report creation example

Object={3C62B3DD-12BE-4941-A787-EA25415DCD27}#10.0#0; crviewer.dll
Reference=*\G{23325710-7003-45DC-9B12-49FF312E9F1F}#a.0#0#..\..\..\..\Program Files\Common Files\Crystal Decisions\2.5\bin\craxddrt.dll#Crystal Reports ActiveX Designer Design and Runtime Library 10.0
Reference=*\G{00000200-0000-0010-8000-00AA006D2EA4}#2.0#0#..\..\..\..\Program Files\Common Files\system\ado\msado20.tlb#Microsoft ActiveX Data Objects 2.0 Library
Reference=*\G{405C5540-54BA-4352-8F27-8663CA6D6630}#1.0#0#..\..\..\..\Program Files\Common Files\Crystal Decisions\2.5\bin\crystalwizard.dll#Crystal Reports 10 Standard Wizard library
Reference=*\G{DBF72987-0B52-4F0B-A456-4CAE876EE792}#a.0#0#..\..\..\..\Program Files\Common Files\Crystal Decisions\2.5\bin\CRDesignerCtrl.DLL#Embeddable Crystal Reports Designer Control Library 10.0
Object={DBF72987-0B52-4F0B-A456-4CAE876EE792}#10.0#0; CRDesignerCtrl.DLL

simple viewer example

Reference=*\G{00000300-0000-0010-8000-00AA006D2EA4}#2.0#0#..\..\..\Program Files\Common Files\system\ado\msador15.dll#Microsoft ActiveX Data Objects Recordset 1.5 Library
Object={3C62B3DD-12BE-4941-A787-EA25415DCD27}#10.0#0; CRViewer.dll
Reference=*\G{76691052-244D-4C07-8ECA-9FA4F1A25263}#a.0#0#..\..\..\Program Files\Common Files\Crystal Decisions\2.5\bin\craxdrt.dll#Crystal Reports ActiveX Designer Run Time Library 10.0

added to try to view this examples but do not work

Reference=*\G{FB992564-9055-42B5-B433-FEA84CEA93C4}#b.0#0#..\CRViewer.dll#Crystal ActiveX Report Viewer Library 11.0
Reference=*\G{418F8E14-9E24-4057-A167-82A54E9B695B}#1.0#0#C:\Archivos de programa\Archivos comunes\Business Objects\3.0\bin\Cdo32.dll#Crystal Data Object Library 2.7
Reference=*\G{EFA3761F-4265-4464-A2DE-519B8E7E34ED}#b.0#0#C:\Archivos de programa\Archivos comunes\Business Objects\3.0\bin\craxdrt.dll#Crystal Reports ActiveX Designer Run Time Library 11.0
Reference=*\G{2A75196C-D9EB-4129-B803-931327F72D5C}#2.8#0#C:\Archivos de programa\Archivos comunes\System\ADO\msado15.dll#Microsoft ActiveX Data Objects 2.8 Library
Reference=*\G{52A44D15-DEEF-498D-945F-3F50102E042A}#1.0#0#C:\Archivos de programa\Business Objects\BusinessObjects Enterprise 11\win32_x86\plugins\desktop\CrystalEnterprise.LicenseKey\LicenseKey.dll#Crystal Enterprise LicenseKey PlugIn 11.0
Reference=*\G{BD2383E5-593B-47CC-854B-1E227C0DDA33}#1.0#0#C:\Archivos de programa\Business Objects\BusinessObjects Enterprise 11\win32_x86\plugins\desktop\CrystalEnterprise.Program\Program.dll#Crystal Enterprise Program PlugIn 11.0
Object={00025600-0000-0000-C000-000000000046}#4.6#0; crystl32.ocx

i have crystal reports xiSee if you are able to find solution here
www.businessobjects.com

New to Crystal Reports

Hi,

I am new to crystal Reports. I am on a project to migrate database from MS Access to MS SQL 2000 for a project which is in VB6. We are using Crysal Report 7.0. Earlier version reports in MS Access were working fine and used SelectionFormula. I want to use the same thing in my next MS SQL version also. But I don't know where and how to begin.

In my project, user will chose company (from combo box), subcompany (combo box), location (combo box), Item Category (combo box) and press the Report button which triggers the below code. Here each company name, subcompany name, location, item category were from different master tables and list of items for them is in another table. In report I need to list items for user selected company, subcompany, location, item category.

The code is like this:

Private Sub cmdAssetRpt_Click()
Dim crptApp As New CRAXDRT.Application
Dim crptRep As New CRAXDRT.Report

Set crptRep = crptApp.OpenReport(App.Path & "\Reports\AssetDetailsLocationWiseRpt.rpt")
crptRep.RecordSelectionFormula = "{LocationMaster.LocationName}='" & (cboLocation.Text) & _
"'and {ItemDetails.ItemGroupCod}='" & strItemgrpCode & "'"
If frmReports.CRViewer1.IsBusy = False Then
frmReports.CRViewer1.ReportSource = crptRep
frmReports.CRViewer1.DisplayGroupTree = False
frmReports.CRViewer1.ViewReport
End If
Exit Sub
End If
End sub

I was surprised how SelectionFormula will query my database to filter only requiered data and send it to report?
I need complete info about Reports, SelectionFormula, Tips, sample code anything. Plese help me. its urgent for me. Only this work is leftout in my project!!query is inside report, and selection formula just filters records returned by the query.sql

New Role Assignment Question

I have just set up SQL Reporting Services in our Development environment and
want to set all users with browser or read-only access to our reports but do
not see how. I am going in through the web interface and it tells me that I
must have a valid domain group or interface. Any idea on how to just select
"Everyone"?DomainName\Everyone
ComputerName\Everyone
HTH, Jens Süßmeyer
--
http://www.sqlserver2005.de
--
"Charles Collins" <Charles Collins@.discussions.microsoft.com> schrieb im
Newsbeitrag news:234DF76B-A041-4989-A116-6CADDEB19E9B@.microsoft.com...
>I have just set up SQL Reporting Services in our Development environment
>and
> want to set all users with browser or read-only access to our reports but
> do
> not see how. I am going in through the web interface and it tells me that
> I
> must have a valid domain group or interface. Any idea on how to just
> select
> "Everyone"?|||Currently Reporting Services only supports Windows Authentication. Which
means you need to create a network group (with everyone you want) in it and
then give that network group access to the reports. Reporting Services
security is extensible though if you want to create your own security
extension (Not an easy task). Here is link to a microsoft example of
creating your own security extension...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
"Charles Collins" wrote:
> I have just set up SQL Reporting Services in our Development environment and
> want to set all users with browser or read-only access to our reports but do
> not see how. I am going in through the web interface and it tells me that I
> must have a valid domain group or interface. Any idea on how to just select
> "Everyone"?|||When I try that I get:
The user or group name '(domain or computer name)\everyone' is not
recognized. (rsUnknownUserName)
"Jens Sü�meyer" wrote:
> DomainName\Everyone
> ComputerName\Everyone
> HTH, Jens Sü�meyer
> --
> http://www.sqlserver2005.de
> --
> "Charles Collins" <Charles Collins@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:234DF76B-A041-4989-A116-6CADDEB19E9B@.microsoft.com...
> >I have just set up SQL Reporting Services in our Development environment
> >and
> > want to set all users with browser or read-only access to our reports but
> > do
> > not see how. I am going in through the web interface and it tells me that
> > I
> > must have a valid domain group or interface. Any idea on how to just
> > select
> > "Everyone"?
>
>|||Is there an way to assign mulitple users an role at once?
"Jens Sü�meyer" wrote:
> DomainName\Everyone
> ComputerName\Everyone
> HTH, Jens Sü�meyer
> --
> http://www.sqlserver2005.de
> --
> "Charles Collins" <Charles Collins@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:234DF76B-A041-4989-A116-6CADDEB19E9B@.microsoft.com...
> >I have just set up SQL Reporting Services in our Development environment
> >and
> > want to set all users with browser or read-only access to our reports but
> > do
> > not see how. I am going in through the web interface and it tells me that
> > I
> > must have a valid domain group or interface. Any idea on how to just
> > select
> > "Everyone"?
>
>

New Publication

Hi,
I'm trying to set up a new publication on a Veritas Cluster/SQL Server 2005.
The problem i'm having is that sql server reports that in order to do that
"SQL Server replication rquires the actual server name to make a connection
to the server. Connections through a server alias, IP address or any other
alternate name are not supported"
When you run sql on a cluster you virtual names set up. How do i get aroud
this?
Regards
Michael
do this
xp_cmdshell 'hostname'
then do this
select @.@.servername
these should be the same. If not you must do the following
sp_dropserver @.server='OldServerName'
sp_addserver @.server='CorrectServerName', @.local='LOCAL'
As you are on a cluster I am not exactly sure how this is going to work.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Michael_Sergel" <MichaelSergel@.discussions.microsoft.com> wrote in message
news:26053401-B617-4E56-A359-80CB8CDD67D8@.microsoft.com...
> Hi,
> I'm trying to set up a new publication on a Veritas Cluster/SQL Server
> 2005.
> The problem i'm having is that sql server reports that in order to do that
> "SQL Server replication rquires the actual server name to make a
> connection
> to the server. Connections through a server alias, IP address or any other
> alternate name are not supported"
> When you run sql on a cluster you virtual names set up. How do i get aroud
> this?
> Regards
> Michael

New error arithmetic overflow

Just recently I have been getting this error on several computers with
reports that were running fine. I will install RS SP1 but what is going on.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot read the next data row for the data set ProductivityAvg.
(rsErrorReadingNextDataRow) Get Online Help
Arithmetic overflow error converting expression to data type datetimeI get the same error for a couple of users.
An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the data set database_name.
(rsErrorReadingNextDataRow)
Arithmetic overflow error converting expression to data type datetime
Did you ever find the solution to this problem? All the users can access
these reports, except two. Cannot find the discrepancy.
If anyone knows the solution, please post.
thanks,
"Paul Strauss" wrote:
> Just recently I have been getting this error on several computers with
> reports that were running fine. I will install RS SP1 but what is going on.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot read the next data row for the data set ProductivityAvg.
> (rsErrorReadingNextDataRow) Get Online Help
> Arithmetic overflow error converting expression to data type datetime

New Crystal Reporter

Hi everyone. I've been developing an application which needs to create a couple of reports. I was going to use microsoft Graph for the Charts but it turns out that that's not recommendable.

So I decided to get into Crystal Reports. The point is that the help I've found is somewhat generic and I need something a little more specific.

What I need to do is to show a chart with the completed and not completed sales in a specific month. And show another form with the percentages of this sales.

I'm using VB6 and an Access database for my project.

If anybody knows where can I find some help... please let me know

Thanx in advance :wave:Create a query in access that summarizes your sales data by month, giving a field for Year & Month, and fields for Complete and Incomplete.
Use the Report Expert to connect to the Access Database, once connected you should see your query exposed as a Stored Procedure.
Select the query, and select field you wish to show, and then group by month.

When done, you should be able to right-click on the Group Header and select ChangeGroup. If you have a properly formated date CR will auto-recognise and type the field as date, and you should see a dropdown combo with caption "The section will be printed".
Select "for each month" from the combo.

When designing the Chart, select Advanced in the Data tab, and in the "Place Chart" combo, you should be able to select the group name, if you want to print the chart for each month, or select once per report option. Later you will put the Chart in the Group Footer if you selected the option to print each change of date (which in this case means each month, cos that's the group selection formula you selected), or put it in the report footer if you selected the "Once per Report" option.
Then select the summary fields that your SQL statement created from the list named "Available Fields" and put them in the "ShowValue(s)" list.
Oh, and don't forget to select an option for the combo above the "Show Values" one.

That just about ought to get you close......

Dave|||Create a query in access that summarizes your sales data by month, giving a field for Year & Month, and fields for Complete and Incomplete.
Use the Report Expert to connect to the Access Database, once connected you should see your query exposed as a Stored Procedure.
Select the query, and select field you wish to show, and then group by month.

When done, you should be able to right-click on the Group Header and select ChangeGroup. If you have a properly formated date CR will auto-recognise and type the field as date, and you should see a dropdown combo with caption "The section will be printed".
Select "for each month" from the combo.

When designing the Chart, select Advanced in the Data tab, and in the "Place Chart" combo, you should be able to select the group name, if you want to print the chart for each month, or select once per report option. Later you will put the Chart in the Group Footer if you selected the option to print each change of date (which in this case means each month, cos that's the group selection formula you selected), or put it in the report footer if you selected the "Once per Report" option.
Then select the summary fields that your SQL statement created from the list named "Available Fields" and put them in the "ShowValue(s)" list.
Oh, and don't forget to select an option for the combo above the "Show Values" one.

That just about ought to get you close......

Dave

Thanx Dave... I know this maybe a little abusive but, do you have some code so I have another reference?

Anyway... thanx for your reply, I'll try to get it running :wave:|||Do you mean the SQL, or code for the report?
Need to work out what you do and don't know......
Only real code in this is SQL, aprt from a formula you'd need to sum the values of Completed and Not Completed, so something like:

SELECT Id, Date, Completed, Value from Sales WHERE (Sales.Date > DateAdd("d", -14, Date()) AND Sales.Date <= Date())

would give you last 14 days of data.
I'd make Completed field a boolean so you can use it in the report to apply logic to an aggregation.

I've attached a zip file with a small table layout in Excel format. You can import it into Access and then open the report.
You may have to reset the Location to ensure that the ODBC connection on your box works Ok - see Database menu, Set Location... option.

Don't forget, if you find what I've given you useful, remember to rate the post and finalise the thread.

Dave|||I mean the CR Code. That's what I'm new at. The query is not that big of a deal (kind of hehe) but the problem is that I don't know how to import those results to a .rpt

I am checkin the zip you attached and hope to find out a way to create my graph. I'll rate the thread anyway.

Thanx a lot springsoft