Cannot create report group

  • Thread starter Thread starter Gordon Buhagiar
  • Start date Start date
G

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
 
Gordon said:
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"
Click to expand...


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.
 
Back
Top