advanced report in access 2010

[mrijet]

hi everybody,

how can I make advanced report in access 2010?

Does I need to use lookup function in access to call the data from "FORM" to "REPORT". Actually I want to make it like a preview report for that FORM. Can anyone help me how to call the exist data?

[Seth Schrock]

This question should be in the MS Access forum, not in the VB.NET forum. I'll get a mod to move it.

Reports can't be bound to a form, only a table or query. So assuming that your form is bound to a table or query, then you just need to bind your report to the same table/query and just filter it to the record that you are on via the primary key value.

[mrijet]

Thanks Seth for replying....so I just need to set filter only in report? I will try that first..thanks again

[Seth Schrock]

I would put the filter in the WhereCondition Argument of the DoCmd.OpenReport command. This makes it a little easier to manage.

[mrijet]

Actually I m still learning using MS Access...if you said that put the filter in the WhereCOndition Argument is more easier to manage..

Let say if my report name is Sales Order then am I need to DoCmd.OpenReport "Sales Order", and put the condition?

Is that the way?

[Seth Schrock]

Assuming the primary key field is named SaleID, then your command would be

DoCmd.OpenReport ReportName:="Sales Order", WhereCondition:="SaleID = " & Me!SaleID

[mrijet]

In my case got 2 table combine in one form, is there any possibilities to preview the report?

Example the first table got primary key and also the second table. In the form I call this 2 table in one form. And now I want to make the form to preview the using report. Does access can do that?

[Seth Schrock]

Can the records from the two tables be joined together in a query? In other words, is there a matching field in the two records that you would be viewing at the same time?

[mrijet]

Yes, can be joined together.But, after I join it and view the query, it show all the data? Because the case is, the relationship is many to many. So, it will list out all the the data. For example, PK is 00001 and then there are a 5 data in one PK. So it will list all the 5 data there.

00001 Sam
00001 Michael
00001 Rachael
00001 Hary
00001 Simon

[Seth Schrock]

Here is code that I have used in the past. I don't like using it because you have almost no control over how it prints. Also, I'm not sure how it will work in your current situation of getting data from two tables, but you can try it.

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPrintSelection

[mrijet]

Thanks for replying Seth. I really appreciated your help. I already got the way. It just create a query for the report and set the criteria for specific data I want for view and also can print the report by specific data as I want it.

Thanks man.