473,320 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 3490
Microsoft.public.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.google.c om...
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
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...
1
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...
2
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...
2
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. ...
3
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....
8
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...
1
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...
2
by: 06mca30 | last post by:
How to calculate total no of hits for my home page?
1
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...
3
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
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.