Recent content by HRoarke

Hi all - I've created a web custom control and associated custom designer and, for various reasons, need to programmatically assign the ID property the control gets when it's dropped onto a web form in the designer. The very frustrating thing is that I can set the ID value listed in the...

Synapsevampire - I may have just recreated your exercise of a few years ago. To get Crystal's percentile result, there are two differences between CR's algorithm and Excel's: 1 - Crystal does NOT interpolate bewteen low and high values where the rank is not a whole number. For example,if...

Hello - I am finding there to be unacceptable discrepancies between percentiles calculated via CR10 running totals and percentiles calculated on the same data set using, for example, Excel. Does anyone have any info on why Crystal comes up with a different result for percentiles? The...

I'm facing the same situation - did you ever find resolution? "I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine." — John Galt Atlas Shrugged If you want to get the best response to a question, please check out...

Please disregard this question - bad cube design.... The learning curve for AS is quite a bit steeper than one may reasonably expect! "I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine." — John Galt Atlas Shrugged If...

Good morning, I have a cube in which base values of NULL are translated to 0 in the cube. I've searched for a setting to enable/suppress this behavior but find nothing. Any thoughts? The -0- values are making my aggregations incorrect.... The platform is MSAS2K, SP4. Thanks in advance for...

Hello all, Have a simple cube containing a few numeric measures and three dimensions. I need to calc the Avg and Median of the numeric measures across a given dimension for all members and for each member. The query SELECT avg([Operating Budget].members, [Measures].[a particular numeric...

what - no star? :-) "I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine." — John Galt Atlas Shrugged If you want to get the best response to a question, please check out FAQ222-2244 first

Are there any relationships between the Var[1/2/3] values and the ID value? Also, is this SQL code or VB/ASP? If VB/ASP code, you could construct an array that contains each of the three VAR values, and the ID is a pointer to the appropriate elements in the array. This of course assumes...

Err, not Page.IsPostBack, just IsPostBack. "I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine." — John Galt Atlas Shrugged If you want to get the best response to a question, please check out FAQ222-2244 first

in ASP.NET, page.ispostback will tell you if the load is the response to a REQUEST, e.g. TRUE if it's a postback, FALSE if not. "I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine." — John Galt Atlas Shrugged If you...

Thanks for the feedback, folks. I'll reply one-by-one. ca8msm - you are correct, installing Excel isn't an option on the production box; sonya9879 - don't know about ExcelOWC.dll. I'll look into it, though I'm trying really hard to stay away from 3rd-party widgets.... I'm using the...

Hi folks - I have an ASP.NET web app that contains a class that uses the Excel (v9 in this case) Application object to convert a flat file to XLS. I need to distribute the class to a web server that does not have Office installed. I've created all flavors of Setup/Distribution packages, but...

Cheers, Denis. Here - star for you. "I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine." — John Galt Atlas Shrugged If you want to get the best response to a question, please check out FAQ222-2244 first

Hi - I seem to recall reading about a setting in SQL Server that causes, for example, a stored procedure to start returning results to the caller after the first N records are generated instead of processing an entire statement first. Unfortunately, I can't find any info in books online or...