Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: Report Table of Contents Help Post Reply Post New Topic
Author Message
jammyking
Newbie
Newbie


Joined: 16 Oct 2007
Online Status: Offline
Posts: 1
Quote jammyking Replybullet Topic: Report Table of Contents Help
    Posted: 16 Oct 2007 at 6:14am
Hi I'm new to crystal reports and i've been asked to create a report with a TOC as the second page.  I did some research and it seems that this is no easy task (correct me if it is).  The options i've found are :
 
http://www.ml-crystal.com/articles/toc.htm which i've not tried as the contents page has to appear at the end of the report which is not what the client requires.
 
 
Trouble is i can't seem to get it to excute the insert statement! i've simplyfied it down to a wizard generated report to which i've added a subreport in the report footer section. This subreport is connected to a command which is static insert statement. When i preview the report i get no error messages but it's not updated the table either. 
 
I'm new to crystal reports so please state any obvious things i've missed. is a sub report the best way to run an insert query?
 
Thanks!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 16 Oct 2007 at 9:26am
Yes, TOC is a very complex problem many people run into. CR wasn't designed for this and it's no easy task. The KB article you mention is your best bet and, yes, the subreport is the way to go. I talk using updateable SQL statements in detail in Chapter 11 of my book. There are two probably causes for error: is the command object returning a value? It can't be ONLY an insert statement b/c then CR won't run it (no data to print means no reason to run it). Also, make sure you have the Save Data With Report option turned off. You want the SQL command to be called every time.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version 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.077 seconds.