Creating a Table of Contents

[pharrison74]

Went throught the instructions again. Made sure everything was as it said. I did change the Description Field name to Case_Name as that is the data I need out of the report. Then changed the code to match.
As well matched the Case_Name field with 255 characters etc as that is what I need not 15. However
When I open the report that is it pulling from I get the same error that Case_name isn't indexed.

Sorry but not sure why this is happening. Trying to solve it myself with no go.

[cyanidem]

Perhaps that's why:

Also changing field name from Description to Case_Name does nothing. What matters is where do you put the UpdateToc() function. It must be in OnPrint event of header section of Case_Name, and that section is something you need to create with report Group&Sort option.

[pharrison74]

Ok so I have changed it back to Description since it makes no difference. HOwever I am truly lost. I tried to create a group report which I have no idea what the grouping does even after following instructions. It created a report but again nothing was in it.

I am sorry but really lost at this point..Maybe over thinking it. The updatetoc is on Print in the page header section. of the report I need the table of contents for. That report has the field Case_name which is the field I need the data pulled from...

Am I a complete idiot?>

[cyanidem]

The updatetoc is on Print in the page header section. of the report I need the table of contents for. That report has the field Case_name which is the field I need the data pulled from...

It won't work as intended while on page header. You need to create group for case_name and put UpdateToc function there.
First click on group&sort button on ribbon:



Then add group for case_name:



Move your case_name textbox to this new group and set OnPrint property as below:

[pharrison74]

Ok did that. After opening the report and going to print preview of that report I get an error now.

So am I correct in assuming that when I print this report it will populate the Table of Contents report I created? At least is that is how it is supposed to work?
Servers are so much easier to work with then coding lol.

[cyanidem]

When viewed in Print Preview mode it will populate table "Table of Contents" on which is that Table of Contents report based.
And about that error - double check if there's nothing left from previous attempts.

[pharrison74]

I don't see any missing or extra code to cause that error.

Thanks again for all your help

[pharrison74]

Anyone see why this isn't working ?

[cyanidem]

Can you upload your db again with that error? There must be something you missed but I can't tell from here.

[pharrison74]

Testing_Litigation_DB1.zip

Here you go

Thanks
Pete

[cyanidem]

Ok, you've got " " (space character) in On Print event property of Page header...
Delete it and you're good.
Or here's one I've done before from your previous upload and it's working.
Testing_Litigation_DB1.zip

[pharrison74]

Wow, how did you see that? It works now....THANK YOU SO MUCH!!!!!!!

You rock!

Peter

[cyanidem]

Happy to help

[pharrison74]

Seems it isn't counting the entries correctly. Only showing 1's

[cyanidem]

Umm... I don't think it's supposed to count anything, those 1s are just a page number on which entry in original report is located.