Recent content by Jefftopia

I am using vb6 to pass parameters and display crystal reports (using the reports design component). I have a main report which I have deleped which is essentially being used as nothing more than a house for my two subreports. Problem: I am attempting to pass a date parameter to the two...

Need a formula to calculate "Availability". Here is what I am trying to accomplish: Activity Balance Availability 600.00 40.00 7.00 607.00 33.00 4.00 611.00 29.00 (1.00) 610.00 30.00 I have been...

Because I can't add. Here it is again. Activity Total Assets Availability 600.00 40.00 7.00 607.00 33.00 5.00 612.00 28.00 1.00 613.00 27.00

To be specific, I am trying to build a formula to be used to determine "Availability". Ngolem provided a good technique for calculating "Total Assets", but I am having difficulty in altering that formula to determine "Availability". Here is what I am looking for: Activity Total Assets...

Follow-up question: How could I change @CalcBal to add the last single account activity instead of the sum of all prior account activity? Gracias

Ngolem, excellent. Works great. Appreciate your response:)

Here is my situation. I have a main report containing one sub report. In the sub report I have a beginning account balance. In my main report I have account activity and a running sum of that activity. What I need to do now is have a formula which takes the beginning account balance from my...

Decided to make change to underlying table report is based on. Now I have a single date field in the underlying table. I even took your suggestion and constructed a query to check for bad dates in my table. Everything checked out ok but I am still getting the following error: "The string in...

I have a formula which is giving me the following error when I try to view the report. Crystal Report Viewer The string is non-numeric Odd thing is the formula check out ok when I am in the formula editor. Here it is: if IsDate(CStr({ado.SettleDate})) = True then {ado.SettleDate} else...

Thx. Wrks Great! Kicking myself for not thinking of it. I think I need another cup of coffee.

I am attempting to build a query which has the names of people going across the top as my column headers and their account balances as values beneath each of the respective account holders. The problem is that while I can use AcctHolder as my ColumnHeader and AcctBal as my Value in a crosstab...

Is there a function to convert text to initial caps? For example: The string "EAT MY SHORTS" would be converted to "Eat My Shorts".

I must be missing something. I did a Save As in the design environment (vb6) to create the new report files. As a result, 3 files were created (DCA, Dsr & dsx). I then opened the Dsr file through Explorer and renamed the file in 2 places (to refer to the new report name). I then did a Add...

I have a report already created that I would like to leverage off of. The new report I will create will contain most of the same elements and be driven off of the same data source. How can I copy my completed report so that I don't have to go through all of the redundancy to create another...

thanks Ngolem. that does it.