plzz help urgent

hi friends,
this is kesh here. i hav doubts in creating crystal reports. how to convert the crystal reports in pervasive.sql2000i to DB2.
i am totally confused .plz help me in finding out a way.
thanx in advance.open the report and use SelLocation & Set Alias|||open the report and use SelLocation & Set Alias

It should be SetLocation

Plzz help error failed to export crystal report

i ma trying to solve a problem for a couple of days and cannot get around it..I have installed the whole crystal report software on my development machine and have created a report.. and when i try to export it it gaves me failed to export error..if i try like html..it expots but for pdf and rtf it isn't..

on the other side i want to use this report in my vb application..for the time being since the crystal reports install all the files so i dont have to include runtime files for crystsal report to run with vb..i called the report and can export it in html but for pdf and other formats ..even i have enabled the enableexport button..it just doesnt do any thing..how ever when i try to do it manually..by code..pdf export it gives me the same error..failed to export..

i have reinstalled the whole things and this does not work can anyone plzz help meSearch for your solution here
http://support.businessobjects.com/

Plz Tell me what I did wrong...

I have a column in my crystal report(of VB.Net 2005),this column is a Balance where there's fo example '1000 C' or '1000D' in the page footer I want the sum of this column,since it's type is string because of the letters Cr and Db I created a formula,named SumBalance:

numberVar SumBalance;
SumBalance:=0;
whilereadingrecords;
if Right({StatOfAcc.Balance}, 1)="C" then
SumBalance=SumBalance-ToNumber(Left ({StatOfAcc.Balance},Length ({StatOfAcc.Balance})-2 ))
else
SumBalance= +ToNumber(Left ({StatOfAcc.Balance},Length ({StatOfAcc.Balance}) -2));

I had put this formula in the page footer it gave me False,and if I right click,
FormatObject,I find a tab Boolean,where did I specify that my formula is a boolean...Wher's my error...Plz Tell meI knew my wrong it's that I have to write
SumBalance := not SumBalance=

But this formula is not doing what I'm expecting to do,it give me the last Balance but I need the sum of all the line of the column Balance...|||You put the formula in the page footer, so it'll run once per page and it'll only work on the last record for the page.
If you move it to the detail section (where it should be to work on every record) you shouldn't reset SumBalance to 0 every time in the 2nd line, you should create a new formula for the page header to do this. You'll then need another formula for the page footer to display the balance.
Does a balance of 0 have either C or D after it?
Do you really want to subtract Credits and add Debits?
Your previous post said you had Cr or Db on the end of the balance, and this formula half says that too - you are checking the rightmost character for 'C' but then discarding the rightmost two characters to get the number.
And finally, what's the business logic in summing a balance field?

Pls help me on the following sql select - I get an error message

Hi
I get an error : ODBC ERROR - Incorrect syntax near , from Crystal SQL
reports.
Your help is really appreciated
SELECT
National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code"
FROM
"nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
National_Oxygen_Pte_Ltd_Customer_Budget
WHERE
(National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_" ,
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code") NOT IN (SELECT
National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer No_",
National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category Code" FROM
"nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
'2005-03-01 00:00:00.00'} AND
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts '2005-03-3
1
00:00:01.00'}Radha,
Why did you use , at the where condition?
National_Oxygen_Pte_Ltd_Custo=ADmer_Budg
et."Customer No_" ,
National_Oxygen_Pte_Ltd_Custom=ADer_Budg
et."Item Category Code")
Is this a column?

Pls help me on the following sql select

Hi
I get an ODBC ERROR - Incorrect syntax near , from crystal reports 8.5. any
help is realy appreciated
SELECT
National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
FROM
"nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
National_Oxygen_Pte_Ltd_Customer_Budget
WHERE
(National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_" ,
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code") NOT IN (SELEC
T
National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer No_",
National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category Code" FROM
"nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
'2005-03-01 00:00:00.00'} AND
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts '2005-03-3
1
00:00:01.00'}Hi Radha
Just try this way
SELECT
National_Oxygen_Pte_Ltd_Customer_Budget.[Customer No_],
National_Oxygen_Pte_Ltd_Customer_Budget.[Mar Amount],
National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code],
FROM
nox.dbo.[National Oxygen Pte Ltd$Customer Budget]
National_Oxygen_Pte_Ltd_Customer_Budget
WHERE
(National_Oxygen_Pte_Ltd_Customer_Budget
.[Customer No_] ,
National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code]) NOT IN (SELEC
T
National_Oxygen_Pte_Ltd_Sales Invoice_Line.[Customer No_],
National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne.[Item Category Code] FROM
nox.dbo.[National Oxygen Pte Ltd$Sales Invoice Line]
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] >= {ts
'2005-03-01 00:00:00.00'} AND
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] < {ts '2005-03-3
1
00:00:01.00'}
please let me know if there are any issues
thanks and regards
Chandra
"Radharaj" wrote:

> Hi
> I get an ODBC ERROR - Incorrect syntax near , from crystal reports 8.5. an
y
> help is realy appreciated
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
> National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
> National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
> FROM
> "nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE
> (National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_" ,
> National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code") NOT IN (SEL
ECT
> National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer No_",
> National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category Code" FROM
> "nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts '2005-03
-31
> 00:00:01.00'}|||That won't do if you're hitting against sqlserver.
Sqlserver does not support row constructors so such query will fail.
Try this instead:
SELECT
National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
FROM
"nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
National_Oxygen_Pte_Ltd_Customer_Budget
WHERE NOT exists (SELECT *
FROM "nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne
WHERE
National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer
No_" =National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_"
AND National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category
Code" =National_Oxygen_Pte_Ltd_Customer_Budget
."Item Category Code"
AND National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
'2005-03-01 00:00:00.00'} AND
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts
'2005-03-31 00:00:01.00'}
-oj
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:F136E31C-9006-4817-B854-A0AB994F5E8C@.microsoft.com...
> Hi Radha
> Just try this way
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget.[Customer No_],
> National_Oxygen_Pte_Ltd_Customer_Budget.[Mar Amount],
> National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code],
> FROM
> nox.dbo.[National Oxygen Pte Ltd$Customer Budget]
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE
> (National_Oxygen_Pte_Ltd_Customer_Budget
.[Customer No_] ,
> National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code]) NOT IN
> (SELECT
> National_Oxygen_Pte_Ltd_Sales Invoice_Line.[Customer No_],
> National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne.[Item Category Code] FROM
> nox.dbo.[National Oxygen Pte Ltd$Sales Invoice Line]
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] < {ts
> '2005-03-31
> 00:00:01.00'}
> please let me know if there are any issues
> thanks and regards
> Chandra
>
> "Radharaj" wrote:
>|||Hi Chandra
Thanks for your response. However I am still getting the same error message
Regards
Raj
"Chandra" wrote:
> Hi Radha
> Just try this way
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget.[Customer No_],
> National_Oxygen_Pte_Ltd_Customer_Budget.[Mar Amount],
> National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code],
> FROM
> nox.dbo.[National Oxygen Pte Ltd$Customer Budget]
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE
> (National_Oxygen_Pte_Ltd_Customer_Budget
.[Customer No_] ,
> National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code]) NOT IN (SEL
ECT
> National_Oxygen_Pte_Ltd_Sales Invoice_Line.[Customer No_],
> National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne.[Item Category Code] FROM
> nox.dbo.[National Oxygen Pte Ltd$Sales Invoice Line]
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] < {ts '2005-03
-31
> 00:00:01.00'}
> please let me know if there are any issues
> thanks and regards
> Chandra
>
> "Radharaj" wrote:
>|||Hii oj
thanks a ton!! It works
Regards
Raj
"oj" wrote:

> That won't do if you're hitting against sqlserver.
> Sqlserver does not support row constructors so such query will fail.
> Try this instead:
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
> National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
> National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
> FROM
> "nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE NOT exists (SELECT *
> FROM "nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne
> WHERE
> National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer
> No_" =National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_"
> AND National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category
> Code" =National_Oxygen_Pte_Ltd_Customer_Budget
."Item Category Code"
> AND National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts
> '2005-03-31 00:00:01.00'}
> --
> -oj
>
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:F136E31C-9006-4817-B854-A0AB994F5E8C@.microsoft.com...
>
>|||Dear Oj
Thanks a ton!! It works
Regards
Raj
"oj" wrote:

> That won't do if you're hitting against sqlserver.
> Sqlserver does not support row constructors so such query will fail.
> Try this instead:
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
> National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
> National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
> FROM
> "nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE NOT exists (SELECT *
> FROM "nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne
> WHERE
> National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer
> No_" =National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_"
> AND National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category
> Code" =National_Oxygen_Pte_Ltd_Customer_Budget
."Item Category Code"
> AND National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts
> '2005-03-31 00:00:01.00'}
> --
> -oj
>
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:F136E31C-9006-4817-B854-A0AB994F5E8C@.microsoft.com...
>
>

Pls Help : "Unable To Connect to Sql Server ..." from Crystal 8.0

Hi All,
I am using Crystal Report 8.0 to create report on MSDE 2000 sp3a , but
when I try to make connection Natively :
More Data Source->MiCrosoft SQL Server-> [Dialog opens]
then I type the ServerName, UserID and Password.
System hangs for a while, then I get this error :
"Unable To Connect to Sql server MyServer"
BUT IF I create system DSN (ODBC) then create the report,
it works.
Why can't I create report Natively on MSDE ?
Thank you very much for any help,
Krist
I'm not very familiar with Crystal Reports. However, since you can make an
ODBC connection, you can test if you are able to make OLEDB connections by
creating a UDL file connection. If the UDL file connection fails, then the
issue may be specific to the OLEDB driver for sql server (you want to
attempt to reinstall MDAC if that is the case).
Also, please see the KB articles below (available at
http://support.microsoft.com):
SAMPLE: How to Create a Data Link File with Windows 2000 - ID: 244659
How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422
Thanks,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Please helpInvalid Template Error

I have written a report for a client in Crystal 8 and when they try to run it they get an Invalid Template Error. I run it against various data and I have no problems at all. I have searched all over the Internet and can not find a solution to this problem and my client is getting very upset. Please help.Make sure all the required dlls and dependencies are installed/registered properly on the Client machine. In CR 8.5, there's a file called runtime.hlp that lists all the required files, maybe version 8 has something similar?