dynamic report

[iccsi]

I just wonder does Access report support dynamic report like to gice
user to select sort column and expand the details.

For example, user may select sort by column employee ID and hire date
or birthday from employee details report or let user to to extend
employee records see training courses employee taken?

Your information is great appreciated,

 

[Jeff Boyce]

I'm not clear who you want to have do this.

YOU can select columns and sort order when you design a report. If you
want your users to, you'll either need to train them to use Access'
features/functions, or you'll need to create a UI that hides the tools.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Klatuu]

The things you are asking are all possible in Access reports, but take some
fairly advanced VBA coding to accomplish.
Sorting in a report is done using the Sorting and Grouping options.
Report sections can be made visible or hidden.
All these options can be set using VBA, but again, unless you are fairly
proficient in VBA, it may be easier for you to design multiple reports that
support the various options and run the report that will provide what the
user selected.

 

[iccsi]

The things you are asking are all possible in Access reports, but take some
fairly advanced VBA coding to accomplish.
Sorting in a report is done using the Sorting and Grouping options.
Report sections can be made visible or hidden.
All these options can be set using VBA, but again, unless you are fairly
proficient in VBA, it may be easier for you to design multiple reports that
support the various options and run the report that will provide what the
user selected.
--
Dave Hargis, Microsoft Access MVP







- Show quoted text -

Thanks millions for the message,
Do you have any example link on the website?

Thanks again,

 

[Klatuu]

Well, here is the Open Event from a report I did a couple of years ago where
the user was able to select subtotal options:

'---------------------------------------------------------------------------------------
' Procedure : Report_Open
' DateTime : 2/17/2006 14:40
' Author : Dave Hargis
' Purpose :
'---------------------------------------------------------------------------------------
'
Private Sub Report_Open(Cancel As Integer)

On Error GoTo Report_Open_Error

'Activity is always last
Me.GroupLevel(5).ControlSource = "Activity"
With Forms!frmbporeports
'Determine which Subtotals have been selected
'HomeRooom
If .chkHomeRoom Then
Me.GroupLevel(4).ControlSource = "PerformAcctUnit"
Else
Me.GroupLevel(4).ControlSource = Me.GroupLevel(5).ControlSource
End If
'Pool
If .chkPool Then
Me.GroupLevel(3).ControlSource = "Pool"
Else
Me.GroupLevel(3).ControlSource = Me.GroupLevel(4).ControlSource
End If
'BillNetwork
If .chkBillNetwork Then
Me.GroupLevel(2).ControlSource = "BillNetwork"
Else
Me.GroupLevel(2).ControlSource = Me.GroupLevel(3).ControlSource
End If
'MasterActivity
If .chkMActivity Then
Me.GroupLevel(1).ControlSource = "MActivity"
Else
Me.GroupLevel(1).ControlSource = Me.GroupLevel(2).ControlSource
End If
End With
'Top Level For Billable Product Offering
Me.GroupLevel(0).ControlSource = "ProjectId"

Report_Open_Exit:

On Error Resume Next
Exit Sub

Report_Open_Error:

MsgBox "Error " & Err.Number & " (" & Err.Description & _
") in procedure Report_Open of VBA Document
Report_rptBPOProducOffering"
GoTo Report_Open_Exit
End Sub