Crystal Reports repeated data with SQL database

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: repeated data with SQL database

Author	Message
i-dot Newbie Joined: 17 Sep 2009 Location: Malaysia Online Status: Offline Posts: 14	Topic: repeated data with SQL database Posted: 17 Sep 2009 at 6:29pm
	im using CR with SQL data base. however i have problem whenever i run the report, some of the data is repeated. i cant put the condition because some of the data is ok. is there anybody can help?
	IP Logged


Jyothi Yepuri Senior Member Joined: 11 May 2009 Location: Australia Online Status: Offline Posts: 127	Posted: 17 Sep 2009 at 6:55pm
	can you provide detail information? Jyothi
	IP Logged

i-dot Newbie Joined: 17 Sep 2009 Location: Malaysia Online Status: Offline Posts: 14	Posted: 17 Sep 2009 at 7:12pm
	i have a table which the data such as below: item transaction type qty a1 receipt 40 a1 issue 10 a2 receipt 5 a2 receipt 4 so in CR i made a function; if transaction type = receipt then qty else "0" but when i running the report, for certain item it running ok...but some of them is repeated as per sample below: a1 receipt 40 a1 receipt 40 a2 receipt 5 a2 receipt 4 so for item a1 the data is repeated but a2 is ok. hope you could help me on this. thank you.
	IP Logged

Jyothi Yepuri Senior Member Joined: 11 May 2009 Location: Australia Online Status: Offline Posts: 127	Posted: 17 Sep 2009 at 7:19pm
	Is data coming from single table or have you used any joins? did you place data in details section , used any groups? where exactly u r using this formula? Jyothi
	IP Logged

i-dot Newbie Joined: 17 Sep 2009 Location: Malaysia Online Status: Offline Posts: 14	Posted: 17 Sep 2009 at 8:05pm
	yes i put the formula in the details section and i grouped it by item. the data is in single table but i join the table with another table for list of all item. im actually using Baan V System which using SQL database.
	IP Logged

Jyothi Yepuri Senior Member Joined: 11 May 2009 Location: Australia Online Status: Offline Posts: 127	Posted: 17 Sep 2009 at 8:11pm
	Give detail explanation of what u have done.... "the data is in single table but i join the table with another table for list of all item" ..????????????? its not clear what you are trying to explain Jyothi
	IP Logged

i-dot Newbie Joined: 17 Sep 2009 Location: Malaysia Online Status: Offline Posts: 14	Posted: 17 Sep 2009 at 9:51pm
	sorry ... anyway, i have unlink the table (table for list item), which is now the data is in single table. but the result is same.
	IP Logged

i-dot Newbie Joined: 17 Sep 2009 Location: Malaysia Online Status: Offline Posts: 14	Posted: 26 Sep 2009 at 8:45am
	i think the data is jumble up when the data reach to more than 300 lines (details section). anyone know how to solve it?
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum