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...

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...

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...

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 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...

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...

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...

I am grouping by one field in my Crystal Report but need to be able to sort by a different field within that group. Any crystal gurus out there?

I have a formula which resides in a subreport. The results of this formula are either "Pass" or "Fail". I would like the textcolor for the result to be displayed in green for "Pass" and red for "Fail". Anyone ever done something like this before. Not...

I have a Crystal Report with a number of subreports. One of the details sections of the main report includes a subreport. I would like it if when I ran the report, it would allow the subreport to be split within several pages. Currently, the subreport shows up on page 2. I would like it to...

I am using Crystal 8 RDC in my VB app. I run a number of reports with paramaters which run beautifully. Typicall when I Enter a Selection formula in the Select Expert it will look something like: {ado.Issuer} Is like {?IssuerParm} Can anyone give me an example of how to use an If statement...

I have a ListView control which is being loaded on form load procedure. I also provide a command button on the form whose purpose is to refresh the ListView control. This refresh button calls on the same code which is used to load the ListView on form load. The ListView loads beautifully on...

I am using VB 6.0 SP5. I recently upgraded to SP5. Since then I have had the following problem... When I try to install a package to a client machine, the installation fails when it is installing the following two files: msvcrt.dll expsrv.dll The installation prompts for a reboot...

I am attempting to change the caption property of a label on one form from the code in a different form. Easy enough except the name of the label (whose caption property I am trying to change) must be dynamic. Why won't this work? Dim MyLabel As Label Form2.MyLabel.Caption =...

I keep getting kicked out of vb6 while in design mode. Last time it kicked me out just for pressing Shift+DwnArrow to highlight some text. Other times I just can't figure out why it is kicking me out but regardless I get the following message: vb6.exe has generated errors and will be closed by...

I would like my code to execute a msgbox if a certain form is open. Is there some kind of Boolean that will tell me if a form is currently open?

I have a form with two combo boxes a command button and a list box. The first combo box contains the names of the column headers in my list box. The second combo box contains the choices of Ascending or Descending. When the user clicks the command button (labeled "Sort"), I would...