Solved

Rave Reports database

Posted on 2004-04-07
2
311 Views
Last Modified: 2010-04-05
Hi all,
I am trying to create a very simple report that will allow me to show information from an access database and dont really have a clue where to start. What I am after would be some simple code that would simply scroll through and display every field of all the records of a database - lets say the fields are field1, field2,field3.
It would also be nice to know how to restrict the display to something like field1 = 'abc'.
The previous reporting in Delphi6 I had figured out enough to use but the Rave stuff????

Thanks for any assistance
0
Comment
Question by:monitorwa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
bnemmers earned 500 total points
ID: 10785120
monitorwa,

Do you want display the contents of each record or just the field names?

Because Rave will display what recordset is. You can use different bands in rave, one for your column titles and one for your
column data. So use one of the Rave connections to connect your data to the rave report i.e.. TRvDataSetConnection. but make sure your query connection stays active while the report is created. Try using the report wizards in Rave to help you with a base report that you can modify.

If you could give me more details about your query that your are using, you might need to change your resultset
to fit your needs

Bill
0
 

Author Comment

by:monitorwa
ID: 10809630
hi Bill,
I have a table (Access) that has lets say 5 fields - field1  - field5, I have several records, lets say 20 which contain data for each of the fields listed above. I would like to display all the data for all the fields in one report, something like

Name(field1)  Age(Field2) Weight (Field3)
Bob                  30                           80
Jane                 32                           68
Pete                 28                           95


and so one. I am not really even sure where to start e.g create a report which would do all of this through Rave then call the report - when I create a data view it keeps coming up with an error?
Or would I be better using the Rave components and create the report through the actual application?

Thanks in advance for any ideas or samples

Dave
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question