472,336 Members | 1,263 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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


Hi, im tryng to display some data in a report.
The data im displaying is corect,but it contains calculating totals as
well. The totals that r displayng r incorrect.Plaese hav a look at the
code below to see if u cn spot anythng im doing wrong.

<% If Method <> "" then %>
<% If Method <> rstMain("Metode") then
MTel = 0%>
<td colspan="2"><font face="Tahoma" size="-2"
color="Black"><B><I>Total for <%= Method %></I></B></font></td>
<td align="right"><font face="Tahoma" size="-2" color="Black"><B><%=
MTel %>fj</B></font></td>
<% End If
End If %>
<td><font face="Tahoma" size="-2" color="Black"><%=
rstMain("Metode") %></font></td>
<td><font face="Tahoma" size="-2" color="Black"><%=
rstMain("Onderwerp") %></font></td>
<% If rstMain("Opmerking") <> "" Then %>
<td><font face="Tahoma" size="-2" color="Black"><%=
rstMain("Opmerking") %></font></td>
<% Else %>
<td><font face="Tahoma" size="-2" color="Black">&nbsp;</font></td>
<% End If %>
<% MTel = MTel + 1 %>
<%Method = rstmain("Metode")
Total1 = Total1 + 1 %>
Wend %>
<td colspan="2"><font face="Tahoma" size="-2"
color="Black"><B><I>Total for <%= Method %></I></B></font></td>
<td align="right"><font face="Tahoma" size="-2" color="Black"><B><%=
MTel %></B></font></td>
<td colspan="2"><font face="Tahoma" size="-2"
color="Black"><B><I>Total for Contacts for the
<td align="right"><font face="Tahoma" size="-2" color="Black"><B><%=
Total1 %></B></font></td>
<% End If %>

The total which is diaplyng wrong is the 1st MTel.Of which is contained
in an if statement which should nt excecute because the condition does
nt fulfill,bt it is excecuting.

Please help!

Jun 12 '06 #1
0 957

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

Similar topics

by: shovan | last post by:
I am creating a customized Purchase order report using asp. I have developed the reoprt as it is displaying the amount against a sales rep within a...
by: Pioneer | last post by:
HI, We are using BI software on Datawarehouse for reporting purpose. In that we had some performance realted issues. So the only solution to...
by: | last post by:
Hi, I am loading some crystal reports in a method similar to this (see below). And set the cursor to waiting while the reoprt is loaded, run and...
by: Ahmed Marghani | last post by:
Hi Dear i am using Crystal Report Viewer control in ASP.NET to display crystal reoprt under windows 2000 professional. the control work well but i...
by: spammy | last post by:
Hi all, Im having difficulty serving synamically generated PDFs to clients via asp.net. Im using crystal reports to generate them. In my page...
by: mjf | last post by:
I need to come up with a tool to compare the table definition and/or its data before and after some modification to the DDL or some tests (that...
by: himadri das | last post by:
i have a document in MS word. I upload the file in the mysql database using php.but i failed to download the file using php, what is the process of...
by: ditch | last post by:
Hi I am using the following code, and basically what I want it to do is this: User selects a Business Unit from drop down list, they then...
by: access baby | last post by:
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...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

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.