Search results for query: *

Hi there I'm trying to add folders into .Net, but failing everytime. here is my code. Dim objOutlook As New Outlook.Application Dim objNS As Outlook._NameSpace = objOutlook.Session Dim objTasks As Outlook.MAPIFolder =...

Hi there I've wrote a piece of code that creates directory structure on a network. I've tested this on my local drive and it creates the folder fine. When I can the path to the network path, I keep getting an 'could not find the path' error. I've check my acces rights to the network and they...

I've a straightforward if if isnull({ORC_get_O07MarketingLead.Description}) then ( strMarketingindicator := "No" ) Else strMarketingindicator := "Yes"; Wanting to colour in Crystal according to yes or no. I tried color (R/g/b) no luck. Is there another way? Redeem.

I use: IIF ({ORC_get_O07MarketingLead.Description} = 'Marketing Lead', "Yes", "No") When variable is other than Marketing Lead, the second part of the statement (else) does not perform. So I get either Yes, or Blank (instead of No). Any ideas? Thanks Redeem

I've deployed an asp.net application to a server, but receive the following message, thus not allowing me to see the errors. What do I need to config to get the error messages. Error message is: Server Error in '/Admin' Application...

Here's my statement: WHERE (AMGR_Opportunity.Create_Date BETWEEN CONVERT(datetime, '01/11/2004') AND CONVERT(datetime, '11/01/2005') Lee

Hi there I keep getting a 'dbo.AMGR_Client.Contact_Number is invalid in the select list because it is not contained in an aggregate funtion or a GROUP BY clause.' I want to count all the client names in all of the dbo.ORC_get_G01AccountStatus.Description but get the above error. Any ideas...

I've 3 columns of data with 15 row. I want to display my display it as 6 columns with 8 row, so to fix the grid across the screen. Can this be done on format? Or does this need to be programmed? Lee

Hi I've created a company parameter, reading a list of company names from a table. The problem is there are a couple of thousand entries, and when creating the parameter, it only brings in a couple of hundred. Is this a limit to Crystal or are there alternative methods to get a list of...

Hi there, I've got my report loading up within my IE browser using the Crystal report viewer. Im having problem with the loading of pages when I use arrow navigation (next, previous etc). Page 1 loads fine, I load page 2 ok, but page 3 doesn't load. Click on last page, page 4 loads fine. If...

I have a start date parameter and end date parameter, and I want to stop users entering a start and end date that is greater than 1 months (or 28 days). I know how to do this in VB.Net, but not sure how to within Crystal Language. Is there an easy way, or is it a big function? Thanks Redeem.

how do u?? in strings and numbers? I can define an array with a certain number of elements, e.g. 2 that have numbervar shared currencyvar array shdSellingNew1 := MakeArray(0,1000);

I define my array at the top of the page of the main report: whileprintingrecords; shared stringvar array shdclientname[2]; Shared NumberVar intCount :=1; I then have my formula in the body of the report Whileprintingrecords; Shared stringvar array shdclientname; Shared numbervar intcount; //...

Hi there, A report that I am performing at the present time I need call and use SQL functions from Microsoft SQL server. Can this be done in Crystal version 10? I know you can run stored procedures, and get back data to the report. Cheers Lee.

Hi there I've this weird IF error that isn't catching any of my IF statement, but running the last statement. code: If Left(GroupName ({Command.RRE_Code}),1) = "A" // Business Services then shared stringvar shdvarACode = 'A'; shared currencyvar shdvarASellingPrice := Sum ({@Selling...

Hi there How do you define shared variables with BASIC (not Crystal)SYNTAX, I'm coding using it: If Left ({Command.RRE_Code},1) = 'J' then shared stringvar shdvarJCode = 'J'; shared currencyvar shdvarJSellingPrice := Sum ({@Selling Price}, {Command.RRE_Code}); shared...

I'm able to make a shared variable of a data field , e.g. command.jobid, but can you make running totals shared? thanks

Hi there I've a job number and a description that I want to pass from a sub report to my main report: How do I do this? any tutorial around? thanks

Hi there, I'm previewing a large report in Crystal 10. Its a slow report so I stop it half way thru loading. When I want to navigate through the pages that I've loaded so far, it start reloading data again. Is there an option to prevent that from happening? Thanks Lee.

Hi, Is there an internal function in Crystal that Adds up the number of records (details)? Thanks Lee