Crystal Reports Converting Existing RPT from 8.5 to 11.5

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

Topic: Converting Existing RPT from 8.5 to 11.5
	<< Prev Page of 3 Next >>

Author	Message
hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 27 Aug 2009 at 10:51am
	If the 8.5 report works with the pasted query, I would try taking out any conditions that are in the Select Expert and just use the updated query. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 30 Aug 2009 at 8:44pm
	Hi Dell, I have modified the manually edited condition in sql of crystal 8.5 meaning, i just removed the edited condition and added that condition into the record selection formula then the report is cleanly moving to Crystal XI and when i tried to run that report in CMC it was successful. Anywayz ur information was very helpful to me. I have another question for you. Some of the reports when i tried to run in crystal 8.5 as well as crystal XI were not populating any data. I will provide you with more information about this. I believe the reason is that we have changed the server that report is connecting to. Is this considered to be a restriction in not populating data? Thanks, Nav
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 31 Aug 2009 at 6:27am
	I would make sure that your connection is set up correctly. Did you just change the server you're logging in to? Or did you use "Set Location"? Is the schema owner the same on both servers? If not and you didn't use Set Location, that would explain the problem you're seeing. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 31 Aug 2009 at 8:46am
	Well we have just changed the server, and also just to make sure that its pointing to the correct table i have tried updating the tables in Set location. Yes we arent changing the schema owner, its the same in both the servers. Thanks, Nav
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 01 Sep 2009 at 3:17pm
	Hi Dell, For the report thats not showing up any Data i think probably there might be a restriction in the formula in the record selection formula that i am using. {CHECKS_DISBURSEMENT.RECOVERY_TRANSACTION_INTERNAL} = "17" and {EVENT_END_USER.OWNER_FLAG} = "Y" and {EVENT_END_USER.ACTIVE_FLAG} = "Y" and {CHECKS.ENTRY_DATE} in CurrentDate-1 to CurrentDate also this is the query that is under ShowSQL Query SELECT "CHECKS"."PAYMENT_FROM", "CHECKS"."CHECK_AMOUNT", "CHECKS"."ENTRY_DATE", "CHECKS"."NON_CASH_CHECK_NUMBER", "CHECKS_DISBURSEMENT"."RECOVERY_TRANSACTION_INTERNAL", "EVENT"."EVENT_ID", "EVENT_CASE"."DAMAGED_PARTY_LAST_NAME", "EVENT_CASE"."DAMAGED_PARTY_FIRST_NAME", "CLIENT"."CLIENT_NAME", "EVENT_END_USER"."ACTIVE_FLAG", "EVENT_END_USER"."OWNER_FLAG", "END_USER"."USER_REAL_NAME" FROM "IBC1_OWNER"."CHECKS" "CHECKS", "IBC1_OWNER"."CHECKS_DISBURSEMENT" "CHECKS_DISBURSEMENT", "IBC1_OWNER"."EVENT" "EVENT", "IBC1_OWNER"."EVENT_CASE" "EVENT_CASE", "IBC1_OWNER"."CLIENT" "CLIENT", "IBC1_OWNER"."EVENT_END_USER" "EVENT_END_USER", "IBC1_OWNER"."END_USER" "END_USER" WHERE "CHECKS"."PAYMENT_FROM" = "CHECKS_DISBURSEMENT"."PAYMENT_FROM"(+) AND "CHECKS"."CHECK_NUMBER" = "CHECKS_DISBURSEMENT"."CHECK_NUMBER"(+) AND "CHECKS_DISBURSEMENT"."EVENT_ID" = "EVENT"."EVENT_ID"(+) AND "CHECKS_DISBURSEMENT"."EVENT_CASE_ID" = "EVENT_CASE"."EVENT_CASE_ID"(+) AND "CHECKS_DISBURSEMENT"."EVENT_ID" = "EVENT_CASE"."EVENT_ID"(+) AND "EVENT"."CLIENT_ID" = "CLIENT"."CLIENT_ID"(+) AND "EVENT"."EVENT_ID" = "EVENT_END_USER"."EVENT_ID"(+) AND "EVENT_END_USER"."END_USER_ID" = "END_USER"."END_USER_ID" AND "CHECKS_DISBURSEMENT"."RECOVERY_TRANSACTION_INTERNAL" = '17' AND "EVENT_END_USER"."OWNER_FLAG" = 'Y' AND "EVENT_END_USER"."ACTIVE_FLAG" = 'Y' AND "CHECKS"."ENTRY_DATE" >= TO_DATE ('31-08-2009 00:00:00', 'DD-MM-YYYY HH24:MI:SS') AND "CHECKS"."ENTRY_DATE" <= TO_DATE ('01-09-2009 23:59:59', 'DD-MM-YYYY HH24:MI:SS') ORDER BY "CHECKS_DISBURSEMENT"."RECOVERY_TRANSACTION_INTERNAL" ASC Thanks, Nav
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 01 Sep 2009 at 4:05pm
	Have you tried running this SQL on the database through Toad or some other query tool? Does it return data there? -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 02 Sep 2009 at 10:49am
	Yes infact i have ran this query using a query tool and i found out that its not fetching Data. When i tried removing the below condition "CHECKS"."ENTRY_DATE" >= TO_DATE ('31-08-2009 00:00:00', 'DD-MM-YYYY HH24:MI:SS') AND "CHECKS"."ENTRY_DATE" <= TO_DATE ('01-09-2009 23:59:59', 'DD-MM-YYYY HH24:MI:SS') it was returning some Data. Have to look for an alternative to the above formula. Thanks, Nav
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 02 Sep 2009 at 11:11am
	What type of database is this? (Oracle, MS SQL Server, etc.) You may have to use something other than an ODBC connection. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 03 Sep 2009 at 9:31am
	We are using Oracle Database and yes for all the reports we are using ODBC connection. I dont know whether we can implement the reports by using a new connection now. Do u think that there is any problem with the query. Any idea about how to resolve this Thanks Nav Edited by Nav522 - 03 Sep 2009 at 9:32am
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 03 Sep 2009 at 10:18am
	ODBC has problems and Crystal comes with a native Oracle driver that is much more reliable, so you really need to consider using that - even if only for this one report. If your users are always going to filter based on whole dates without the times, you can try creating a SQL Expression for your dates: Trunc("CHECKS"."ENTRY_DATE" ) Then way you can use this in in your filter so that you can use just the date part of the datetime. I think the issue with the odbc is probably the conversion of the datetime string to a datetime type. -Dell Edited by hilfy - 03 Sep 2009 at 10:19am
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

<< Prev Page of 3 Next >>

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

This page was generated in 0.031 seconds.