November 12, 2007 at 11:13 am
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.
November 16, 2007 at 8:16 am
Do you get the same results when the report is based on a table not a query?
November 16, 2007 at 12:36 pm
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?
December 3, 2007 at 4:22 pm
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