Cannot create report group

[Gordon Buhagiar]

Hi,

I have database that is residing on SQL server.

What I want to do is create a report in Access that have
similar data to continuas forms. I am trying to do this by
usinng the CreateGroupLevel command. Can you please advise
if this is the correct way to do it? When I try to use the
following code

vargrouplevel = CreateGroupLevel
Report_Rpt_Employee, "Number", True, True)

an error message comes up. The error is "Compile error:
Wrong number of arguments or invalid property assignment"

Can you please help about this issue?

Thanks
Gordon

 

[Marshall Barton]

I have database that is residing on SQL server.

What I want to do is create a report in Access that have
similar data to continuas forms. I am trying to do this by
usinng the CreateGroupLevel command. Can you please advise
if this is the correct way to do it? When I try to use the
following code

vargrouplevel = CreateGroupLevel
Report_Rpt_Employee, "Number", True, True)

an error message comes up. The error is "Compile error:
Wrong number of arguments or invalid property assignment"

Is the report open in design view?

Your posted code needs to be all on one line and is missing
the left parenthesis.

Unless you are creating a procedure to help you (not your
users) create reports, this is a **Bad Thing** to include in
your application. The standard way to deal with optional
group levels is to precreate it in design view and then use
code in the report's Open event to manipulate it according
to some user options specified on a form.