Search results for query: *

Do you mean Report Header or Page Header? The Report Header is the white space in the Body of a report before the 1st object, by definition, this only appears on the 1st page. Cheers, Leigh "If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you...

Steven, I'm almost certain that the to achieve your goal you'd need to alter the code behind the Date Picker control... Which may not be possible. The other option would be to write your own .Net Date control and incorporate this in your reports. Cheers, Leigh "If you had one shot, one...

Sorry, my Fact table has an ActionID to denote Invoice, Upload etc. I need to filter this calculation to exclude fact rows that don't have a key value of 1 for ActionID Cheers, Leigh "If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture...

Hi, I have 2 calculated measures, one which should return a value for the given period, the other the cumulative value to date. My syntax is as follows: Period: ([Measures].[Quantity], [DimAction].[Action].&[1]) Cumulative: SUM([Measures].[Quantity], [DimAction].[Action].&[1]) Can anyone...

Hi, SSRS has a variety of scheduling and distribution options, all set from within the Report Manager interface. Apart from using an SSIS Script task and doing things with .net i would think you need to look at "Data Driven Subscriptions", however these are only available with the Enterprise...

In addition to indexcing your foreign key columns, you should also try to index the columns used in your WHERE clause if they're not already. Cheers, Leigh "If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

Whilst i'm sure your organisation has it's reasons, i'm always baffled as to why anyone would want to create a report in Reporting Services, output it to Excel for modification and then use the Excel version. Why not create the report, including the required alterations in Reporting Services...

Firstly, don't ever, EVER use SELECT *... This is an extremely inefficient method and will not make use of indexes to speed up your query. Secondly, use Store Procedures whenever possible as they will use a pre-stored execution plan which will also increase performance. Look at books online for...

Hi Jose, You need to attach your database from your new hard drive to SQL Server Management Studio (2005) or Enterprise Manager (2000). If you right click the databases folder in SSMS, Attach and select the .mdf file of your database. Not sure of the option in 2000, not got it on this machine...

There's a number of posible reasons for this... 1. Do you have a vaild SQL Login on each instance of SQL Server? Also consider... 2. Is your SQL Server 2005 instance set up to allow remote conections (Start > Programs > SQL Server 2005 > Configuration Tools > SQL Server Surface Area...

Sure am Geoff... had a paranoid attack about using my full name in public forums (identity theft?) so decided on a more suitable handle. As i'm working as a SQL BI consultant, thought it apt... Cheers, Leigh "If you had one shot, one opportunity, to seize everything you ever wanted, in one...

Sorry, i forgot about Custom/Calcualted fields which would do the same as Formulas/Varables in CR [ponder] You could also write your own .net assemblies and use them in your report but that may be a bit of over kill. From a best practice point of view though i'd repeat my suggestion to do...

Hi, sp_help will show you the info you're after, just add the name of the object. USE AdventureWorks GO sp_Help [Production.Product] HTH. Cheers, Leigh "If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

Hi DeepSheep, Crystal and Reporting Services are as you know very different. There are apps out there that claim to convert CR to RDL, but they aren't that good so any conversion must be done manually by recreating your reports in BIDS. Unlike Crystal, my advise for ANY RS report would be to...

Hi, I don't think there's any other way of deploying your images. Whilst its probably the same amount of effort, have you thought of creating an 'Images' folder within Report Manager, making it hidden from users, deploying your projects including the images and then moving the images to the...

Hi, I have a AS 2005 SP2 cube with an Account dimension for financial statements. I need to use the ByAccount AggregateFunction property setting to ensure that both the Balance Sheet and Profit and Loss statements calculate correctly, however for reasons unknown i cannot get the correct...

Can you not create a new AS cube combining the required data and use that new single cube as your report datasource? Cheers, Leigh "If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

... and there's the answer, thanks ca8msm! Cheers, Leigh "If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

I was going to suggest using TRIM(), but then i tested the scenario and got the same result. create table test (text varchar(255)) go insert test (text) values('SL8') insert test (text) values('SL8 ') insert test (text) values('SL8 ') insert test (text) values('SL8 ') insert test (text)...

Does the other user have a valid SQL login mapped to their Windows login? Cheers, Leigh "If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem