G
Guest
I've created a report that I've set up to sort in a way
that has page breaks whenever the first two numbers of a
criteria change. What I've done is set it up in the
following manner:
--Under Sorting and Grouping, I've made sure Project ID is
included (and sorted
Ascending).
-- Under Group properties for ProjectID: Set GroupHeader =
Yes, GroupOn =
PrefixCharacters, and GroupInterval = 2
This should create a header whenever there is a change in
the first 2
characters of the ProjectID.
The query that supplies this report works fine. When I
attempt to run the report I get "Undefined function 'left'
in expression"
I have no idea what this error is, but it's killing me
over here! Any advice anyone?
that has page breaks whenever the first two numbers of a
criteria change. What I've done is set it up in the
following manner:
--Under Sorting and Grouping, I've made sure Project ID is
included (and sorted
Ascending).
-- Under Group properties for ProjectID: Set GroupHeader =
Yes, GroupOn =
PrefixCharacters, and GroupInterval = 2
This should create a header whenever there is a change in
the first 2
characters of the ProjectID.
The query that supplies this report works fine. When I
attempt to run the report I get "Undefined function 'left'
in expression"
I have no idea what this error is, but it's killing me
over here! Any advice anyone?