Search results for query: *

Many thanks Denny that has worked. I must of checked the permissions on the folders beneath root half a dozen times without realising I needed to do the same thing on root itself. Thanks again, Matt

I have a user who has developed a simple reporting website using Reporting Services. This uses anonymous access in IIS, but I need to disable this so that I can pass user credentials through to the SQL Server which runs on the same machine. However when I disable anonymous access (IIS Manager...

Thanks very much Paul, that has been irritating me for the past week!

Hi, I have a measure coming from a database field with the data type decimal(18,2), in AS the field is AggregateFunction = Sum and DataType = Double. When I look at the aggregated values some have the 2 decimal places I would expect to see but others go to 6 decimal places. This is not...

Hello, I'm just wondering if anyone has tried using Business Objects Voyager with MSAS 2005's drillthrough actions? I have Voyager successfully picking up a 2005 olap cube but I cannot get it to see a drillthrough action within that cube, I've tried various things but I'm starting to wonder if...

Hello, I'm just wondering if anyone has tried using Voyager with MSAS 2005's drillthrough actions? I have Voyager successfully picking up a 2005 olap cube but I cannot get it to see a drillthrough action within that cube, I've tried various things but I'm starting to wonder if it is...

Hi, I'm looking for some assistance with drill-throughs on SSAS 2005. I've built a Cube from several Dimensions and a Fact Table, the Fact comprises some measures and a description field which is neither a measure nor a Dimension attribute. I now want to define a drill-through which I would...

Many thanks, those advanced settings should provide the required control. Only snag is it means I'll end up issuing/managing seperate BO and db log-ins but I don't think I'm going to get around that. Thanks again, Matt

Hello, Having just migrated to BOXI I'm in the process of trying to overhaul our BO access/security and enforce row level security on our database for both connections through Universes (webi and CR) and directly to the database (CR). I have a solution for the Universe part of this: using the...

I'm in the process of rebuilding a 2000 DTS package in 2005 and am hoping for some advice on the best way to use the Data Flow to do this. In my 2000 DTS I have around 30 tables which are being transferred from 1 SQL database to another SQL database using 30 seperate Transform Data Tasks. I...

We have numerous reports in CE8.5 which display graphs, some of which have been happily working for a couple of years now. However we have suddenly developed a problem whereby the graphs on reports are no longer there when they are viewed and where the graph was we now just have white space...

Thanks for the suggestions and I have found a way around this by using subscript to return the data from the array in 2 seperate lots (as I know it doesn't exceed 2 lots of 255) in 2 seperate formulas. The first: whileprintingrecords; stringvar SG1; numbervar cnt:= ubound({?Solver Group})...

Nice idea but unfortunately not - I still get the same error, presumably because Crystal is making the 'join' calc before the 'left' calc and therefore hitting the 255 limit.

Madawc, Sorry, I'm being a bit thick here but when I try.... Split({?Solver Group}, "")[1] .... as you suggest, I get the following error: This array must be subscripted. For example Array[i]. Can you tell me what I'm doing wrong? Thanks again, Matt

Are you saying I can extract the various values of the parameter array out and show them in seperate fields? If so can you advise how I would go about doing this? I can get the highest/lowest values using maximum/minimum but have been unable to get at the values between them. Many Thanks, Matt

I have a String Parameter field set to have discrete, multiple values which I need to display on the header of my report. I've achieved this with the following formula.... join({?Solver Group},chr(13)) .... and that works fine until many values are selected and the combined lengths of those...

I have a CR8.5 Report on BOXI InfoView which I am unsuccessfully trying to export to a network drive. The Report runs successfully when I export it to a local drive but fails when I point it at the network drive and I'm struggling to understand why. I have previously set the same report up on...

Hi, I have a DTS package running about 30 various tasks. In the middle there are 2 'Execute SQl Tasks'; the first one of these takes a table field and sets all of the values in it to 'N', the second one applies some criteria and sets some of the records to 'Y'. When run independently (i.e. -...

I have written the insert statement below to load some db info into a table. insert into [DB_SIZES]( [NAME], [FILE_PATH], [SIZE] ) select name, filename, (size * 8) from sysfiles I have created this as a Stored Procedure but I think this is going to limit me to using it within a single...

I have the following view which extracts the top 10 records from a table based on their costs. The view sorts these records in descending order so the most expensive one is at the top. What I would like to do is add a new column as a running count to the view so that the first one is 1 and the...