If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Crystal Reports > Crystal Report problem form repeating foreign key values and date int the stored proc

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-28-11, 21:19
neo.mn neo.mn is offline
Registered User
 
Join Date: Mar 2011
Posts: 3
Crystal Report problem form repeating foreign key values and date int the stored proc

Hi everyone
I am new in Crystal report. I have developed a report based on two tables using a stored procedure. But the report is showing runtime exception. I go through the problem and found that in my foreign key field of 'Person_Loan_Details' table, if i put the same value for several rows and the date field also contains same value then the exception occurs. But if i change the datetime or the foreign key (like 101, 102, 103 but no repeating the same value in the same date for several times) values so that they do not repeat in the same date then the report is working. I do not know what the problem is ? Please help me to find the solution. I am sending you the sample table with data and the report as zip format. Please have a look and help me to find out the problem.

Regards
Nasir
Attached Files
File Type: zip Report.zip (439.3 KB, 7 views)
Reply With Quote
  #2 (permalink)  
Old 11-29-11, 23:39
mission mission is offline
Registered User
 
Join Date: Oct 2010
Posts: 44
Cannot open the zip file.

The Windows 7 error message is "The compressed zip folder is invalid".
Reply With Quote
  #3 (permalink)  
Old 12-03-11, 22:10
neo.mn neo.mn is offline
Registered User
 
Join Date: Mar 2011
Posts: 3
Crystal Report problem form repeating foreign key values and date int the stored proc

hi i am sending you the zip file again.
thanks
Attached Files
File Type: zip Report.zip (439.3 KB, 1 views)
Reply With Quote
  #4 (permalink)  
Old 12-10-11, 17:15
mission mission is offline
Registered User
 
Join Date: Oct 2010
Posts: 44
Still cannot open the zip file.

How did you zip it? Winzip?

Try this:

- In Windows Explorer, right click on the report
- Click Send To, select Compressed (zipped) folder

This will create a zip file, anyone can open the file from Windows without winzip.

Also, if the report is not that big, why bother to zip it?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On