Hello
I got problem with sorting data, at that moment i got this one
https://www.transfernow.net/dl/20250124kattpL0N/yKlvIrGa
It fort parts by size and sum the same parts.
I need to make something similar but with “PRJEDGE” sorting by “MATNAME,LEN,TH” – i need to sum ABS for order
I want use this in “offer window” with C5
My PCV/abs looks like this:
At that moment i know i can make it by crosstab in C5 but there is some BUG so crosstab dont work very well, and cant it modify as i wish.. In C6 is a little better but at that moment i cant get this version.
Any ideas ?
sorry but honestly I don’t really understand what you want.. I attached a picture of how I did it my fast report
it doesn’t work, do you have anything written in the code page? error Memo23
check the link i uploaded 2 templates ,hope will help you
I think he is asking same question I have asked before. How to sort data on your report. For example sort hinges feom project by its product number.
edit template and on the “code” page write like this
begin
DataSort(‘PRJFIT’,’CODE’)
end;
you can sort by what you want..in my case ‘PRJFIT’,’CODE’
if you look at the picture above I have category sorting
It worked! Finally, thnx!
I needed to add my code to be executed before print to sort data.
See image below:
https://ibb.co/1QgZjVS
my code:
procedure DetailData1OnBeforePrint(Sender: TfrxComponent);
begin
DataSort(‘PRJFIT’,’Code1′)
end;
begin
end.
kako filtrirati report?
ukoliko je vrijednost polja npr ‘PRJFIT’,’Code1′ prazna da se ne pojavljuje u reportu?
Label koji to ispisuje ima neko ime, na primjer: “AccCode”.
U skripte od ispisa (Code) u proceduru
procedure DetailData1OnBeforePrint(Sender: TfrxComponent);
treba dodati nešto ovako:
AccCode.visible:=PRJFIT.”Code1″‘;
U prijevodu, Labela AccCode je vidljiva ako je PRJFIT.”Code1″ različito od praznog stringa.
hvala na odgovoru.
vaš odgovor govori o tome da se pojedino polje neće pokazati ukoliko je određeni uvjet zadovoljen.
zapravo sam htio pitati kako filtrirati sve zapise tako da se pojedini ne pojavljuju.
primjer: želim da mi se ispišu samo okovi koji imaju ispunjeno polje PRJFIT.Code1, oni koji su prazni neće biti prikazani
otkrio sam.
Treba odabrati DetailData1 pa unutar properties prozora napisati npr ”
To će filtrirati cijeli set podataka. U mom slučaju neće se prikazivati okovi koji nemaju podatak u polju Code3.
if you have feetings (potrosni) done by categories then try filtering by ELMFIT.”CAT” or PRJFIT.”CAT”..if it doesn’t work tell me there is another option that I need to make a tutorial for you
dodao sam filter na dataset
<PRJFIT."CODE3"> <> ''
i sada se u izvještaju ne pojavljuju zapisi koji nemaju vrijednost (šifru) u polju Code3.
1.create a category and remember the number next to it, for example 1 in our case
2. make sure that there is already a category on the fitting, each category created will have a create code and that code is entered in the filter for each PRJFIT, see picture 4
3.in the code section enter the following text
procedure DetailData1OnBeforePrint(Sender: TfrxComponent);
begin
begin
DataSort(‘ELMFIT’,’CAT1′)
end;
4.DetailData filter add =1
the number u represents the created category
5.enter [PRJFIT.”CAT”] in detail data
1.create a category and remember the number next to it, for example 1 in our case
2. make sure that there is already a category on the fitting, each category created will have a create code and that code is entered in the filter for each PRJFIT, see picture 4
3.in the code section enter the following text
procedure DetailData1OnBeforePrint(Sender: TfrxComponent);
begin
begin
DataSort(‘ELMFIT’,’CAT1′)
end;
4.DetailData filter add <PRJFIT.”CATID”>=1
the number u represents the created category
5.enter [PRJFIT.”CAT”] in detail data
it works correctly if you synchronize potrosni with what you have already added..follow the steps above posted by me
https://mega.nz/file/vZ1URBpa#P6SS60Zewt32nNN8QqKEHtw_r3trbw4YmjErO28TaZU
I “just” want to sort data…
At that moment i see that your raport is sorted but with tracke it a little more difficult:
[img]https://i.ibb.co/yk1PshX/Zrzut-ekranu-2025-01-27-104553.jpg[/img]
i got tracks with this same ‘MATNAME’ but different ‘CODE’…
In “usematerials”/ $saw it is sorted, in window “calculated” its not. In this window all is sorted by elements so each element next to each other get “duble” sort….
at that moment its look like this:
[img]https://i.ibb.co/pj2JnX7/Zrzut-ekranu-2025-01-27-105721.jpg[/img]
should be like this crosstab:
[img]https://i.ibb.co/k48Mwwm/Zrzut-ekranu-2025-01-27-105902.jpg[/img]