Ordered list
Hello, I am a FastReport user, I know FastReport at the user level but I am not a programmer, I have some knowledge of databases and SQL.
I am using an application that uses FastReport for reports. These are in place but little worked, there is no support for FastReport from the application providers.
1st question: I have a report that I am modifying, is a list of accessories.
The fields that intervene summarizing are provider_name, accessory_name, quantity
I have a band MasterData with its DataSet (project)
After a Band GroupHeader -> DataSet (props_project), I have you group it by provider_mame, Variables: provider_name
Then a band DetailData -> DataSet (props_projects), Variables: accessory_name, quantity
The result is a report similar to this:
HETTICH
Hinge_1 2
Hinge_2 4
EMUCA
Extra Bottle 1
Locker bar 4
HETTICH
Drawer side 10
Slider 10
As you can see the list is not ordered by supplier, so the result is not the one I need. All HETTICH accessories should be together.
The version of FastReport included in the application, I suppose will be the basic one. I have not found a way to put SQL to try to sort the data by provider.
I have been looking at FastReport web I have seen that there is a version that allows me to use SQL, I do not know if acquiring this version could use it with the application. If someone can inform me even if it is just to indicate how to start, it would be very helpful.
Momentary solution:
From the Code tab I can use PascalScript, C ++ Script, BasicScript, JScript
What script should I put to sort by provider_name?
Or maybe the solution is simpler?
If you need any more information ask me.
Thank you very much
I am using an application that uses FastReport for reports. These are in place but little worked, there is no support for FastReport from the application providers.
1st question: I have a report that I am modifying, is a list of accessories.
The fields that intervene summarizing are provider_name, accessory_name, quantity
I have a band MasterData with its DataSet (project)
After a Band GroupHeader -> DataSet (props_project), I have you group it by provider_mame, Variables: provider_name
Then a band DetailData -> DataSet (props_projects), Variables: accessory_name, quantity
The result is a report similar to this:
HETTICH
Hinge_1 2
Hinge_2 4
EMUCA
Extra Bottle 1
Locker bar 4
HETTICH
Drawer side 10
Slider 10
As you can see the list is not ordered by supplier, so the result is not the one I need. All HETTICH accessories should be together.
The version of FastReport included in the application, I suppose will be the basic one. I have not found a way to put SQL to try to sort the data by provider.
I have been looking at FastReport web I have seen that there is a version that allows me to use SQL, I do not know if acquiring this version could use it with the application. If someone can inform me even if it is just to indicate how to start, it would be very helpful.
Momentary solution:
From the Code tab I can use PascalScript, C ++ Script, BasicScript, JScript
What script should I put to sort by provider_name?
Or maybe the solution is simpler?
If you need any more information ask me.
Thank you very much
Comments
If you have internal dataset like TfrxADOQuery - go to "Data" tab of the report and modify query SQL (add ORDER BY in the query text)
I understand that the Tfx ADOQuery dataset must provide the application programmer. It is right?
Attached image with Data tab enabled.
Gracias