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

help reports

P: n/a
Hi
Below mention is the reply from Salad on my query i created a crosstab
query and form not based on any table of qurey but this doesnt work .
I somehow have missed something actually i have too many database
tables with relationship and need the cycle time of projects.

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 24 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
access baby wrote:
Hi
Below mention is the reply from Salad on my query i created a crosstab
query and form not based on any table of qurey but this doesnt work .
I somehow have missed something actually i have too many database
tables with relationship and need the cycle time of projects.
If you have created the query most of the hard part is over.

Click on Reports/New/Report Wizard. Select your query and follow the
step to the end. Most likely you'll have to make some adjustments to
the form regarding the placement of the fields.

Unless your query filters the records you want on the report, you have
two options. The first is to prompt for the filter. For example, if
the query is to include records between a date range you could enter in
the criteria row of the date field
Between [Enter From Date] And [Enter To Date]

If this is an application other users will be working with, you might
want to create a form that calls the report you created and by using
fields you enter on the form filter it when you call the report with the
Docmd.OpenReport
command.
>
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 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.