Help, STEVE ARBAUGH!

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I did how you sugested, but appeard a PROBLEM: if I add groups for the
Product code and for the OrderID, with headers and Force New Page Property,
and I put the tabelar header and footer in the pege header and page footer,
i wil have a new page for every cenge of these parameters, BUT IN THE REPORT
BODY I WILL HAVE ONLY A FEW LINES(OR ONLY ONE) WITH DATA HAVING GRID, AND
BELOW THEM WILL BE BLANK SPACE.
THIS SPACE NEED TO BE WITH GRID, BECAUSE THE HEADER AND THE FOOTER ARE
TABELAR (WITH GRID)
Can you please help me?
 
Chris:

1.) If you stop by our web and look in the Free Files area for a download
called "Other Reports", there's an example report that shows how to have
your report produce a fixed number of lines, including blank lines as
necessary.

2.) Normally it is best to post not to one person, (e.g. me) because others
can answer your question as well and any individual may or may not be
reviewing posts for a number of days.
 
I tried to modify the code of the report from the exaple database from your
site to fit my needs, but id doesn't work.:
1. It inserts blank lines only on the first page or the report (my report is
divided in more pages by 2 values included in the report header, for which I
defined group headers having the height=0)
2. I think I wrote wrong the code for geting the count of the max rows that
have values, and I don't know where is wrong(because all the lines result
with the forecolor white). Can you corect it please?

Set Cdb = CurrentDb
Set rsJobs = Cdb.OpenRecordset("Select Count([denumies])as Jobs from
qry[bonconsum-] WHERE comanda_int = " & Me!Comanda_int & "And CodReper= " &
Me!CodReper & "and emisincont=" & Me!EmisInCont)
bJobCount = Nz(rsJobs!Jobs)
rsJobs.Close
Set rsJobs = Nothing
Set Cdb = Nothing

Thank you!
 
Chris:

We can't really correct your code. The count code it fine. It probably has
to do with where you put the code. The code to count the records must be in
a group header and there must be a force new page for each group header.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Chris said:
I tried to modify the code of the report from the exaple database from your
site to fit my needs, but id doesn't work.:
1. It inserts blank lines only on the first page or the report (my report
is
divided in more pages by 2 values included in the report header, for which
I
defined group headers having the height=0)
2. I think I wrote wrong the code for geting the count of the max rows
that
have values, and I don't know where is wrong(because all the lines result
with the forecolor white). Can you corect it please?

Set Cdb = CurrentDb
Set rsJobs = Cdb.OpenRecordset("Select Count([denumies])as Jobs from
qry[bonconsum-] WHERE comanda_int = " & Me!Comanda_int & "And CodReper= "
&
Me!CodReper & "and emisincont=" & Me!EmisInCont)
bJobCount = Nz(rsJobs!Jobs)
rsJobs.Close
Set rsJobs = Nothing
Set Cdb = Nothing

Thank you!
SA said:
Chris:

1.) If you stop by our web and look in the Free Files area for a download
called "Other Reports", there's an example report that shows how to have
your report produce a fixed number of lines, including blank lines as
necessary.

2.) Normally it is best to post not to one person, (e.g. me) because others
can answer your question as well and any individual may or may not be
reviewing posts for a number of days.
Click to expand...
Click to expand...
 
Back
Top