473,850 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need help on reports

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
4 1718
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&Groupin g. 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.FromD ate) Then
strFilter = strFilter & "DateFld #" & Me.FromDate & "# And "
endif
If Not IsNull(Me.ToDat e) Then
strFilter = strFilter & "DateFld < #" & Me.ToDate & "# And "
endif
If Not IsNull(Me.Produ ctType) 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.OpenRepor t "YourReportName ",acViewPreview ,,strFilter
Apr 18 '07 #2
On Apr 18, 10:43 am, salad <o...@vinegar.c omwrote:
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&Groupin g. 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.FromD ate) Then
strFilter = strFilter & "DateFld #" & Me.FromDate & "# And "
endif
If Not IsNull(Me.ToDat e) Then
strFilter = strFilter & "DateFld < #" & Me.ToDate & "# And "
endif
If Not IsNull(Me.Produ ctType) 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.OpenRepor t "YourReportName ",acViewPreview ,,strFilter
Thanks for replying .

Apr 18 '07 #3
On Apr 18, 11:33 am, access baby <nishkr...@gmai l.comwrote:
On Apr 18, 10:43 am, salad <o...@vinegar.c omwrote:


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&Groupin g. 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.FromD ate) Then
strFilter = strFilter & "DateFld #" & Me.FromDate & "# And "
endif
If Not IsNull(Me.ToDat e) Then
strFilter = strFilter & "DateFld < #" & Me.ToDate & "# And "
endif
If Not IsNull(Me.Produ ctType) 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.OpenRepor t "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
On Apr 18, 1:43 pm, salad <o...@vinegar.c omwrote:
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&Groupin g. 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.FromD ate) Then
strFilter = strFilter & "DateFld #" & Me.FromDate & "# And "
endif
If Not IsNull(Me.ToDat e) Then
strFilter = strFilter & "DateFld < #" & Me.ToDate & "# And "
endif
If Not IsNull(Me.Produ ctType) 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.OpenRepor t "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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1528
by: Galina | last post by:
Hello I already initiated a thread with the same name on 22/03/2004. Thank you everyone who answered me. I wanted to link to that thread, but somehow there was no "Post follow on article" link(?). Sorry for repetition, but the story has developed a bit. We have an Access 2000 database application - reports distributor. Reports are created by developers, then reports and queries are copied into a database (Access 2000 also) on network. It...
3
10684
by: google | last post by:
I have a database with four table. In one of the tables, I use about five lookup fields to get populate their dropdown list. I have read that lookup fields are really bad and may cause problems that are hard to find. The main problem I am having right now is that I have a report that is sorted by one of these lookup fields and it only displays the record's ID number. When I add the source table to the query it makes several records...
3
1267
by: MLH | last post by:
Most of you will recognize that I'm talking about Rick Fisher's product. I bought the version for Access 2.0 thirteen years ago and fell in love with it immediately. Most of you know, by virtue of my lame-ass posts that I only recently migrated from A2.0 to A97 and only recently, I bought Rick's product to support the newer platform. Well, we've been on the topic of references lately and one that I saw in the list was Find and Replace...
3
5266
by: knightsmastergeneral | last post by:
Hi, I'm currently working on getting junit and junireport to take some java files, convert it to xml and then display error messages / success rates etc in html which is one of the features of junitreport. I created a simple Math.java class which contains: package test; public class Math { public int add(int a, int b) { return a + b; }
2
8997
by: =?Utf-8?B?UGF1bA==?= | last post by:
Hi I am running .net framwork 2.0 on a server and after installing a web ap that has crystal reports in it there is an error, cant find crystal report dlls that are in the web.config file. Just wondering is there a crystal report installation that needs to be done on the server? vs.net is not installed on the server, just the framework. thanks. -- Paul G Software engineer.
11
2914
by: NewGuytoNetworking | last post by:
I have an XML that my company sends out daily it used to be created by SQL but I now have to use crystal reports and I can't seem to get it to line up the same. Please help with any references or how to rewrite my schema. I will try to provide pictures of what currently have. (This is Mine from Crystal Reports) <?xml version="1.0" encoding="UTF-8" ?> - <BSASStockStatus xmlns="urn:crystal-reports:schemas"...
1
1193
by: CoolBreeze812 | last post by:
Hi, I need help with a query and I'm having trouble getting it formed correctly. I have 3 tables: users, authorization_users, and reports. The user table contains a bunch of users with fields like userID, first_name, last_name, and such. The authorization_users table contains a permID which is the key from the reports table, userID, and a Value (bit) The Reports table contains a permID, reportName, and a few other fields. I'm trying...
2
2313
by: kenmasters675 | last post by:
I need help with the following code. I am trying to extract two reports at the same time, but I want the viewer to see the report first before exporting it. The reason is in case the report is null. There are two reports, one for 2006 and one for 2007. Problem is when I tried making a Msgbox if statement, it does not work correctly. I want the user to say "yes or no" to extract report and then continue from there. I can't get either...
3
1172
by: Loogie | last post by:
I want to create reports and I don't care if I use crystal reports or vb.net reports. I am using vb.net 2005 and the app pulls data from user created access db's and compact 2005 sdf's. Here is where things get a bit tricky for me. I don't want to open any datasets to create my reports. All of the data I need is staring at me on the screen. Is there anyway to copy over the contents of textboxes and listviews to the report easily? I...
0
1356
by: akshaycjoshi | last post by:
Most of you people are already familier with the working of crystal reports unlike me.I am working on an application when I have no other option but to use CR. It is very diff. for me to read an entire book on CR for a simple report, so I thought if you people can help me :) Here is the table structure. http://img26.imageshack.us/img26/295/crystalpz9.png I opened the crystal reports in VS 2005 and added the crystal report and using the...
0
11011
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10666
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10724
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10351
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5735
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5929
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4546
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4140
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3178
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.