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
Michael KatzAsked:
Who is Participating?
 
Michael KatzAuthor 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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Michael KatzAuthor 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
 
Michael KatzAuthor Commented:
But SAP dictates this as the correct entry. If its not right (which it clearly isn't) How can I work this?
0
 
Michael KatzAuthor 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
 
Michael KatzAuthor 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
 
Michael KatzAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.