Post reply

Developing Reports with Report Designer - data sources

  • October 6, 2009 at 8:20 am

    #205302

    Hi,

    Using VS 2005 to develop reports. My experience has been primarily using a SQL database as the datasource; then grabbing fields from the tables for my reports.

    What happens when the datasource consists of cubes? do I need to know MDX in order to build reports to be deployed? for setting parameters, groups, expression? or will i do the same things I currently do when my datasource is a database?

  • October 16, 2009 at 4:45 am

    #1066801

    Ones the data source is setup the design interface for SSAS cube is good enough for most basic queries, adding parameters isn't difficult and once you start getting the hang of it you can switch to script rather than designer mode. However you will find you start to feel the need to understand and write your own MDX queries as they can speed up data extraction enourmously

  • October 16, 2009 at 9:49 am

    #1067013

    thanks for the feedback. Can you recommend any MDX training resouces? Books?

  • October 16, 2009 at 10:17 am

    #1067029

    I used WROX SQL Server Analysis services with MDX to start me off and then lots of googling different ideas, you can usualy find some thing close to what you want that you can then bend to your will

  • October 20, 2009 at 7:26 am

    #1068173

    I highly recommend the William Pearson articles on MDX, Analysis Services and Reporting Services on Database Journal. Here's the link for his MDX series

  • October 20, 2009 at 9:45 am

    #1068314

    thanks for your recommendation!

  • November 1, 2009 at 8:56 am

    #1073589

    Maybe you can refer to the url below:

    http://technet.microsoft.com/en-us/library/cc281300.aspx

    http://msdn.microsoft.com/en-us/library/ms157166.aspx

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply