Viewing of reports

[zyabc]

Hello All,

I have created a report which has numerous column headings & row headings. I would like to split it into different pages & repeat the row heading & the remaining column heading. Is it possible in MS-Access Report?

For Ex:

City Jan Feb Mar

ABC 1 1 1
DEF 1 1 1

I want the first page to be

City Jan Feb

ABC 1 1
DEF 1 1

& the second page to be

City Mar

ABC 1
DEF 1

Can it be done?
Pls help me out.

Thanks & Regards,
zyabc

 

[deulyd]

The only way I think you can do that is using 2 sub reports in a main report.

1st report contains fields : CITY, JAN, FEB

2nd report contains fields : CITY, MAR

Main report contains (in detail section) :

1 subreport

pagebreak object (in access toolbar)

2nd subreport


Deulyd

 

[dhookom]

Try make your report double-wide and then repeat the City column toward the middle of the page so that it shows on the left of the second page. The first columns go between the city columns and the last column goes way to the right.

Duane
MS Access MVP

 

[zyabc]

Hello All,

Thanks for your response quite immediately. The above is just an example. It may be even between dates. For Ex: 27/01/2003 to 27/02/2003. Hence i would like to put first 6 columns plus the city in the first page & the next 6 columns plus the city in the second page & so on... Is it possible? Since if i don't do like that... the report looks ugly. Please do suggest some ideas...

I read somewhere that grouping of columns can be done. Also please tell me how to create a sub-report in MS-Access Report? Is MS-Access Report a Crystal Report. Please help me out.






Thanks & Regards,
zyabc

 

[dhookom]

Is this for printing results of a crosstab query? Are dates/months the real headings? If date increments then I think you would be justified in designing for a specific number of columns. If a user wanted a larger date range, they would run two reports (could be programmed). If you truly want a dynamic number of columns that would wrap, then check the crosstab report download at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Duane
MS Access MVP

 

[zyabc]

Hello Dhookom,

I am new to MS-Access. So, please excuse me if i wrong anywhere

1) I am using Crosstab Query currently. But i learnt somewhere that if i use crosstab query it actually creates a table internally with all the dates. If the user enters adds some more records it will pose a problem isn't it? Can you please tell me how to write a simple query which looks like CrossTab Query.

2) The dates/months are real heading. How Can i write a program to create two separate reports with 10 columns of dates in each report.

Pls help me out




Thanks & Regards,
zyabc

 

[dhookom]

Assuming you want a report with 10 columns that display values from consecutive dates. Also assume your date field is [DteFld] and you have users enter the ending date in Forms!frmDtSlct!txtEnd.

In your crosstab, set the column heading expression to:
ClHd:"D" & DateDiff("d",[DteFld],Forms!frmDtSlct!txtEnd)
Then set the Column Headings property to:
"D9","D8",...,"D0"
Set your Query | Parameters to
Forms!frmDtSlct!txtEnd Date/Time
Open the form and enter an ending date. Run the query and DteFld values matching Forms!frmDtSlct!txtEnd will display under [D0]. Nine days earlier will be in column [D9].

In your report, use text boxes for column labels. Set the control sources to:
=DateAdd("d",0,Forms!frmDtSlct!txtEnd)
=DateAdd("d",-1,Forms!frmDtSlct!txtEnd)
=DateAdd("d",-2,Forms!frmDtSlct!txtEnd)
etc
Format these to whatever date format you want.

Duane
MS Access MVP