OraFAQ Forum: Reports & Discoverer » Data inserted twice in report

Home » Developer & Programmer » Reports & Discoverer » Data inserted twice in report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data inserted twice in report [message #455202]

Mon, 10 May 2010 11:24

shanmugarajanbu
Messages: 18
Registered: August 2009
Location: chennaI

Junior Member

Dear all,

I have a report for this report i want to insert a data into one table. when am inserting the data then two time its inserted. if i run the report its inserted the data and i have taken the pdf file then also inserted 2 time for this any one help me.

Note: This report having only one group.
not necessary below method give any other solution
if destype=pdf then
no need to insert otherwise insert the data

Regards,
Shan

Report message to a moderator

Re: Data inserted twice in report [message #455204 is a reply to message #455202]

Mon, 10 May 2010 11:30

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

What code are you using to do the insert?
Where is the code run from?

Report message to a moderator

Re: Data inserted twice in report [message #455242 is a reply to message #455204]

Mon, 10 May 2010 15:49

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I guess that, if you ran the report once again, you'd also insert the same record(s). And again, and again - as many times as you run the report. It probably means that you designed it wrong. Perhaps you should first check whether such data already exist; if so, skip inserting.

Report message to a moderator

Re: Data inserted twice in report [message #456850 is a reply to message #455242]

Wed, 19 May 2010 12:07

shanmugarajanbu
Messages: 18
Registered: August 2009
Location: chennaI

Junior Member

Dear All,
Thanks for your replay.

I have used the formula column for inserting the data( i have used INSERT statement ).
In this report having only one group so i have written the code in that group.

Regs,
Shan

Report message to a moderator

Re: Data inserted twice in report [message #456927 is a reply to message #456850]

Thu, 20 May 2010 03:47

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why not use the before report trigger?

Report message to a moderator

Re: Data inserted twice in report [message #457005 is a reply to message #456927]

Thu, 20 May 2010 12:06

shanmugarajanbu
Messages: 18
Registered: August 2009
Location: chennaI

Junior Member

Dear,

I have used the after report trigger and before report trigger also but i have faced same problem .

Regs,
Shan

Report message to a moderator

Re: Data inserted twice in report [message #457010 is a reply to message #457005]

Thu, 20 May 2010 13:23

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

1) We don`t know what kind of report you have.
2) We don`t know you are using those before/after trigger.
3) We don`t know What you are expecting.
4) So post the code you are using right now it will be better provide us the requirements properly to help you

sriram Smile

[Updated on: Sat, 22 May 2010 23:20]

Report message to a moderator

Re: Data inserted twice in report [message #457244 is a reply to message #457010]

Sat, 22 May 2010 08:30

shanmugarajanbu
Messages: 18
Registered: August 2009
Location: chennaI

Junior Member

Dear Sriram

please chk the attached file then u will know.

Attachment: tests_pdf.pdf
(Size: 248.91KB, Downloaded 1984 times)

Report message to a moderator

Re: Data inserted twice in report [message #457251 is a reply to message #457244]

Sat, 22 May 2010 09:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why cursor? You declare it, open it, fetch, close. The same could have been done in a single SELECT statement.

Why nested BEGIN-END? The same could have been done in a single BEGIN-END block.

What causes the "Message" to appear? You didn't post that code. Is it, perhaps, responsible for duplicate record?

If you don't want to insert the same value twice, include check whether it already exists into the WHERE clause (the one you used for the "rec_serial" cursor. Just don't use a cursor).

Besides, will your users REALLY run the report through Reports Builder? I don't think so.

Report message to a moderator

Re: Data inserted twice in report [message #457286 is a reply to message #457251]

Sun, 23 May 2010 00:57

shanmugarajanbu
Messages: 18
Registered: August 2009
Location: chennaI

Junior Member

hi,

if i run the report then data inserted and i have taken the pdf file then also data inserted again. This is the my problem.

if i taken the pdf file then data should not be insert. this is my requirement.

Note :-
not necessary below method give any other solution
if destype=pdf then
no need to insert otherwise insert the data

hi, sriram am waiting for your replay.I thing you are able to find out the solution.

Regs
shan

Report message to a moderator

Previous Topic:	REP-52266, REP-50503
Next Topic:	order in matrix report column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 23:38:12 CST 2025