Only display the first character issue

[Former Member]

Hi,

I'm using CR 2008 to generate reports.

I use oracle database.

I use a stored procedure to get data and everything working fine ,it return correct data.

I have five details section but i display one details section and i suppress others

My issue is execute the rpt file to presssig F5 key; string type record is only able to print the first character on the preview.

eg: record with value 'ABCDE', after printed on rpt file, only character 'A' was printed on the preview.

if i verify database, it display correct data but a few times later problem occurs again

Anyone know how to fix it?

[former_member11696 · Accepted solution]

Hello,

That is very strange.... How often and how quick are you pressing the F5 key to refresh the data?

How are you connecting, ODBC, OLE DB, JDBC etc.?

Who's ODBC or OLE DB etc. drivers are you using? Example Oracles, Microsoft's, Data Directs...

What version of Oracle are you using and is it 32 or 64 bit Client and Server?

Don

[Former Member · Accepted solution]

I'm connecting to use oracle server. I have 32 bit client

I have five details sections. My procedure return cursor have A, B, C, D, E, F and CODE column.

my report's details section;

section expert supp. func. _ _ _ Columns

CODE not equal 1 suppress true _ _ _ A B C D E F

CODE not equal 2 suppress true _ _ _ B C D E F

CODE not equal 3 suppress true _ _ _ A C D E F

CODE not equal 4 suppress true _ _ _ B C D E F

CODE not equal 5 suppress true _ _ _ A D E F

Today I learn;

If I verify to database according to CODE=1 , first details section working correctly but not others

If I verify to database according to CODE=2 , second details section working correctly but not others also first details section dont

working correctly.

Edited by: assaulter on Oct 7, 2011 10:04 AM

Edited by: assaulter on Oct 7, 2011 10:05 AM

[former_member11696 · Accepted solution]

And how are you connecting? It can make a difference, some drivers results can vary.

What does your Suppress formula look like, please paste them in here.

Don

[Former Member · Accepted solution]

Hey Don,

Some of the Memo fields will do this. Depends on the type. Sorry, I do not remember which type caused the problem.

Debi

[former_member11696 · Accepted solution]

Hi Debi,

I've never heard of this before. Any references where it's been noted/tested/escalated?

If that's the case then how are you defining the fields in your SP? Assaulter can you paste in the SQL to create the SP so we can test it?

Thanks

Don

[Former Member · Accepted solution]

Don,

We have a new database where are the memo fields are different and I no longer have this problem.

And no, I never discussed it here or with SAP I was not here then, and we solved it internally by changing the memo type in the database.

They may have been long LVARCHAR memo fields. While we were dealing with that database we changed the ones I was usin to clob(?) memo fields which resolved the problem. This was awhile back and the only person I could ask today is not sure.

I am going to be gone next week but when I get back I will see if I can get more information on it.

Debi

Edited by: Debi Herbert on Oct 7, 2011 2:51 PM

[Former Member]

if you create a blank report as follows , you will take same error

my reports section;

section - formula fieds

a - - - - a b f g

b - - - - a b e f g

c - - - - a b c e f g

d - - - - c f g

e - - - - d e f g

my details sections suppress formula;

if {CR_TEST.CODE}=1 then false else true

if {CR_TEST.CODE}=2 then false else true

if {CR_TEST.CODE}=3then false else true

if {CR_TEST.CODE}=4 then false else true

if {CR_TEST.CODE}=5 then false else true

my procedure is just like this;

CREATE OR REPLACE PROCEDURE CR_TEST(

P_MONTH IN VARCHAR2

, P_YEAR IN VARCHAR2

, CODE IN NUMBER

, P_CURSOR OUT GP.REF_CURSOR

)

IS

BEGIN

IF CODE = 1

THEN

OPEN P_CURSOR FOR

SELECT A

, B

, 'X' C

, 'X' D

, 'X' E

, F

, G

, CODE CODE

FROM CR_TEST_TABLE

--WHERE conditions

;

ELSIF CODE = 2

THEN

--A, B, E, F, G

OPEN P_CURSOR FOR

SELECT A

, B

, 'X' C

, 'X' D

, E

, F

, G

, CODE CODE

FROM CR_TEST_TABLE

--WHERE conditions

;

ELSIF CODE = 3

THEN

OPEN P_CURSOR FOR

SELECT A

, B

, C

, 'X' D

, E

, F

, G

, CODE CODE

FROM CR_TEST_TABLE

--WHERE conditions

;

ELSIF CODE = 4

THEN

OPEN P_CURSOR FOR

SELECT 'X' A

, 'X' B

, C

, 'X' D

, 'X' E

, F

, G

, CODE CODE

FROM CR_TEST_TABLE

--WHERE conditions

;

ELSIF CODE = 5

THEN

OPEN P_CURSOR FOR

SELECT 'X' A

, 'X' B

, 'X' C

, D

, E

, F

, G

, CODE CODE

FROM CR_TEST_TABLE

--WHERE conditions

;

END IF;

END;

/

Edited by: assaulter on Oct 12, 2011 11:50 AM

Edited by: assaulter on Oct 19, 2011 1:50 PM

[Former Member]

is this a field or a group header?

[Former Member]

it's a field