DataReports 2 questions

[Tonyb]

I just started using data reports for a new project I'm working on and was wondering if anyone new how to do any of the following:

1) Post data from a form to a Data report
2) Run a query so that the data report only displays one block of data.

I'm using VB6.0 and am open to using Crystal reports V7.0 instead but have never used this either.

Thanks in Advance,
Tony B

[jtm7699]

1) What form are you trying to link to the report. A VB or Access. Either one I am not sure but can look into. Linking to a table is real easy.

2) What do you mean by only one block of data?

[Tonyb]

The program is in VB( Im using a standard VB Form), right now im using an access data base to test with although this will change to SQL.

What I'm trying to achieve is to allow a print preview of the data formatted before it is permanately written to the database. If this cant be achieved I'm looking for alternatives.

Im trying to avoid creating a new database of all the data I wish to display and deleting it.


I'm referring to a block of data as the resulting data found from a single query i.e..


all the data returned from

SELECT * FROM Table1 WHERE DBitem=uniquedata


I hope this clarifies the questions posted in your response,
I appreiciate any help you can offer.

Thank you,
tony B

[jtm7699]

I dont know if linking to a VB form is possible, if you want to produce a report I would just build one as a long string and display in a text box or rich text box.

As for the query display, set the main report property to that query, then all the values that are returned by that query can be used in the Text boxes that you have placed on the report.

Let me know if this helps. I was sort of in the same boat last week.

[Tonyb]

Do you have an example?
I'm not sure what you mean by the main property of the report.

Also, how do I specify the WHERE in the query since it wont be a constant?

Thanks Again,

Tony B

[jtm7699]

Take the property settings of the report and set the Datasource and data member to the Query, if you need i can send you a report and you can see what i mean.

You are building the query in VB in the Date Environment.

WHERE table.attribute='lookfor'

i found that to set the variable you had to run the query then, the report, then close the query.

need anything else let me know

[Tonyb]

I think I'm following OK, but if it's not a bother I'll take the copy of the report. Email : [email protected]


Thanks yet Again,
Tony b