Print report order by categorie HELP

asimov67 · Post by **asimov67** » 2006-12-26 17:49:19

I want make a print report frf files order and group by category and movie alpha order like this

--------------------
Cat : Action (field category)
--------------------
Movie 1 (field title)
Movie13
Movie2
--------------------
Cat : adventure
--------------------
Movie 11
Movie 17
Movie 21
Movie 40
--------------------
Cat : Fiction
--------------------
Movie 21
Movie ...

but i dont find how to do it (master /groupe band ) and how a have each category at the begining of a page
Can someone mail me a example of this kind of report ?

Bests regards & tahnk you for help

Asimov67
Jpwachat@laposte.net

Post by **antp** » 2006-12-26 20:10:09

I do not think that it is possible currently (the report engine handles this, but I think that I have to add something in the program to make this works - or maybe it works already, but then I do not know how

)

asimov67 · Post by **asimov67** » 2006-12-28 20:25:14

After some test i arrived to have the result !!!!!

Here you can download the report file but only during next 24 h

http://dl-3.free.fr/52616e646f6d4956854 ... 4/_JP1.frf

the only thing who does'nt work is the page count on the header.
If you have some ideas about this it could be great.

A+

Jean-pierre

Post by **antp** » 2006-12-28 22:13:54

It says « Undefined symbol "CATEGORY" »

bad4u · Post by **bad4u** » 2006-12-28 23:37:01

Same error here.

And when you open this template in the 'designer' and choose 'file - variable list' and then click on a variable, there pops up following error message : "Access violation at address 004B5134 in module 'AMCReport.exe'.Read of address 00000004."

What is strange about this is, that the error message shows up on many other templates too, but I cannot say if this started when first opening the JP1.frf template or if this error was there before (cause I never used the report builder before).

Do you have this error message too ?

The solution: After opening the variable editor again and pressing the button 'variables' and then 'ok' the "Access violation" error is gone. Now you can simply save the template and next time the "undefined category" error in the JP1.frf template does not appear again.

Btw, the page counter works fine here. It's just the date field that is not working, but I have not searched for the reason.

Don't know why this is, but it is

Maybe I should try the Report Designer when I find some time for this ^^

Post by **antp** » 2006-12-29 10:33:10

bad4u wrote: Do you have this error message too ?

No, I only get the error about the category.

asimov67 · Post by **asimov67** » 2006-12-29 15:20:16

I use french language in amc and the designer is in english

I have no category error
In the main windows after select frf file i use custom advanted order "category" "and translatedtitle" (catégorie et titre traduit en francais)

and in the designer in the group band option the condition is "[Category]"

Post by **antp** » 2006-12-29 17:48:55

On my PC it still does not work, that's strange...

asimov67 · Post by **asimov67** » 2006-12-29 18:20:09

I have done 3 screen copy to explain what i have done.
Perhaps i could help you to understand your error message or simply recreate a new report.

http://dl-3.free.fr/52616e646f6d4956b67 ... a632/1.bmp

http://dl-3.free.fr/52616e646f6d49569d5 ... f20a/2.bmp

http://dl-3.free.fr/52616e646f6d4956cf9 ... 4727/3.bmp

A+
Jean-pierre

---------------------------
Information
---------------------------
MovieCatalog.exe : version 3.5.0.1 (créé le 14/05/2005 10:06:30)
AMCExchange.dll : version 1.0.1.6 (créé le 26/06/2004 23:39:22)
AMCReport.exe : version 1.0.2.2 (créé le 15/01/2005 16:13:56)
MediaInfo.dll : version 0.5.1.0 (créé le 11/02/2005 01:24:28)
---------------------------

Post by **antp** » 2006-12-30 10:13:50

Well, I guessed that's what you did, I just do not find why on my PC it does not work.
Anyway, to come back to your first problem, the page number: I now have an idea. In "File" -> "Report options" (in the report designer), did you check the "Two-pass report" option? This must be enabled to have page numbers working, I think.

asimov67 · Post by **asimov67** » 2006-12-30 14:04:34

I have check the "two-pass report" as you explain in help. But it doesn't work.
Anyway i got a manualy solution, "a pen" !! HiHi

Thank you very much for your help and time and have a very good new year.

Bests Regards.

Jean-Pierre

asimov67 · Post by **asimov67** » 2007-01-07 10:37:08

I have change my Ant version from 3.5.0.1 to 3.5.0.2 and now i have the " Undefined symbol "CATEGORY" " error

I downgrade to 3.5.0.1 and the message disappear

Post by **antp** » 2007-01-07 11:29:44

That's very strange... as I do not remember having changed anything in that

I will try to find and correct this problem.

antp.be forum

Print report order by categorie HELP

Print report order by categorie HELP

YES !!!!!

ADDITIONAL INFORMATION