Search results for query: *

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.

I am attempting to call up a report and imposing parameters (date). I have done this often enough, but the difference here is that the report contains 3 subreports. It is in the subreports where I would need the paramaters to go. Here is the code I am using to call the report. How could I alter...

[Resolved] Thank you all. I ended-up using basil3legs modified code of dgillz. bdreed35 was also on the right path by pointing me to the ToText function. problem solved...

MJRBIM, Something is not working with the first formula. I created 2 formulas exactly as you described above. When I run the report, no result is appearing for the first formula which in turn is making it so the second report contains no result either. I am thinking the value of...

if ({ado.LIB_Spread}/100) > 0 then ({ado.LIB_Spread}/100) else "NA" I am getting the following error message when I attempt to use this formula in my report: "A number is required here" It then places focus on the "else 'NA'" portion of my formula. I have tried...

This one seems rather simple. How can I copy a report in the report design component of vb? I use vb6 to display my reports using RDC. I have a report which I would like to copy. The new report will be based off of the same table as the old report, but will have several added fields...