okay, how does THIS work?

I'm relatively new to Crystal Reports, and have a bunch of reports that are run from a proprietary application. Since the proprietary software people charge a mint for modifications to the reports, and it takes them months to do so, we purchased a copy of CR, and I've been doing modifications to the reports. Now, each report has a data source behind it, generally calling a SQL Server stored procedure. Problem is, the data source is not one we have here (not server name, user, or anything) so I can't log in to it. The stored procedures that are being called are named the same as those in our database, but I just renamed the procedure from one report on our SQL Server(thus the one the report is calling no longer exists on our server), and the report still runs fine! The data in the reports matches our database, but obviously, the stored procedures are coming from somewhere else. So my question is, where the H are the stored procedures being called by this report?Changing the name of the stored procedure wont affect the actual data source because it is only the alias displayed to the user. You can anything here.

To change the actual data source you need to change it from 'Set Location'

Odd Sum() problem

Hi everyone, first time posting here.

I am having an odd problem with Crystal Reports XI. I have a small database table in Oracle, only has 8 records in it. I want to do a grand total for each column in the database (adding up all 8 records).

But when I use the Sum(fieldname) command, I get a number that is way off. The other commands like Maximum(fieldname) return the value I expect. But Sum is way off.

I am using the columns in a different part of the report, and the report is broken down into sections that match the different records of this database. What I need is a grand total for each column for the whole report.

I even tried a running total, and it returns the same number that is more than twice what it should be. There has to be something I am missing.

Thanks for the help. I am pretty new to .net and programming so I might have used the wrong terms for something.Is the detail section hidden or supressed? If so, have you checked to see if you are selecting distinct records? When you run te report what is the record count in the lower right corner of the screen? It should only be 8.

ODBC to connect crystal report 8.5 and lotus notes 6.5

Hi:

I wanted to connect crystal report 8.5 with Domino lotus notes 6.5 through ODBC , so does any one know which ODBC i can use and how to download it ??

I found some where on internet that I have to use "NotesSQL" driver for this but I don't know what is that and from where to download

Thanks
-Jayesh MendparaHi all:

I found answer for my query and I am posting here because it might be useful to somebody else ,,

to conenct crystal report and domino's lotus notes your need NotesSQL ODBC driver and you can download it from ibm.com

Thanks

-Jayesh Mendpara

ODBC Select Data Source in Crystal reports - continuously prompts

I've created an ODBC entry for crystal reports. When I go to refresh and
run a report, it always prompts me with a select data source and SQL server
is at the bottom of the list under dBase, Excel and MS Access Database. If
I select it, the report runs. How do I have it automatically choose that
source so I don't have to select it each time?
Thank you.You should ask this question in a Crystal support newsgroup or site.
This one is for SQL Server, so your pickings will be slim.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 13:41:50 -0500, "microsoft"
<advice1one@.hotmail.com> wrote:

quote:

---

>I've created an ODBC entry for crystal reports. When I go to refresh and
>run a report, it always prompts me with a select data source and SQL server
>is at the bottom of the list under dBase, Excel and MS Access Database. If
>I select it, the report runs. How do I have it automatically choose that
>source so I don't have to select it each time?
>Thank you.
>

---

|||Thank you, I figured it out, I needed to change the ODBC connector to named
pipes.
"Mary Chipman" <mchip@.nomail.please> wrote in message
news:do51vv0gshsu7e2g9mr6bl0i9sinf4bq4t@.
4ax.com...

quote:

---

> You should ask this question in a Crystal support newsgroup or site.
> This one is for SQL Server, so your pickings will be slim.
> -- Mary
> MCW Technologies
> http://www.mcwtech.com
> On Fri, 26 Dec 2003 13:41:50 -0500, "microsoft"
> <advice1one@.hotmail.com> wrote:
>
server[QUOTE]
If[QUOTE]
>

---

ODBC Issue

Am I missing somthing obvious here. I create an ODBC System dataSource
programatically and I can see it in the registry.
However Crystal Reports or ODBC Admin fail to list it. Is there some other
area this info is held?
Chris
If you're sure the key is correct then it should show up.
You may want to check your MDAC installation. You can use
component checker to check MDAC - it's available at:
http://msdn.microsoft.com/data/mdac/...s/default.aspx
-Sue
On Tue, 3 May 2005 21:55:39 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Am I missing somthing obvious here. I create an ODBC System dataSource
>programatically and I can see it in the registry.
>However Crystal Reports or ODBC Admin fail to list it. Is there some other
>area this info is held?
>Chris
>
|||Sue
I am unsure why MDAC would be an issue here. Is this something you have
seen?
I am 100% sure the key is ok. If I use regedit all the settings under ODBC
key are there and correct
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:h3hg71p51u9jmk0qilg9bc9dgd4ohra48t@.4ax.com...
> If you're sure the key is correct then it should show up.
> You may want to check your MDAC installation. You can use
> component checker to check MDAC - it's available at:
> http://msdn.microsoft.com/data/mdac/...s/default.aspx
> -Sue
> On Tue, 3 May 2005 21:55:39 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
|||Some of the MDAC files are for the ODBC Data Source
Administrator applet.
-Sue
On Wed, 4 May 2005 15:40:01 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Sue
>I am unsure why MDAC would be an issue here. Is this something you have
>seen?
>I am 100% sure the key is ok. If I use regedit all the settings under ODBC
>key are there and correct
>Chris
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:h3hg71p51u9jmk0qilg9bc9dgd4ohra48t@.4ax.com.. .
>
|||Ok Will look into this
Thanks
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:aggh71hflsunqgp3mvn90r2o8lkc7nbdrn@.4ax.com...
> Some of the MDAC files are for the ODBC Data Source
> Administrator applet.
> -Sue
> On Wed, 4 May 2005 15:40:01 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
|||Sue
The checker showed all was ok with the installation. So back to square one
Chris
"Chris Spencer" <chris@.myLeftFoot.com.au> wrote in message
news:%23ipjh3OUFHA.3392@.TK2MSFTNGP12.phx.gbl...
> Ok Will look into this
> Thanks
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:aggh71hflsunqgp3mvn90r2o8lkc7nbdrn@.4ax.com...
>
|||Post the code you are using. The only way I can reproduce it
if I miss something in code in creating the DSNs.
-Sue
On Fri, 6 May 2005 06:34:37 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Sue
>The checker showed all was ok with the installation. So back to square one
>Chris
>"Chris Spencer" <chris@.myLeftFoot.com.au> wrote in message
>news:%23ipjh3OUFHA.3392@.TK2MSFTNGP12.phx.gbl...
>
|||Sue
I am not using VB but in a 4GL so the code may not be useful. However you
said that the only way you can reproduce it is if you miss something in
code.
However if there is something I am missing the VB code (I assume thats what
you are using) that you are using may be illustrative to me where I am going
wrong.
If not is there a list of what needs to be done as I believe I am doing all
that is required to the registry
Chris Spencer
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:v25081t0fmbt88752luib8u7cc3hr3j49u@.4ax.com...
> Post the code you are using. The only way I can reproduce it
> if I miss something in code in creating the DSNs.
> -Sue
> On Fri, 6 May 2005 06:34:37 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>

ODBC Issue

Am I missing somthing obvious here. I create an ODBC System dataSource
programatically and I can see it in the registry.
However Crystal Reports or ODBC Admin fail to list it. Is there some other
area this info is held?
ChrisIf you're sure the key is correct then it should show up.
You may want to check your MDAC installation. You can use
component checker to check MDAC - it's available at:
http://msdn.microsoft.com/data/mdac...ds/default.aspx
-Sue
On Tue, 3 May 2005 21:55:39 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Am I missing somthing obvious here. I create an ODBC System dataSource
>programatically and I can see it in the registry.
>However Crystal Reports or ODBC Admin fail to list it. Is there some other
>area this info is held?
>Chris
>|||Sue
I am unsure why MDAC would be an issue here. Is this something you have
seen?
I am 100% sure the key is ok. If I use regedit all the settings under ODBC
key are there and correct
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:h3hg71p51u9jmk0qilg9bc9dgd4ohra48t@.
4ax.com...
> If you're sure the key is correct then it should show up.
> You may want to check your MDAC installation. You can use
> component checker to check MDAC - it's available at:
> http://msdn.microsoft.com/data/mdac...ds/default.aspx
> -Sue
> On Tue, 3 May 2005 21:55:39 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
>|||Some of the MDAC files are for the ODBC Data Source
Administrator applet.
-Sue
On Wed, 4 May 2005 15:40:01 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Sue
>I am unsure why MDAC would be an issue here. Is this something you have
>seen?
>I am 100% sure the key is ok. If I use regedit all the settings under ODBC
>key are there and correct
>Chris
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:h3hg71p51u9jmk0qilg9bc9dgd4ohra48t@.
4ax.com...
>|||Ok Will look into this
Thanks
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:aggh71hflsunqgp3mvn90r2o8lkc7nbdrn@.
4ax.com...
> Some of the MDAC files are for the ODBC Data Source
> Administrator applet.
> -Sue
> On Wed, 4 May 2005 15:40:01 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
>|||Sue
The checker showed all was ok with the installation. So back to square one
Chris
"Chris Spencer" <chris@.myLeftFoot.com.au> wrote in message
news:%23ipjh3OUFHA.3392@.TK2MSFTNGP12.phx.gbl...
> Ok Will look into this
> Thanks
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:aggh71hflsunqgp3mvn90r2o8lkc7nbdrn@.
4ax.com...
>|||Post the code you are using. The only way I can reproduce it
if I miss something in code in creating the DSNs.
-Sue
On Fri, 6 May 2005 06:34:37 +1000, "Chris Spencer"
<chris@.myLeftFoot.com.au> wrote:

>Sue
>The checker showed all was ok with the installation. So back to square one
>Chris
>"Chris Spencer" <chris@.myLeftFoot.com.au> wrote in message
>news:%23ipjh3OUFHA.3392@.TK2MSFTNGP12.phx.gbl...
>|||Sue
I am not using VB but in a 4GL so the code may not be useful. However you
said that the only way you can reproduce it is if you miss something in
code.
However if there is something I am missing the VB code (I assume thats what
you are using) that you are using may be illustrative to me where I am going
wrong.
If not is there a list of what needs to be done as I believe I am doing all
that is required to the registry
Chris Spencer
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:v25081t0fmbt88752luib8u7cc3hr3j49u@.
4ax.com...
> Post the code you are using. The only way I can reproduce it
> if I miss something in code in creating the DSNs.
> -Sue
> On Fri, 6 May 2005 06:34:37 +1000, "Chris Spencer"
> <chris@.myLeftFoot.com.au> wrote:
>
>