Hi,
Thanks for suggestion, have tried that and set the format
there but it still has the same problem ! It seems logical that it is something in Crystal Reports itself, do you know of any where else that you set default data types in crystal reports ?
Thanks,
Cli
Hi,
When I select the date in both machines in a sql plus session it looks the same. If I execute the store procedure on both machines just from a sql pus session it runs fine and inserts correctly. If I call the store procedure from the crystal reports in the secong machine it falls over...
Hi ,
Thanks for your suggestion. I am now not convinced it is an oracle setting but think that I am now closer to a soltion.
The error I am getting is ODBC error: [MERANT][ODBC ORacle 8 driver][Oracle 8]ORA-06550;line1,column8;
PLS--00306: wrong number or types of arguments in call to...
Hi,
I am using Oracle 8i and crystal reports 8.5. I have several reports which are populated by procedures from on the database.
These procedures substring a date for use in if statements and concatenates it back together for a parameter. For some reason this works fine on my machine but not...
Hi,
I would appreciate any help with this please !
I am trying to make the sql below more dynamic
SELECT TB_NAT.CL_NAT,
SUM(DECODE(TB_BAT.DE_STATUS,'JR',1,0)) AS JR,
SUM(DECODE(TB_BAT.CL_GENDER_CODE,1,1,0)) MALE,
SUM(DECODE(TB_BAT.CL_GENDER_CODE,2,1,0)) FEMALE
FROM tb_BAT, TB_NAT
WHERE...
Hi,
I would appreciate any help with this please !
I am trying to make the sql below more dynamic
SELECT TB_NAT.CL_NAT,
SUM(DECODE(TB_BAT.DE_STATUS,'JR',1,0)) AS JR,
SUM(DECODE(TB_BAT.CL_GENDER_CODE,1,1,0)) MALE,
SUM(DECODE(TB_BAT.CL_GENDER_CODE,2,1,0)) FEMALE
FROM tb_BAT, TB_NAT
WHERE...
Hi,
thanks a million for this suggestion... I have tried this and if the table isn't there this piece of sql runs fine, but if the table is there it still doesn't drop...it doesn't seem to execute the drop command
also why is it a bad idea to create a temp table in the before report trigger...
Hi,
would totally appreciate help..new to sql
I am tyring to check if a table exists from trigger in oracle reports before creating it. My code complied fine but has an error saying command not ended properly when irun it.
code:
******************************************************...
Hi ,
Have tried this but unfortunately it gives the same answer as
select sum (table1.column1 - table2.column2)
from table1, table2;
for some reason doing the way you suggested subtracts before it sums...
any other ideas ???
HI !
I am trying to subtract the sum of two different columns on two different tables from each other. If I write my sql as:
Select sum(table1.column1- table2.column2)
from table1, table2;
I get the wrong answer it subtracts the columns before summing them.
So now I have created a stored...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.