Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SQLBI

  1. SQLBI

    Problem displaying dataset value in the report header

    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...
  2. SQLBI

    change startday in calendar for selecting dates

    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...
  3. SQLBI

    SUM() Function not aggregating accross time

    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...
  4. SQLBI

    SUM() Function not aggregating accross time

    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...
  5. SQLBI

    SSIS/SSRS integration/automation

    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...
  6. SQLBI

    Performance

    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
  7. SQLBI

    Scaling to fit to page when rendering to Excel

    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...
  8. SQLBI

    Performance

    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...
  9. SQLBI

    Replicate a database - Please Help!!!

    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...
  10. SQLBI

    Problem exporting data....

    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...
  11. SQLBI

    Newbie Questions

    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...
  12. SQLBI

    Newbie Questions

    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...
  13. SQLBI

    Is there a way to quickly draw a summary of a table

    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
  14. SQLBI

    Newbie Questions

    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...
  15. SQLBI

    Project images

    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...
See more

Part and Inventory Search

Back
Top