Search results for query: *

What I've been doing is one text field in Crystal, letting the user put values in that text field separated by commas, and eliminating any spaces they may put in. Ie. john, joe

I have a stored proc that does this. This statement allows the parameter to accept multiple names, separated by commas, and eliminates any spaces the user may put behind a comma. Can't gaurantee what it does with "O'Neil" though. DECLARE @strUsername varchar(100) set @strusername = 'john...

One of our report developers uses the IP address of the server when publishing a report (Crystal Reports 11), and I use the servers Logical name (ie. BOEAudit - shown in BO Crystal Reports XI book) Does it matter which one is used?

Thanks for looking into it. I'll contact Business Objects.

These are the parameter: The {@DateFilledTo} is a Parameter passed to the storedproc {@ToDate} = maximum({storedproc;1.DateTo}, {storedproc;1.DateGroup}) Page Footer: "Data as of " {@ToDate}

Formulas @DateFrom & @DateTo Each page will get a date range based on year (dateGroup) So, there could be multiple pages (2006,2007, etc) >Initial post correction: This is a page footer not report footer. The Page footer date is: (date, by group) "Data As Of: " (command.@DateTo...

In a report footer (Crystall Reports 11) we display the date range the report is run. "Data as of 12/31/2006" displays when using the parameters 1/1/2006-12/31/2006. I have a second date parameter for the second page for the next year (2007). When we export using Microsoft Word - Editable RTF...

Never mind, we have resolved the "mystery". It was the printer driver for some of the users. The upgraded printer driver created a clear company logo in JPG format.

I am using Crystal Reports XI. We are using Crystal/BOXI with a web-interface. When exporting from the Crystal report to a PDF through the web-interface it prints as a raster graphic and is blurry. I have tried .jpg, .bmp, 'converted' the image in Crystal, different printers, and have called...

It should suppress using the same code as the GF. if isnull({#RTotal0}) then // or zero true // suppress else false // don't suppress

Just throwing my two cents in... Could you find the first character and test for string? Sub Findtext() ' 97 - 122 (a - z) Dim x Dim y y = Asc(Me![Location])) Debug.Print y End Sub this returns a number where 97-122 is A-Z. Hope it helps.

You can build multiple date main/sub reports using the following SQL. Each page of my Crystal XI breaks on the column 'DateGroup#' Link on the 'DateGroup#' and the @Date_From1..2..3 and the @Date_To1..2..3, etc. --Build Date Group 1 if @Date_From1 is not null BEGIN insert into...

I have figured it out. It was in the settings I had under the Hyperlink / Another Report object, and the fields object name and data context.

My report will drill-down in Bus Obj XI with the DHTML viewer. (using my option in hyperlink with DHTML report part drill-down) It won't drill-down in the CRViewer. I'm testing it without a link on my Intranet by using the HTML address similar to the one here...