By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 1,534 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 IT Pros & Developers. It's quick & easy.

Need help on reports

P: n/a
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,

Apr 18 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Apr 18 '07 #2

P: n/a
On Apr 18, 10:43 am, salad <o...@vinegar.comwrote:
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 .

Apr 18 '07 #3

P: n/a
On Apr 18, 11:33 am, access baby <nishkr...@gmail.comwrote:
On Apr 18, 10:43 am, salad <o...@vinegar.comwrote:


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.

Apr 24 '07 #4

P: n/a
On Apr 18, 1:43 pm, salad <o...@vinegar.comwrote:
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

Apr 25 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.