|
by: Steve Thorpe |
last post by:
Hi
I am trying to write a report that calculates the average number of sales
over 7, 14, 31 and 365 days for each hourly period of the day. the problem
is it takes over 4 minutes to run.
e.g.
Average Xactions per Hour
7 Days 14 Days 31 Days 365 Days
00:00 - 01:00 1,141.6 579.2 261.6 28.8
|
by: Grant Stanley |
last post by:
I'm developing an application in VS.Net 2003 using C#, which uses Crystal
Reports.
When creating each report, crystal asks where the database to use is, so I
specify our SQL server using the ADO option. The problem is that these
database settings seem to get compiled into the report, so when we take the
application to our client it won't work on their systems.
Before running each report I run some code which is ment to reset the...
|
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have reports at the plan (overall totals), department and division
levels which have sorting and grouping implemented with this new
|
by: Mal |
last post by:
I have an ACC 2000 database that has a strange behaviour
I have a small table, with just a few fields...
My report has very simple grouping and sorting, no code bar a NODATA
event.
I have a memo field
When CAN GROW is set to NO everything works just fine.
When CAN GROW is set to YES - watch out.... One record causes BIG
|
by: Paradigm |
last post by:
I have a contract document that is about 20 pages long with various data
base fields in it. I cannot create an Access report that long so I have had
to do it as 5 seperate reports. There are some pages where the text box is
set to can grow because the users text could be lengthy. The number of pages
in the report is therefore unknown because it depends on the users text.
My problem is that I need to print all 5 reports with a continous page...
|
|
by: johnp |
last post by:
Hello Everyone,
Someone asked me today if it was possible to update data in a table via
a report. I saw one thread where someone indicated the solutions.mdb
had a report that did it but I didn't see it.
Does anyone have experience doing this?
Any information is appreciated.
|
by: MLH |
last post by:
Trouble is, it doesn't happen every time. Yesterday, for example, it
happened only once and not again afterward. Some days ago, a similar
situation. Today, well - I tried 7 times straight to open the report
and each time, A97 shuts down. The seemingly hit 'n miss nature of
the error is intriguing. All I've been able to determine is that if I
allow the report to be opened from within code using this line...
DoCmd.OpenReport...
|
by: aldous scotch |
last post by:
I designed a Crystal Report .rpt from within Microsoft
Development Environment 2003 Version 7.1.3088 (VB .NET
IDE).
I selected database fields from the left side Field
Explorer onto the Details (Section3) of the .rpt.
Also, I added a new web form myWebform.aspx and a web
object CystalReportViewer - CrystalReportViewer1 and had a
code behind in ReportSource
|
by: nmsreddi |
last post by:
Hello friends
iam using asp.net2.0 and c#,
i am developing ajaxenabled website ,where my project is mainly base on crystal reports ,i am placing crystalreport viewer in updatepanel show to avoid button click post backs and also page navigation post backs of crystalreport ,
but the problem when i place the report in update panel ,the print option and export option of the crystal report are not working ,
when i place the crystalreport...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
|
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...
|