Report

[weisi]

What program can be use to edit and read a .rpt file?

[Hack]

.rpt files are typically associated with Crystal Reports.

From windows explorer, if you right click on the file and click properties, does it give you a file type?

[Static]

FYI: if u ever want to know what an extension is associated with

http://filext.com/

it has the largest list ive seen... with all the possibilities...
RPT:
Crystal Report
MicroSim PCBoard Reports Reflecting Autorouting Progress and Statistics
Sierra Mastercook Cookbook File
TeamQuest View Report Syntax
Visual Basic Crystal Reports File

[Hack]

FYI: if u ever want to know what an extension is associated with

http://filext.com/

it has the largest list ive seen... with all the possibilities...
RPT:
Crystal Report
MicroSim PCBoard Reports Reflecting Autorouting Progress and Statistics
Sierra Mastercook Cookbook File
TeamQuest View Report Syntax
Visual Basic Crystal Reports File

Cool link

[weisi]

I have used a datareport, how do I adjust the size of the page so when the user wants to print it will be just the same size?

[d3gerald]

as far as i know, datareport only allows you to view a single page at a time. i dont know with other reports but thats how datareport work

[weisi]

What if I want to selected a report to be generated?
eg. the field in my report has index, name and age, then the user can either choose from maybe index 1 to index 5 to be shown only, or in another case, user may want to choose age = 15 to 20 to be shown.

How can I be able to do this? I will need to create a combobox right?

[d3gerald]

data report displays data from the database and in doing that, i suggest you use ado.

you can filter those things before they get shown in the report with your recordset. you can query it up to display only those things that meet the condition you specify

[weisi]

data report displays data from the database and in doing that, i suggest you use ado.

you can filter those things before they get shown in the report with your recordset. you can query it up to display only those things that meet the condition you specify

Thanks! Any examples of the code?

[d3gerald]

supposing you have a table named info containing the fields you want to display and one of those fields is Age. your SQL Statement should be like this

select * from info where age between 15 and 20;
that displays all fields with age ranging from 15 to 20

you can replace the * sign with the list of fields in your table if you want your query to be specific

[weisi]

I have created a form which contains a combobox1 which the user can select the age and combobox2 which the user can select the index and a button to show report. Any codes to be written in here?

[Hack]

Moved to reporting section

[weisi]

How can I made the directory of the database of the datareport fix, so I do not have to change the directory of the database everytime I copied the entire project into another new computer under a new directory. The problem now is that when I copied to a new folder, and when I click on the report, it will prompt me a "Please Enter MS JET OLE DB Initialization Information" asking me for the datasource. Is there any way which I can solve this problem?

[weisi]

How can I made the directory of the database of the datareport fix, so I do not have to change the directory of the database everytime I copied the entire project into another new computer under a new directory. The problem now is that when I copied to a new folder, and when I click on the report, it will prompt me a "Please Enter MS JET OLE DB Initialization Information" asking me for the datasource. Is there any way which I can solve this problem?

Please advice... Thank you!

[weisi]

Private Sub report_Click()
Unload DataEnvironment1
DataEnvironment1.Connection1.ConnectionString
report.Show
 
End Sub

I have problem with this. Im still trying to solve the path of the database as mention above. Please advice...