473,772 Members | 2,391 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Urgent,Plz help me .......need to calculate the total of a field in subreport.

Thank you in advance for any suggestions...
I'm using crystal reports version 8 & SQL server.
I've created a report that is composed of 2 parts: 1st part contains
the main report which uses database1 (db1) located on server1(S1), 2nd
part contains the subreport which uses database2 (db2) located on
server2 (S2), and I've used (parameter field & a certain fields) to
link the subreport to the main report.

The subreport is composed of 2 columns: the 1st one is from db2 &
S2, the 2nd one is a result of multiplication of the 1st column to a
column field situated in the main report (that I've imported it to the
subreport through a formula field that I've created in the subreport
and I've assigned to it the value of a column situated in the
main report by using the subreport links).

And what I'm trying to do is the total of the 2nd column
situated in the subreport: I've tried many ways such as running total
& the ∑ to calculate it but always the result is false. I've
tried also to put the subreport in the footer of the main report but
because of the subreport links that must exist the data column itself
has became false.
Any suggestions ???
Plz help !!!
Nov 12 '05 #1
1 3522
Microsoft.publi c.vb.crystal may be an appropriate group for a Crystal
Reports and SQL Server question, but all the "access" groups to which you
posted this are not -- it would only be by chance that you'd get a useful
answer there.

For other good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP
"Manal/report designer" <ma***********@ hotmail.com> wrote in message
news:21******** *************** ***@posting.goo gle.com...
Thank you in advance for any suggestions...
I'm using crystal reports version 8 & SQL server.
I've created a report that is composed of 2 parts: 1st part contains
the main report which uses database1 (db1) located on server1(S1), 2nd
part contains the subreport which uses database2 (db2) located on
server2 (S2), and I've used (parameter field & a certain fields) to
link the subreport to the main report.

The subreport is composed of 2 columns: the 1st one is from db2 &
S2, the 2nd one is a result of multiplication of the 1st column to a
column field situated in the main report (that I've imported it to the
subreport through a formula field that I've created in the subreport
and I've assigned to it the value of a column situated in the
main report by using the subreport links).

And what I'm trying to do is the total of the 2nd column
situated in the subreport: I've tried many ways such as running total
& the ∑ to calculate it but always the result is false. I've
tried also to put the subreport in the footer of the main report but
because of the subreport links that must exist the data column itself
has became false.
Any suggestions ???
Plz help !!!

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1388
by: SB | last post by:
What I want to achieve ... Display file names from sql server database, on click the file should open up using test.exe file. Using the following code, I am able to display the files and click on related link, however, I can't get to pass on the filename. I would also like to bypass the message 'Open/Save/Save as' and directly be able to open the file. Herebelow is the code I have, will appreciate if someone
1
1442
by: greesh maheshwari | last post by:
i am successfull to Create the Project on the Remote Web Server, now i want to add a Class Library in same project, but the following Error Occur. 1)The project is not filly trusted by the .net runtime. This usually because it is either a network share or mapped to a network share not on the local
2
1970
by: Martin | last post by:
Hello, We are in the process of putting together an A class PHP Development team(ecommerce / billing applications) for a project in the Bay Area. Reqt. details: ReqId : Req-3616 - Senior PHP Developer Primary Skills: PHP, Linux, Apache Secondary Skills: C++, SQL
2
2330
by: Jana | last post by:
Using Access 97. Background: I have a main report called rptTrustHeader with a subreport rptTrustDetails in the Details section of the main report. The main report is grouped by MasterClientID. There are also several other subreports in the main report's footer. The rptTrustDetails subreport has two grouping levels MasterClientID and ClientID, with headers and footers for each grouping level. In the ClientID footer, I have an...
3
2596
by: voroojak | last post by:
hi I have a such abig problem. i have to disable the shortcut keys (table, query, report, .....) except form. the user should just be able to open form and all other the shortcut should be disable. i have one more problem and that is i want to disable my total field. i eman teh user cant enter any data in total fields. my total field is working under save buttom. i mean when i press teh save buttom it will calculate the total. it is working...
8
36299
by: jimmyg123 | last post by:
Hi, I'm trying to do something similar. This is my javascript <script type='text/javascript'> function totalise(price,total) { var qty = window.document.getElementById('qty').value; var result = total; result.value = price * qty; }
1
3347
by: pdm | last post by:
hoi access, I have a subreport and with the id of inheritance of OOP I like to reuse this subreport in other main reports and hide some fields. First, is this possible and second what is the correct syntax. I tried many combinations but error on syntax. first I create a MainReportFeedMainReports with only one subReport where 5 fields are not visible. I need the correct syntax to say on the event Open
2
4663
by: 06mca30 | last post by:
How to calculate total no of hits for my home page?
1
4588
by: dan.cawthorne | last post by:
Kinda Confused to why i cant get a single text field to add up all the Projects that are filtered Via a Query. I Have a Query Based on a Projects Table. The Query Have a Criteria To Select a Estimator, Which Then List all the Projects that Estimator as worked on. When Then Opens a List Type Report thats Shows all The Projects Related to that User. and that Report Theres a Field called
3
2491
by: John Torres | last post by:
how do you calculate total time hours? I have sub total hours for each day and I've been trying to total all the hours. I'm getting odd numbers. Thanks. John
0
9619
marktang
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...
0
10261
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
10103
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
10038
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
8934
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7460
isladogs
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...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3609
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2850
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.