How to open a report in Report view in Access 2003 (acViewReport in access 2007)

[jambai]

Hello,

I could open the report in Report view in Access 2007 using acViewReport,

DoCmd.OpenReport "rpt_CallList", acViewReport

The same code doesnot works in access 2003, instead of opening the report in Reportview, it is behaving as acnormal and tries to print the report.I believe acViewReport is not available in Access 2003.

Can anyone help me how to open the Report in Report view rather than using acviewNormal or acviewpreview or anything.

Thanks & Appreciate

Harish

 

[John Big Booty]

Try;

DoCmd.OpenReport "rpt_CallList", acViewPreview

 

[jambai]

Thanks John, Appreciate your reply,

But acviewPreview will open the report as a Printpreview mode, but i have some command buttons in my report for each records, so if i open the report using acviewreport, then i am handling some click event for each records. So i want to open my report in Report view rather than Preview mode.

Thanks
Harish

 

[John Big Booty]

Command Buttons, Report you CAN NOT have functional command buttons on a report. A report by it's very definition is for displaying your data. Any manipulation of that data must be done at form level prior to sending it to a report.

Perhaps if you explain exactly what it is you are trying to achieve we can suggest an alternative.

 

[boblarson]

Report view was NEW in Access 2007. It doesn't exist in 2003 so you can't use it in 2003. Sorry,

 

[jambai]

Hi John,

Thanks for your reply.

Actually i have designed a Report in 2007 with 2 Groups and 1 detail section with a buttons in the detail section. So each buttons will open a separate form.

So right now everything works fine in 2007 using the code

DoCmd.OpenReport "rpt_CallList", acViewReport

But when testing it in 2003, it does not works, so need to workaround to solve this issue. Could you please explain me how to acheive this in forms.

Thanks

 

[John Big Booty]

As Bob mentioned, earlier, acViewReport is new to Access '07, and is not backward compatible with Access '03, Reports in this version have no faculty to be interactive. So whatever functionally the buttons on your '07 Reports have will need to be replicated at form level prior to opening the report (in '03 version) . Simply put '03 Reports are static and non-interactive The End.

 

[jambai]

Thanks John,

Appreciate your valuable reply...

Do you have any reference links to achieve this functionaliyt in a form (May be some example for Main form and 2 Sub forms etc).

Thanks again..

 

[John Big Booty]

I've got no idea what you are currently doing on your report

Can you give me a step by step description of what you are currently doing?

 

[jambai]

Hi John,

Right now, i have a recordset and 2 Group Section and a Detail Section in my report.

Group 1 section will be grouped by Phone
Group 2 Section will be Grouped by Name
Detail section will have the other details for each records and will have a button to navigate to the other form.

So i believe i need

1. 1 Main form to replace the Group1 section and display the Phone Number
2. SubForm 1 to replace the Group2 section and display the Name
3. Another Subform to replace the Detail section and display aother fields.

Can i do this with only 1 recordset, if so pls guide me how to handle this, do you have any sample/links to achieve this with a Main form and 2 sub forms.

thanks

 

[John Big Booty]

I think you should be able to do it with a single Main Form and two sub-forms, you could use different queries to populate your two sub-forms.

Now depending on your form sizes and the and result you want, you could have it set up so that both sub-forms are visible or you could use a command button to show or hide your sub-forms as required.

 

[jambai]

Thanks for your suggestion.

Is it possible to use a single stored procedure or query to use for all the 3 forms and do you have any sample or link for this.

Thanks