Post reply

Customized Report in ASP.Net

  • March 26, 2010 at 8:41 pm

    #231260

    Hi there

    I am designing a report (using report viewer control) with customized area for parameters using asp.net (because SSRS does not allow to customize parameter pane) against SSAS database. I created one such report against SQL Server 2008 Database Engine where I am able to find query designer and I can make queries. No issues against SQL Server DB Engine.

    But when I do same thing against SSAS database, I do not find a MDX Query Designer to drag n drop the measures and dimensions into the query area. Even, when I make a MDX Query manually, it barks at me saying incorrect syntax near ON COLUMNS etc., It treats the MDX query as a normal SQL query.

    I notice that asp.net project doesn't have a MDX Query designer or window area to make MDX Query. Is there any alternate way to do this.

    Please help in fixing this.

    Thanks in Advance

    Sunny

  • March 27, 2010 at 9:55 am

    #1140942

    Sy-1148362 (3/26/2010)

    Hi there

    I am designing a report (using report viewer control) with customized area for parameters using asp.net (because SSRS does not allow to customize parameter pane) against SSAS database. I created one such report against SQL Server 2008 Database Engine where I am able to find query designer and I can make queries. No issues against SQL Server DB Engine.

    But when I do same thing against SSAS database, I do not find a MDX Query Designer to drag n drop the measures and dimensions into the query area. Even, when I make a MDX Query manually, it barks at me saying incorrect syntax near ON COLUMNS etc., It treats the MDX query as a normal SQL query.

    I notice that asp.net project doesn't have a MDX Query designer or window area to make MDX Query. Is there any alternate way to do this.

    Please help in fixing this.

    Thanks in Advance

    Sunny

    You have left out some relevant information because I am assuming you are trying to run ReportViewer 2008 in local mode and I think local mode is actually ReportViewer 2005.

    So you may try using VS2010 version or get SSRS 2008 license because in remote mode you create the report in SSRS with SSAS as your datasource and load it in ReportViewer. It comes with more work but it will give you what you need.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

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