Did you create the report in Visual Studio? Or is this one of the standard AX reports that are deployed by the installation? If it is one you created, do you get such an error when using report builder on an SSRS report provided by AX installer?
I am not sure if I fully understand the problem, but it seems like AX is looking for a table with schema DBO and the table is not part of that schema. If you have the rights, look into SQL Server and observe the schema of each table to see if there is some discrepancy causing your problem. Is there a non-AX table that is part of the report? If so, then you might be wise to create all tables that are needed for the report from within AX. I hope these ideas hep you. On Tue, Nov 25, 2008 at 9:44 PM, ROHIT JOSHI <[EMAIL PROTECTED]> wrote: > Dear friends, > I was trying to install SSRS in Ax4.0, every thing worked fine.. > I can even generate report from SQL report builder(SQL server Business > devlopment Studio), but when i try to generate report from axapta using > report builder(Tools->Reporting tools-> report builder), visual studio > starts, i can do all the designing and all, but whn i run my report then > there is an error.. > " > the report might not be valid or server could not process the data.. > > and in details following info was there. > . > Semantic query execution failed. > Invalid object name DBO."Tablename"withuserids(eg dbo.custtablewithuserids). > .......................................................................................................................... > Query execution failed for data set"Dataset" > .......................................................................................................................... > an error has occured during report processing > > " > > Has sumone tried to deploy ssrs? > if yeah, thn please can u give me details of installation so that i can > verify that i hve done installation in the right way. > > can u ppl please help me wth ths and give a solution to my problem? > and how to rectify above said error.. > > Thank you in advance > > With regards > Rohit Joshi > ________________________________ > Extend your network, join the Microsoft Dynamics AX Knowledge Village at > LINKEDIN ! > ________________________________ > >
