Help need with designing this complex query
Hi every body. I am new to creating query and report. I got database and sample
report document that i want to generate the report in access each week. My big
diffuclty is how to design and create the query for this complex report so any
help would be appreciated.I posted picture of my database tables with their
reletions and sample report document below. The database is in sql server 2000
and i linked to those tables from access 2000. I be happy if some expert help
me create this complex query for this report.Thanks
http://i5.photobucket.com/albums/y18...rojectdata.jpg ( report sample document)
http://i5.photobucket.com/albums/y18...etionship4.jpg
(database tables)
Re: Help need with designing this complex query
You need to tell us what the query is supposed to do and what it is supposed to return.
Are you writing the query in SQL from VB and pass the recordset to Crystal?
Are you looking to write the entire query in Crystal using their scripting?
A lot more details need to be provided.
Re: Help need with designing this complex query
Quote:
Originally Posted by Hack
You need to tell us what the query is supposed to do and what it is supposed to return.
Are you writing the query in SQL from VB and pass the recordset to Crystal?
Are you looking to write the entire query in Crystal using their scripting?
A lot more details need to be provided.
Many Thanks to u reply. Well i want to create the query in access 2000 .The tables are in sql 2000 and i linked to those tables from access 2000.
I never used crystal report so i do not know if i can load a crystal report if i click on a command button from access 2000 form. Is there any advantage of designing and creating report in crystal report over using access create report feture? is it easier ? What is scripting feture of crystal doing ?
I want the query to return all the values that are in the listed document that i posted .Those values are not in one tables and i have diffculty creating such query to output all those field vaues in a new table. I be happy if some expert help me create this complex query .Thanks
Re: Help need with designing this complex query
If you are using Access, then stay with the Access report. There is no need for the expense or complexity of Crystal.
As far as building a recordset from multiple tables that isn't that difficult.
Quote:
Originally Posted by tony007
I want the query to return all the values that are in the listed document that i posted .
:confused: What document?
Re: Help need with designing this complex query
Quote:
Originally Posted by Hack
If you are using Access, then stay with the Access report. There is no need for the expense or complexity of Crystal.
As far as building a recordset from multiple tables that isn't that difficult. :confused: What document?
Thanks for u reply. I mean this document.
http://i5.photobucket.com/albums/y18...rojectdata.jpg
( sample report document)
