Search results for query: *

Is there a work-around within Access that will allow the Database to look at the following two (2) IDs as separate distinct records? Record A: "123abc456def" Record B: "123ABC456DEF" Any suggestions? Thanks, Jon Jon Palmbak Director Sales Finance www.broadridge.com

I have the following information in a Pivot table: Jan, Feb, Mar... Budget figures and a Total for the year, what I'm trying to do is Reference the Grand Total and I keep getting a #Ref, I can reference other parts of the pivot table using the GetPivotData function without a problem, it's just...

I'm using Excel 2000, in the background I'm using VBA to populate data/functions into my spreadsheets.Every function works and shows the right result however one user defined function show only "#NAME?" instead of expected result. When I click on the cell the function...

We have a warehouse environment which I'm trying to connect to via ODBC (either Access/Excel or Crystal) for whatever reason, I'm only seeing a limited number of the available tables. We have about 12,000 tables in our environment, does anyone know whether there's a limitation on how many...

I'm in the process of instituting a reporting solution throughout my company. My experience is with Crystal but they are pushing Actuate... so my question is; which is better or does it depend on the reporting/analysis requests? Any thoughts will be highly appreciated. - Jon Jon Palmbak...

03/15/04 - LL58781: BRYANT ODELL; M5 120 W 56 ST to QUJ Im trying to pull the following information out of the text above "M5 120 W 56 ST to QUJ" I can't use the right/left function (same for mid) because the length won't always be the same. Is there a function I can use that shows...

This is what I have: This is what I am getting from an Address field. =============================== Stephen E. Miron, Esq.|Miron Building Products Company, Inc.|Route 9w|Lake Katrine Rd =============================== This is what I want: =============================== Stephen E. Miron...

Is there a conditional formatting option available for shading alternating rows? Whether it be a Group1 or Group2 or Detail sections of a report. Anyone have any suggestions? Thanks in advance, Jon

I am posting reports to Crystal Enterprise, is there any formula that I can use that will select the prior month for reporting purposes. At the month end, we have 30 or so reports with parameters, is there any way I can use a formula instead of a parameter? Regards, Jon

Has anyone out there had any experience integrating CE 8.5 with Plumtree??

Is there a size limitation in Crystal on how big a report or subreport can be? I am running a report that is about 1000 pages long and the Save icon is coming up inactive. Is there something that I can change so I can save this report instead of rerunning the report? Thanks

Does anyone know how to round a number to the nearest 5.00? Ex. If I have 123.54, I want to round it to 125.00 or if I have 127.52 I would want that rounded to 130.00. Thanks, I am using Crystal Reports 8.5 Jon

I am running CR against a UniVerse Database and it takes about 1-3 hours for some of my reports to run, If I were to post multiple reports in Crystal Enterprise, would this be advisable if reports take that long to run on a regular stand-alone machine, especially if the possibility of multiple...