Need help on reports

[access baby]

i have a huge database based on date and time need to create
different report we need to measure our work processes how many order
received , order cancelled, completed and count of items completed on
or before time.

chart or pivot report how do i do that.
Please help.
Thanks,

[salad]

access baby wrote:

i have a huge database based on date and time need to create
different report we need to measure our work processes how many order
received , order cancelled, completed and count of items completed on
or before time.

chart or pivot report how do i do that.
Please help.
Thanks,

If you are a newbie, the best method is to
1) Create a query that you will use in the report.
2) Use the Report wizard to create the report template.
3) Create a form to call the report.

I usually like to create a query that does little filtering for a
report. It is irrelevent in sorting the query...that's done in the
Report under the menu item View/Sorting&Grouping. The query should
produce most (if you don't have calced fields) the columns you want.

In your case your query would be a Pivot/Crosstab.

Once the report is created using the wizard, put in the finishing
touches, move/size the fields, etc.

Now create a form. You might want a from and to date. You might want
to select by client or employee. Whatever fields you want to filter on
put in.

Now, I have a command button for calling the report. I might do
something like this.

Dim strFilter As String
If Not IsNull(Me.FromDate) Then
strFilter = strFilter & "DateFld #" & Me.FromDate & "# And "
endif
If Not IsNull(Me.ToDate) Then
strFilter = strFilter & "DateFld < #" & Me.ToDate & "# And "
endif
If Not IsNull(Me.ProductType) Then
strFilter = strFilter & "ProductID = " & Me.ProductID & " And "
endif
etc.....
'Remove the And at the end of the string
strFilter = Left(strFilter,Len(strFilter) - 5)

'Call the report
Docmd.OpenReport "YourReportName",acViewPreview,,strFilter

[access baby]

On Apr 18, 10:43 am, salad <[e-mail]:

access baby wrote:

i have a huge database based on date and time need to create
different report we need to measure our work processes how many order
received , order cancelled, completed and count of items completed on
or before time.

chart or pivot report how do i do that.

Please help.

Thanks,

If you are a newbie, the best method is to
1) Create a query that you will use in the report.
2) Use the Report wizard to create the report template.
3) Create a form to call the report.

I usually like to create a query that does little filtering for a
report. It is irrelevent in sorting the query...that's done in the
Report under the menu item View/Sorting&Grouping. The query should
produce most (if you don't have calced fields) the columns you want.

In your case your query would be a Pivot/Crosstab.

Once the report is created using the wizard, put in the finishing
touches, move/size the fields, etc.

Now create a form. You might want a from and to date. You might want
to select by client or employee. Whatever fields you want to filter on
put in.

Now, I have a command button for calling the report. I might do
something like this.

Dim strFilter As String
If Not IsNull(Me.FromDate) Then
strFilter = strFilter & "DateFld #" & Me.FromDate & "# And "
endif
If Not IsNull(Me.ToDate) Then
strFilter = strFilter & "DateFld < #" & Me.ToDate & "# And "
endif
If Not IsNull(Me.ProductType) Then
strFilter = strFilter & "ProductID = " & Me.ProductID & " And "
endif
etc.....
'Remove the And at the end of the string
strFilter = Left(strFilter,Len(strFilter) - 5)

'Call the report
Docmd.OpenReport "YourReportName",acViewPreview,,strFilter

Thanks for replying .

[access baby]

On Apr 18, 11:33 am, access baby <[e-mail]:

On Apr 18, 10:43 am, salad <[e-mail]:

access baby wrote:

i have a huge database based on date and time need to create
different report we need to measure our work processes how many order
received , order cancelled, completed and count of items completed on
or before time.

chart or pivot report how do i do that.

Please help.

Thanks,

If you are a newbie, the best method is to
1) Create a query that you will use in the report.
2) Use the Report wizard to create the report template.
3) Create a form to call the report.

I usually like to create a query that does little filtering for a
report. It is irrelevent in sorting the query...that's done in the
Report under the menu item View/Sorting&Grouping. The query should
produce most (if you don't have calced fields) the columns you want.

In your case your query would be a Pivot/Crosstab.

Once the report is created using the wizard, put in the finishing
touches, move/size the fields, etc.

Now create a form. You might want a from and to date. You might want
to select by client or employee. Whatever fields you want to filter on
put in.

Now, I have a command button for calling the report. I might do
something like this.

Dim strFilter As String
If Not IsNull(Me.FromDate) Then
strFilter = strFilter & "DateFld #" & Me.FromDate & "# And "
endif
If Not IsNull(Me.ToDate) Then
strFilter = strFilter & "DateFld < #" & Me.ToDate & "# And "
endif
If Not IsNull(Me.ProductType) Then
strFilter = strFilter & "ProductID = " & Me.ProductID & " And "
endif
etc.....
'Remove the And at the end of the string
strFilter = Left(strFilter,Len(strFilter) - 5)

'Call the report
Docmd.OpenReport "YourReportName",acViewPreview,,strFilter

Thanks for replying .- Hide quoted text -

- Show quoted text -

Hi Salad,

I think i didnt quite get it right i created crostab query and a form
not connected to any form or table just from and ToDate but it dosent
work . And as i told its a huge database in Excel imported or linked
to Access so its not properly normilised too. but since i just started
this job i am working on it and they need the reports everyday they
want the cycle time of the projects. Please help.

[bhavu10]

On Apr 18, 1:43 pm, salad <[e-mail]:

access baby wrote:

i have a huge database based on date and time need to create
different report we need to measure our work processes how many order
received , order cancelled, completed and count of items completed on
or before time.

chart or pivot report how do i do that.

Please help.

Thanks,

If you are a newbie, the best method is to
1) Create a query that you will use in the report.
2) Use the Report wizard to create the report template.
3) Create a form to call the report.

I usually like to create a query that does little filtering for a
report. It is irrelevent in sorting the query...that's done in the
Report under the menu item View/Sorting&Grouping. The query should
produce most (if you don't have calced fields) the columns you want.

In your case your query would be a Pivot/Crosstab.

Once the report is created using the wizard, put in the finishing
touches, move/size the fields, etc.

Now create a form. You might want a from and to date. You might want
to select by client or employee. Whatever fields you want to filter on
put in.

Now, I have a command button for calling the report. I might do
something like this.

Dim strFilter As String
If Not IsNull(Me.FromDate) Then
strFilter = strFilter & "DateFld #" & Me.FromDate & "# And "
endif
If Not IsNull(Me.ToDate) Then
strFilter = strFilter & "DateFld < #" & Me.ToDate & "# And "
endif
If Not IsNull(Me.ProductType) Then
strFilter = strFilter & "ProductID = " & Me.ProductID & " And "
endif
etc.....
'Remove the And at the end of the string
strFilter = Left(strFilter,Len(strFilter) - 5)

'Call the report
Docmd.OpenReport "YourReportName",acViewPreview,,strFilter

Hi Salad i tried to do created crosstab query and a report and aform
with no tbl or qry connected and comand abutton to open reoprt but i
think i missed something. Can you be more specific.Please