Create a Table of Contents in Crystal Report

How can i get a Table of Contents in a Report Header and have it change based on a dynamic group 1??  Never created a Table of Contents in Crystal..

I need the following Table of Contents to give me

Field1....Page Number X  to Y

and have Field1 change when the group is entered
Mikeyman_01Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Mikeyman_01Author Commented:
hi mlmcc,

Seems like I only talk to you  :)...

Followed the instructions from the SAP...

I have entered the Script

{?LinkReceiver}
DELETE FROM "TableOfContents"
WHERE "TableOfContents"."DateTime" <> {?DateTime};
SELECT * FROM "TableOfContent.

I have double checked all of the underlying info and all appears correct..

I get this error " Failed to retrieve data from the database. Details: 42000 9Microsoft0[ODBC SQL SERVER DRIVER][SQL SERVER]Unclosed quotation mark after the character string '}; SELECT * FROM "TableOfContents"'. [Database Vendor Code:105]

Any thoughts

0
 
peter57rCommented:
The last line of the SQL you have posted is clearly incorrect.
Is that a typo in your real code or just in what you have posted here.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Mikeyman_01Author Commented:
Yes, it is a typo..but not in the real code or in what I posted...the error placed that in even though my code doesn't have that error..I think I probably typed and re-typed the code 5 or 6 times and the error never goes away or changes...Weird
0
 
peter57rCommented:
Perhaps I wasn't clear.
The last line here is not valid syntax...

{?LinkReceiver}
DELETE FROM "TableOfContents"
WHERE "TableOfContents"."DateTime" <> {?DateTime};
SELECT * FROM "TableOfContent.
0
 
Mikeyman_01Author Commented:
But SAP dictates this as the correct entry. If its not right (which it clearly isn't) How can I work this?
0
 
Mikeyman_01Author Commented:
But SAP dictates this as the correct entry. If its not right (which it clearly isn't) How can I work this?
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
What database do you have?  SQL Server, Oracle or something else?  The syntax will be dictated by the flavor of SQL you use.

~Kurt
0
 
peter57rCommented:
I don't understand what you mean by this..
"But SAP dictates this as the correct entry.  "

Crystal Reports does not validate the sql command, it just sends it to the database.
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
At least one of the 3rd-party Crystal Reports Desktop Scheduling tools listed at: http://www.kenhamady.com/bookmarks.html provides that functionality.  However, it does this by automatically exporting the Crystal report to PDF and adding the Table of Contents to the resulting PDF file.  It can also automate the emailing of the resulting file.
0
 
Mikeyman_01Author Commented:
To peter57

Look at the sap link mlmmc sent.
0
 
peter57rCommented:
OK , I've looked -  the last line of the code that you posted here is incomplete compared to the code in the link.  
0
 
Mikeyman_01Author Commented:
Ok...what did I miss..god as my witness I typed and retyped the code to try and fix it..
0
 
oliffCommented:
Perhaps attach your code in the code field of the message post, rather than paste it into your message. Quote marks into a website field not designed for code could cause some interesting errors.
0
All Courses

From novice to tech pro — start learning today.