SQL Server 2005 Report -- Report Execution Error

• Mark-402811

  Old Hand

  Points: 372

  More actions

  February 28, 2007 at 9:30 am

  #171534

  I have an analysis server cube with a transactional table which, of many fields, stores a datetime field called DateAdded. If I go into Report Manager and create a new column report and drag DateAdded over, it shows all date added results in the recordset.

  If I right-click on the field value in Design Report view and change the expression to state:

  DATEONLY(DateAdded)              (I want to just get the dates from the recordset grouped together)

  I get a dialog box stating:

  Report Execution Error

  The report might not be valid or the server could not process the data.

  A grouping expression must be either a scalar field or an entity.

  ----------------------------

  Semantic query execution failed.

  ----------------------------

  Query execution failed for data set 'dataSet'.

  ----------------------------

  An error has occurred during report processing.

  Ideally I would like to have the dates listed and grouped and then counts from my measures in my fact table on the right. Any recommendations?

  Thanks.

• March 5, 2007 at 8:00 am

  This was removed by the editor as SPAM

• xanthos

  SSCrazy

  Points: 2510

  More actions

  March 6, 2007 at 8:49 am

  #693331

  To show only the date in a textbox, right click the textbox in the layout tab and click properties.

  On the format tab Type "d" in the format code textbox and click OK.

  You could also click the eclipse for more formatting options.