Importing MS Access into MS Reporting Services

  • I am trying to import Reports from MS ACCESS DB to Reporting Services.

    I followed online instructions, and imported the reports and can see them in layout

    but have had no luck in previewing my reports in Reporting services.

    The error: An Error has occurred during report processing. Query execution failed for 'DataSet1'.Undefined function 'IsMonthOK' in expression.

    Is there something I am doing wrong.

    Thanks in advanced.

  • Do you get the same results when the report is based on a table not a query?

  • I have not tried pulling the data from simply a Table. The information that I am grabbing is from multipal tables rather than just one. so I didnt think it would work.

    How would you suggest I go about this?

  • Actually this can not be done.

    yes You can import tables and report bodies but the actually queries never import quite the way you want them to.

    Best advise is the make a query that translates information from access to sql

    the codes are very similar best different.

Viewing 4 posts - 1 through 3 (of 3 total)

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