Marius0188
asked on
Delphi 7 :: Rave Report Group By not Working
Dear Experts,
I have a report that should group items by the CheckPoinCode field.
This group by is not working.
I am using a singles query to select all the rows:
qPearlChain.Close;
qPearlChain.SQL.Text := 'SELECT * FROM tblPearlChainReports ORDER BY TheirDateTime DESC,
POrderNumber DESC, CheckPointCode DESC';
qPearlChain.Open;
The DataSource for Rave is assigned to qPearlChain (TADOQuery) component.
Please have a look at my report's property setup in the attached screenshots.
Screenshot 1..4.
Thanks
1.jpg
2.jpg
3.jpg
4.jpg
I have a report that should group items by the CheckPoinCode field.
This group by is not working.
I am using a singles query to select all the rows:
qPearlChain.Close;
qPearlChain.SQL.Text := 'SELECT * FROM tblPearlChainReports ORDER BY TheirDateTime DESC,
POrderNumber DESC, CheckPointCode DESC';
qPearlChain.Open;
The DataSource for Rave is assigned to qPearlChain (TADOQuery) component.
Please have a look at my report's property setup in the attached screenshots.
Screenshot 1..4.
Thanks
1.jpg
2.jpg
3.jpg
4.jpg
Last Comment
ASKER
ASKER
Can someone not rather give me the steps on how to connect the bands and the set up.
Maybe that will easier for me to check my set up on this side.
Thanks.
Maybe that will easier for me to check my set up on this side.
Thanks.
I will try to reproduce your setup today if I can find the time. I will let you know how it goes.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi developmentguru,
Thanks for your help.
I really value it.
You earn all of the points.
Although I have realized spending a few dollars and invest in FastReport was worth it.
Very easy to use.
Thanks for your help.
I really value it.
You earn all of the points.
Although I have realized spending a few dollars and invest in FastReport was worth it.
Very easy to use.
Delphi
Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.
60K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
So, first show an example of the data as it comes out in the database browser. Then show the order it comes out in the report. That way we can see the problem.