Displaying the Field Data Pagenumber

[Tbirdbully]

Thanks in Advance!

I am using crystal XI.

Is there anyway to display the page number of where the field is in a report on a different page? What I mean is if a field is being printed on page 14, on page 2 I want to print the field and the page its on. The pagenumber function prints that particular page I am looking for report pagenumber the data came from.

{product} {pagenumberofproduct}

I am not sure if this is possible. Sorry if I was confusing.

-Jay

 

[synapsevampire]

Looks like you're intending to build a table of contents of sorts.

Here's one solution:

http://technicalsupport.businessobj...sliceId=&dialogID=2714544&stateId=1 0 2712866

-k

 

[Tbirdbully]

I tried this out a few times but I keep getting stuck on step 8 with the correct syntax for excel. The syntax shown below given is for Microsoft SQL Server.

-----------------------------
{?LinkReceiver}

DELETE FROM "TableOfContents"

WHERE "TableOfContents"."DateTime" <> {?DateTime};

SELECT * FROM "TableOfContents"
---------------------------------------
When I put this in, a "Enter Values" box apear and asked for the linkReceiver input. no matter what I type here or leave blank. I get the error:

"Database Connector Error: "DAO Error Code: 0xd7a
Source: DAO.Database
Description: Syntax error in query. Imcomplete query clause"

I've been stuck at this problem for quite some time now.
I can't find the correct syntax to make this work. Any ideas?
Thanks

-J

 

[synapsevampire]

Try omitting the {?linkreceiver} part of the script.

-k

 

[Tbirdbully]

nope that doesn't work

 

[synapsevampire]

Yeah, so I see, I just perused through the whtepaper, it's required.

Anyway, if you can't get that to work, try:

http://www.ml-crystal.com/articles/toc.htm

-k

 

[Tbirdbully]

this only support 20-40 entries, I have about 500=/