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

I'm coming in on the back end of a project and I don't understand the following record selection formula. Would someone please explain what it's doing?

if {?@.rptfilter} = 0 then
(isnull({CAS_SP_SolnLosses;1.Contractor}) or not isnull({CAS_SP_SolnLosses;1.Contractor}))
and
(if {?@.typeid} = 0 then
ucase({CAS_SP_SolnLosses;1.Typevalue}) = "ANY"
else
if {?@.typeid} = 1 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.TNex}
else
if {?@.typeid} = 2 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Region}
else
if {?@.typeid} = 3 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Agency}
else
if {?@.typeid} = 4 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Site}
else
if {?@.typeid} = 5 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.AVP}
else
if {?@.typeid} = 6 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.RM}
else
if {?@.typeid} = 7 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Recruiter}
else
if {?@.typeid} = 8 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.ES})
else
if {?@.rptfilter} = 1 then
({CAS_SP_SolnLosses;1.Contractor} = "ARORA" OR {CAS_SP_SolnLosses;1.Contractor} = "CAJV")
and
(if {?@.typeid} = 0 then
ucase({CAS_SP_SolnLosses;1.Typevalue}) = "ANY"
else
if {?@.typeid} = 1 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.TNex}
else
if {?@.typeid} = 2 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Region}
else
if {?@.typeid} = 3 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Agency}
else
if {?@.typeid} = 4 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Site}
else
if {?@.typeid} = 5 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.AVP}
else
if {?@.typeid} = 6 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.RM}
else
if {?@.typeid} = 7 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Recruiter}
else
if {?@.typeid} = 8 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.ES})
else
if {?@.rptfilter} = 2 then
({CAS_SP_SolnLosses;1.Contractor} <> "ARORA" OR {CAS_SP_SolnLosses;1.Contractor} <> "CAJV")
and
(if {?@.typeid} = 0 then
ucase({CAS_SP_SolnLosses;1.Typevalue}) = "ANY"
else
if {?@.typeid} = 1 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.TNex}
else
if {?@.typeid} = 2 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Region}
else
if {?@.typeid} = 3 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Agency}
else
if {?@.typeid} = 4 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Site}
else
if {?@.typeid} = 5 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.AVP}
else
if {?@.typeid} = 6 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.RM}
else
if {?@.typeid} = 7 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Recruiter}
else
if {?@.typeid} = 8 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.ES})This is not an answer to your question, but at least in earlier versions (up to version 8.5) Crystal reports is not able to create an SQL stement based on control structures (If-Then-Else) instead you should convert the record selection formula to a boolean statement using ands and ors and braces. What happens if you don't do this is that Crystal loads the entire answer set to your computer and makes the record selection locally. This has at least two major disadvantages:
1. The query is processed on the database server as a full table join and the query can not make use of any indexes. This can cause performance problems to any DBMS system
2. You cause a lot of network traffic moving unneeded data over the network

This has one implication, which is poor performance.

What concerns your code I have a few suggestions:

(isnull({CAS_SP_SolnLosses;1.Contractor}) or not isnull({CAS_SP_SolnLosses;1.Contractor}))
could be removed in my opinion, because it compares a field to both null and not null

after this you basically create different joins based on different values of
{?@.rptfilter}

Hope this gives you some clues.

- Jukka|||This is not an answer to your question, but at least in earlier versions (up to version 8.5) Crystal reports is not able to create an SQL stement based on control structures (If-Then-Else) instead you should convert the record selection formula to a boolean statement using ands and ors and braces. What happens if you don't do this is that Crystal loads the entire answer set to your computer and makes the record selection locally. This has at least two major disadvantages:
1. The query is processed on the database server as a full table join and the query can not make use of any indexes. This can cause performance problems to any DBMS system
2. You cause a lot of network traffic moving unneeded data over the network

This has one implication, which is poor performance.

What concerns your code I have a few suggestions:

(isnull({CAS_SP_SolnLosses;1.Contractor}) or not isnull({CAS_SP_SolnLosses;1.Contractor}))
could be removed in my opinion, because it compares a field to both null and not null

after this you basically create different joins based on different values of
{?@.rptfilter}

Hope this gives you some clues.

- Jukka

I agree that line you mentioned could be deleted. My problem is understanding the syntax of this *ugly* formula. Unfortunately, the developer that wrote this is long gone and, like I mentioned earlier, it's been dumped in my lap. I've looked over the .pdf's on the CD hoping to find some help, no luck. Are there any other sources which would help me get my head around understanding what this code is doing?

TIA

BTW, is there a way to step thru the formula code with a debugger?|||Hello,

I'm doing project using Access as backend and VB6 FrontEnd. I have the following problem during compilation. I'm using Runtime Activex lib of CR 8.5.

Error: Method or Data member not found

===> Private Sub mnu_stock_Click()
With Form1.CrystalReport1
.DataFiles(0) = App.Path & "\MyDB.MDB"
.ReportFileName = App.Path & "\Report\RPT_AVA_STOCK.rpt"
.username = "Admin"
.Password = "1010101010" & Chr(10) & "1010101010"
.Action = 1
.PageZoom (100)
End With
End Sub

Thank you,

Regards,

Niranjan Dixit|||I agree that line you mentioned could be deleted. My problem is understanding the syntax of this *ugly* formula. Unfortunately, the developer that wrote this is long gone and, like I mentioned earlier, it's been dumped in my lap. I've looked over the .pdf's on the CD hoping to find some help, no luck. Are there any other sources which would help me get my head around understanding what this code is doing?

TIA

BTW, is there a way to step thru the formula code with a debugger?

Here is a try (the syntax is slightly different to what I'm used to using Oracle):
You have the following parameters in your report controlling the outcome:
rptfilter
typeid

comments are marked with a "-"

Fuurther I would still make sure that I have all parenthesis in the right places. I would include an extra round of parenthesis where rptfilter changes values

and the code it self:
if {?@.rptfilter} = 0 then
- rpt filter = 0

(isnull({CAS_SP_SolnLosses;1.Contractor}) or not isnull({CAS_SP_SolnLosses;1.Contractor}))
- This section does nothing

and
(if {?@.typeid} = 0 then
- rptfilter = 0 and typeid = 0

ucase({CAS_SP_SolnLosses;1.Typevalue}) = "ANY"
- When rptfilter = 0 and typeid = 0 then only record having CAS_SP_SolnLosses;1.Typevalue = "ANY" are included

else
if {?@.typeid} = 1 then
- rptfilter = 0 and typeid = 1

{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.TNex}
- When rptfilter = 0 and typeid = 1 then is joined to CAS_SP_SolnLosses;1.Typevalue = {CAS_SP_SolnLosses;1.Region}, i.e. values have to be equal
- Similar for typeid 2 - 8

else
if {?@.typeid} = 2 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Region}
else
if {?@.typeid} = 3 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Agency}
else
if {?@.typeid} = 4 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Site}
else
if {?@.typeid} = 5 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.AVP}
else
if {?@.typeid} = 6 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.RM}
else
if {?@.typeid} = 7 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Recruiter}
else
if {?@.typeid} = 8 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.ES})
else

if {?@.rptfilter} = 1 then
- rptfilter = 1

({CAS_SP_SolnLosses;1.Contractor} = "ARORA" OR {CAS_SP_SolnLosses;1.Contractor} = "CAJV")
- rptfilter = 1 and CAS_SP_SolnLosses;1.Contractor = "ARORA" or CAS_SP_SolnLosses;1.Contractor "CAJV"

and
(if {?@.typeid} = 0 then
ucase({CAS_SP_SolnLosses;1.Typevalue}) = "ANY"
- This is similar to above except that rptfilter has value 1 and further below value 2

else
if {?@.typeid} = 1 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.TNex}
else
if {?@.typeid} = 2 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Region}
else
if {?@.typeid} = 3 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Agency}
else
if {?@.typeid} = 4 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Site}
else
if {?@.typeid} = 5 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.AVP}
else
if {?@.typeid} = 6 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.RM}
else
if {?@.typeid} = 7 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Recruiter}
else
if {?@.typeid} = 8 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.ES})
else
if {?@.rptfilter} = 2 then
({CAS_SP_SolnLosses;1.Contractor} <> "ARORA" OR {CAS_SP_SolnLosses;1.Contractor} <> "CAJV")
and
(if {?@.typeid} = 0 then
ucase({CAS_SP_SolnLosses;1.Typevalue}) = "ANY"
else
if {?@.typeid} = 1 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.TNex}
else
if {?@.typeid} = 2 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Region}
else
if {?@.typeid} = 3 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Agency}
else
if {?@.typeid} = 4 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Site}
else
if {?@.typeid} = 5 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.AVP}
else
if {?@.typeid} = 6 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.RM}
else
if {?@.typeid} = 7 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.Recruiter}
else
if {?@.typeid} = 8 then
{CAS_SP_SolnLosses;1.Typevalue} = {CAS_SP_SolnLosses;1.ES})|||Here is a try (the syntax is slightly different to what I'm used to using Oracle):
You have the following parameters in your report controlling the outcome:
rptfilter
typeid

comments are marked with a "-"

Fuurther I would still make sure that I have all parenthesis in the right places. I would include an extra round of parenthesis where rptfilter changes values
<snip>

Thanks for your help!

New SQL Replication implementation

Hello,

I'm just beginning my R&D on SQL Server Replication for a project and had some questions about what paths to pursue

We have multiple locations which we want to all work off the same set of data essentially, but the kicker is that many of the sites become disconnected for minutes or either days at a time due to their remote locations, so we cannot simply deploy a web application with one SQL backend because remote sites will be unable to work during service disruptions.

Ideally, what I'd like to be able to do is have multiple instances of the SQL server/web applications(one at each site..they all have their own internal network), but which replicates with the main site/all other sites whenever it can(i.e. the internet is available). So one site goes without internet for a few days, they have up to date data from the last replication and they can work off their own sql server/web application, and any updates they've made/or any updates from other sites they've missed during the disconnected period would be replicated when the opportunity arises(ie. the web connectivity comes back)

Is this scenario possible? and I am struggling to find the right strategy path for implementing something like this. Any guidance would be greatly appreciated.

Thanks,

Chris

Yes this is possible. What you want is Merge replication. That will allow updates on the subscribers and they will sync when they are online.

I would recommend making the client a click once .net application rather than a web app as the click once will also update when online however web app will work too on the local servers. You will just need a mechanism to update the pages.

Martin

sql

New SQL Replication implementation

Hello,

I'm just beginning my R&D on SQL Server Replication for a project and had some questions about what paths to pursue

We have multiple locations which we want to all work off the same set of data essentially, but the kicker is that many of the sites become disconnected for minutes or either days at a time due to their remote locations, so we cannot simply deploy a web application with one SQL backend because remote sites will be unable to work during service disruptions.

Ideally, what I'd like to be able to do is have multiple instances of the SQL server/web applications(one at each site..they all have their own internal network), but which replicates with the main site/all other sites whenever it can(i.e. the internet is available). So one site goes without internet for a few days, they have up to date data from the last replication and they can work off their own sql server/web application, and any updates they've made/or any updates from other sites they've missed during the disconnected period would be replicated when the opportunity arises(ie. the web connectivity comes back)

Is this scenario possible? and I am struggling to find the right strategy path for implementing something like this. Any guidance would be greatly appreciated.

Thanks,

Chris

Yes this is possible. What you want is Merge replication. That will allow updates on the subscribers and they will sync when they are online.

I would recommend making the client a click once .net application rather than a web app as the click once will also update when online however web app will work too on the local servers. You will just need a mechanism to update the pages.

Martin

New Project wont compile

I have a new machine with VS2003, VS2005 and SQL 2005 installed. I need to
work in a VS2003 and SQL 2005 project which uses SSRS 2K because where I
deploy it to doesn't have SSRS 2005 (only SSRS 2K). I have been able to
deploy my 2k reports (from my old dev machine) to the production server
where they are using sql05 and ssrs 2k just fine.
On my new dev machine I have installed the report designer for ssrs2k so I
can create ssrs 2k projects in vs2003. however, they wont compile and I
don't get any text for build errors. when I build the project I get the
build error and immediately the output window switches to the task list
where normally I would get a list of build errors. however, in this case
the task list is empty. it appears that something goes sooo wrong that it
cant even list the build errors. I haven't installed SSRS 2k sp1 or 2 yet
as I don't know if that's a good idea in on this machine since it doesn't
actually have SSRS 2k installed on it. any idea how I can trouble shoot
this?
--
moondaddy@.noemail.noemailHello Moondaddy,
I would like to know if you try to click the Output windows, what error
message did you see?
There should be some error message in the Output window.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
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.)|||I don't get any useful messages. Here's the text from the output window
when I build it:
-- Build started: Project: TestVoyagerSSRS_2K, Configuration:
Debug --
Build complete -- 0 errors, 0 warnings
-- Done --
Build: 0 succeeded, 1 failed, 0 skipped
I have nothing else to go on.
Thanks.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OENprYf3GHA.4464@.TK2MSFTNGXA01.phx.gbl...
> Hello Moondaddy,
> I would like to know if you try to click the Output windows, what error
> message did you see?
> There should be some error message in the Output window.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> 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.)
>|||Hello moondaddy,
Does this issue appeared on all the project?
Have you installed any Add-in or other third-party software?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
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.)|||yes it happens on all projects both - old ones copied from the old dev
machine and new ones created on this machine.
no i havent installed any addins. this is a clean machine that was just
setup a few weeks ago and im now bringing online as a full time dev machine.
it has just the basic MS stuff installed. I tried to keep this machine
extra clean so in this case I didnt isntall VS6 and SQL2k, and non of the
WinFX stuff. Just office 2003 pro, Visio 2003, VS2003, VS 2005, SQL 2005
SSRS 2005 and SSRS 2k designer addin.
I have not installed any SPs for SSRS 2K yet.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:raxBUJi3GHA.396@.TK2MSFTNGXA01.phx.gbl...
> Hello moondaddy,
> Does this issue appeared on all the project?
> Have you installed any Add-in or other third-party software?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> 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.)
>|||Hello,
Have you tried other project type like Windows Form project? Does this
issue appeared on other project?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
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.)|||Hello,
I also would like to get the project to try to reproduce this issue on my
side.
You could create a simple report project and refer the Northwind database
as the data source. Then please zip the project folder and send it to me.
I understand the information may be sensitive to you, Please remove ONLINE
in my email address, you may send the file to me directly and I will keep
it secure.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Thanks. I emailed the project to you.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:kNAa$$H4GHA.4916@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> I also would like to get the project to try to reproduce this issue on my
> side.
> You could create a simple report project and refer the Northwind database
> as the data source. Then please zip the project folder and send it to me.
> I understand the information may be sensitive to you, Please remove ONLINE
> in my email address, you may send the file to me directly and I will keep
> it secure.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>|||I have installed SSRS 2K SP2 and am still having the same problem.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:kNAa$$H4GHA.4916@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> I also would like to get the project to try to reproduce this issue on my
> side.
> You could create a simple report project and refer the Northwind database
> as the data source. Then please zip the project folder and send it to me.
> I understand the information may be sensitive to you, Please remove ONLINE
> in my email address, you may send the file to me directly and I will keep
> it secure.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>

New project - thinking of using Visual studio 2005

Hi
I've been developing sql server stored procedures for what seems forever,
right now I just use query analyzer.
I have a new project, and just for a chuckle I'm thinking of using Visual
Studio 2005 for my IDE instead of query analyzer, I'm still pretty much just
going to be creating sql server stored procedures (SQL 2K).
Does anybody have any hints, gotcha's or guidance on whether this is a good
idea, and if so any tips?
I've played around, and one thing I can't find, can I run a SQL and have a
nice output to grid option, like with query analyzer?
The main reason I want to use this, is for being able to put all my sql in a
project, and the integration with sourcesafe.
Thanks in advanceInstead of the 'full' Visual Studio, use the Sql Server Management Studio.
When you disable the 'Summary' tab at startup, it behaves more or less the
same way as ye olde QA, but a little better :)
Yes, you can still have grids and text output :)
Peter
"..." <...@.nowhere.com> wrote in message
news:ehgLtTgQGHA.4896@.TK2MSFTNGP10.phx.gbl...
> Hi
> I've been developing sql server stored procedures for what seems forever,
> right now I just use query analyzer.
> I have a new project, and just for a chuckle I'm thinking of using Visual
> Studio 2005 for my IDE instead of query analyzer, I'm still pretty much
> just going to be creating sql server stored procedures (SQL 2K).
> Does anybody have any hints, gotcha's or guidance on whether this is a
> good idea, and if so any tips?
> I've played around, and one thing I can't find, can I run a SQL and have a
> nice output to grid option, like with query analyzer?
> The main reason I want to use this, is for being able to put all my sql in
> a project, and the integration with sourcesafe.
> Thanks in advance
>|||There is more flexibility within visual studio itself wrt managing your
project (you can add more folders for managing DDL/DML scripts and such).
Typically I manage my project and the source control integration from within
VS and jump back and forth to management studio depending on the specific
task at hand (say building up and testing a specific set of queries within a
larger procedure). SQL management studio allows for source control
integration and projects but is slightly different. The overall impression
I
have gotten from the two is that the SQL management studio projects are
geared more toward DBA work where as VS is more for the DB developer.
HTH
--Tony
"Rogas69" wrote:

> Instead of the 'full' Visual Studio, use the Sql Server Management Studio.
> When you disable the 'Summary' tab at startup, it behaves more or less the
> same way as ye olde QA, but a little better :)
> Yes, you can still have grids and text output :)
> Peter
> "..." <...@.nowhere.com> wrote in message
> news:ehgLtTgQGHA.4896@.TK2MSFTNGP10.phx.gbl...
>
>

New Project - Should I use MS technology?

Wow, this is exciting. I've just got a new project request. It's for
building a statement processing system. Customer send us data, we merge the
data with an existing report layout, then we print and send back to the
customer for distibution.
Sounds simple enough right? Use Crystal or SQL Server Reporting to create
the reports, convert the data to a standardized dataset, merge with the
report and send to the printer. But wait (and this is the part that scares
me), how many statements are we talking about? As little as 50, but up to
150,000, and we're talking about 4-8 pages, with images and graphs.
I've worked with Crystal and SQL Reporting Services, but I just don't think
either of them can handle jobs of this magnatued. Anybody used either of
these for something of that scale? I'm thinking of telling the project
sponsor that it would be better to call our IBM Rep and get them to put us a
solution together. What do you think?
DaveHi posted a request for help in scaling RS a couple of days ago but as yet
no responses.
"David Young" <REMOVE_THIS.dmy75252@.yahoo.com> wrote in message
news:OXvzfAdQFHA.3144@.tk2msftngp13.phx.gbl...
> Wow, this is exciting. I've just got a new project request. It's for
> building a statement processing system. Customer send us data, we merge
> the
> data with an existing report layout, then we print and send back to the
> customer for distibution.
> Sounds simple enough right? Use Crystal or SQL Server Reporting to create
> the reports, convert the data to a standardized dataset, merge with the
> report and send to the printer. But wait (and this is the part that
> scares
> me), how many statements are we talking about? As little as 50, but up to
> 150,000, and we're talking about 4-8 pages, with images and graphs.
> I've worked with Crystal and SQL Reporting Services, but I just don't
> think
> either of them can handle jobs of this magnatued. Anybody used either of
> these for something of that scale? I'm thinking of telling the project
> sponsor that it would be better to call our IBM Rep and get them to put us
> a
> solution together. What do you think?
> Dave
>
>|||>> sounds like a good project indeed !
>> I guess MSFT only can say whether RS can handle loads of this magnitude but in the meantime, have you looked at the data-driven subscription feature in RS ? --
>> RS can be installed in load-balanced farm -- you may have to write code to receive data from customers and then send it to a load-balanced reporting servers -
>> It is not easy to automatically send reports to the printer in SQL2000RS -- there is a printer delivery extension that you need to compile and install and make it work - instead you can setup a schedule to save the reports to a fileshare and email the reports to your customers
>>Also, before calling the IBM rep, you might want to take a look at BizTalk2004 server - just a quick-read thru its documentation may give you more ideas.
>> Another idea before calling the IBM rep - is to call someone like Hitachi Consulting and see if they can handle this project.
regards
ranga raghuram
"David Young" wrote:
> Wow, this is exciting. I've just got a new project request. It's for
> building a statement processing system. Customer send us data, we merge the
> data with an existing report layout, then we print and send back to the
> customer for distibution.
> Sounds simple enough right? Use Crystal or SQL Server Reporting to create
> the reports, convert the data to a standardized dataset, merge with the
> report and send to the printer. But wait (and this is the part that scares
> me), how many statements are we talking about? As little as 50, but up to
> 150,000, and we're talking about 4-8 pages, with images and graphs.
> I've worked with Crystal and SQL Reporting Services, but I just don't think
> either of them can handle jobs of this magnatued. Anybody used either of
> these for something of that scale? I'm thinking of telling the project
> sponsor that it would be better to call our IBM Rep and get them to put us a
> solution together. What do you think?
> Dave
>
>

New named instance.

I am going to be using our SQL Server to manage a project
database. SQL Server is installed on our Windows 2000
server using SBS. Currently there is a named
instance "SERVER1\BKUPEXEC" that is being used by Backup
Exec. Do I need to create a new named instance to use as
for my database manager or can I safely use the existing
instance?| I am going to be using our SQL Server to manage a project
| database. SQL Server is installed on our Windows 2000
| server using SBS. Currently there is a named
| instance "SERVER1\BKUPEXEC" that is being used by Backup
| Exec. Do I need to create a new named instance to use as
| for my database manager or can I safely use the existing
| instance?
--
In general, using a single instance of SQL Server for all database work is
best practice, to wit:
- You can have as many as 32, 767 databases per instance but you can only
have up to 16 instances on one server.
- Using 16 databases in one instances requires less resources than having 1
database for each of your 16 instances on the server.
The only advantage with using several instances is that if one instance
crashes for whatever reason, the other instances are not affected.
Hope this helps,
--
Eric Cárdenas
SQL Server support