I use the below stored procedure to run a report.
SELECT dbo.tblEmissionUnit.EmissionUnit_ID, dbo.tblNOCs.DateApproved, dbo.tblNOC_EmissionUnits.NOC_ID, dbo.tblAPlant.FacilityCode,
dbo.tblAPlant.PlantName, dbo.tblALocation.Location_Desc, dbo.tblEmissionUnit.AEI_ID...
I have a report that has a group. Going through the threads I have figured out how to page number my groups. What I am looking for now is if I can do a total page number of the report but have it only count the pages that start a new group. The below example would be for a five page report...
I have a subreport that provides a list on the report. It's record source is a stored procedure. It get's it's data from a list box on a form.
What I am trying to do is have it return all the items the user has except for certain ones. For example, if the user selects dog, cat, horse...
Is there a way to have a report ask a user what page number to begin with and then have it insert that requested page number into the page footer? it would also need to have each page go sequential with the given page number?
Any help would be appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.