asked on

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

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Michael Katz

ASKER

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

peter57r

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.

Michael Katz

ASKER

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

peter57r

Perhaps I wasn't clear.
The last line here is not valid syntax...

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

Michael Katz

ASKER

But SAP dictates this as the correct entry. If its not right (which it clearly isn't) How can I work this?

Michael Katz

ASKER

But SAP dictates this as the correct entry. If its not right (which it clearly isn't) How can I work this?

Kurt Reinhardt

What database do you have? SQL Server, Oracle or something else? The syntax will be dictated by the flavor of SQL you use.

~Kurt

peter57r

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.

Ido Millet

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.

Michael Katz

ASKER

To peter57

Look at the sap link mlmmc sent.

peter57r

OK , I've looked - the last line of the code that you posted here is incomplete compared to the code in the link.

Michael Katz

ASKER

Ok...what did I miss..god as my witness I typed and retyped the code to try and fix it..

oliff

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.