Reporting Services 2005 semantic query error

I recently changed my datasource in our Reporting Service Model. We changed to a quicker SQL server with disk capacity. I am able to run new reports but when I try to run old ones that were on the old datasource, I get an error. The datasource has been changed to point to the new server (datasource).

The error is: An error has occurred during report processing. (rsProcessingAborted)
Semantic query compilation failed: e EmptySemanticQuery The SemanticQuery does not contain any Groupings or MeasureGroups. SemanticQuery must contain at least one of these elements. (SemanticQuery ''). (rsSemanticQueryEngineError)

I will appreciate any help.

Nick

Is your data source an SSAS 2005 cube? Or did you misconfigure the model data source? Use the Report Manager to verify/reset the model data source.

|||My datasource is one of our SQL server databases. I know that the datasource is not misconfigured in the model because I am able to run new reports.sql

Reporting Services 2005 Repot Model - Bugs

Having been shown some of the bugs we have came across in using the Rport model for Reporting Services 2005 - can someone from Microsoft please respond to this or the following post:-

http://forums.asp.net/1190731/ShowPost.aspx

We have notice several bugs which are what I would say range from the rediculous to the point that Model is a horrible let doen and looks almost unfinished.

Anyone from MS care to reply so we can go over these?

Thanks
Gregor

Have you actually called Microsoft and told them about this issue? I would not expect them to take too much action based upon a forum posting -- assuming they even see it.

Reporting Services 2005 Metadata

Greetings,

I'm creating a new data model using Reporting Services 2005. The database has the standard generic names like 'idSystem' etc. I have created a Metadata file with user friendly names 'Control System Id', but rather than have to retype all those names and descriptions over into the [Friendly Name Property] I'd like to try to pull that information into the model.

So my question is...

Does anyone know where are the Friendly Names property is stored and can I program that field to pull from another file?

Thanks

- Will

Right click on the model in VS and select View Code. If it is set, the Friendly Name for each Entity element is an element called Name. Because you can nest Entity elements in folders, there is no set XPath you can use other than //Entity.

R

|||

Great Thanks Ron.... I'm having server issues now.. but I will try this.

Thanks again

-Will

sql

Reporting Services 2000 and Sharepoint - Help Please

I am so lost....
Ok, I need to install reporting services so we can use build reports
with sharepoint. Our server model looks like.
Server 1 - Sharepoint
Server 2 - Sharepoint Database
Where do I need to install reporting services.. on server 1 or server
2?. Then, I am going to install Reporting Services Service Pack 2,
whch has web parts for sharepoint, so I am assuming that I need to
install RS on Server 1.
The documentation from MS is..well.. not so easy to follow. Anyone
done this before?
Thanks,
-SJHi,
you didn't say which version of sharepoint you use..
I have setyp and used RS 2000/2005 with all version of sharepoint and it's
almost the same configuration.
Have you checked out this link?
Configuring Reporting Services for SharePoint 3.0 Integration
http://technet.microsoft.com/en-us/library/bb326356(SQL.90).aspx
You will find the answers there i think.
Please let me know!
/Daniel Bugday
"SJ" <sjourdan@.gmail.com> wrote in message
news:1181235193.094940.183890@.h2g2000hsg.googlegroups.com...
>I am so lost....
> Ok, I need to install reporting services so we can use build reports
> with sharepoint. Our server model looks like.
> Server 1 - Sharepoint
> Server 2 - Sharepoint Database
> Where do I need to install reporting services.. on server 1 or server
> 2?. Then, I am going to install Reporting Services Service Pack 2,
> whch has web parts for sharepoint, so I am assuming that I need to
> install RS on Server 1.
> The documentation from MS is..well.. not so easy to follow. Anyone
> done this before?
> Thanks,
> -SJ
>|||On Jun 7, 12:09 pm, "Daniel Bugday" <itkons...@.gmail.com> wrote:
> Hi,
> you didn't say which version of sharepoint you use..
> I have setyp and used RS 2000/2005 with all version of sharepoint and it's
> almost the same configuration.
> Have you checked out this link?
> Configuring Reporting Services for SharePoint 3.0 Integrationhttp://technet.microsoft.com/en-us/library/bb326356(SQL.90).aspx
> You will find the answers there i think.
> Please let me know!
> /Daniel Bugday
> "SJ" <sjour...@.gmail.com> wrote in message
> news:1181235193.094940.183890@.h2g2000hsg.googlegroups.com...
>
> >I am so lost....
> > Ok, I need to install reporting services so we can use build reports
> > with sharepoint. Our server model looks like.
> > Server 1 - Sharepoint
> > Server 2 - Sharepoint Database
> > Where do I need to install reporting services.. on server 1 or server
> > 2?. Then, I am going to install Reporting Services Service Pack 2,
> > whch has web parts for sharepoint, so I am assuming that I need to
> > install RS on Server 1.
> > The documentation from MS is..well.. not so easy to follow. Anyone
> > done this before?
> > Thanks,
> > -SJ- Hide quoted text -
> - Show quoted text -
Thank you very much for your reply!

Reporting Servcies Sessions

Hey

I have a problem in controlling the report session.

I created a Reporting Model using SQL reporting Services 2005 with Forms authentication on which I implemented the security Filter based on the function GetUserID() to report only against data that belong to the login User, and I deployed the Model.

Using report Builder application I created a report that contain in the first column the user name (UserName) from entity “Users”, and in the remaining columns data from other entities related to table users, I saved the report on the report server.

I logged in into report manager with user “User1” and I ran the report, the result was the same as expected (in the first column “User1” appeared and in the remaining column other data related to this user appeared) every thing went good

After that I logged in with the user “User2” and I ran the report and here was the surprise the same data that appeared for "User1" appeared for "User2". but what was Expected is different data that belong to "User 2"

After some research that says that this problem may be caused by a session issue (the session created for the first user who enters the report server will remain for the other users that enter after him), I reset IIS and I logged in with “User2”, and I ran the report the correct data for “User2” appeared So it may be a session issue.

My question is:

Is there any way to control the session content and the session expiration?

Please note I used all the solution provided in my research such as URL parameter rs:ClearSession = true, and the Report Execution Options in report manager but non of this helped me.

I will be thankful for any one who could help me in this urgent issue.

Thank you

BOB

Hi Bob,

I have the same issue here. Did you manage to get a solution for your problem?

Julian Kooiker

Reporting Servcies Sessions

Hey

I have a problem in controlling the report session.

I created a Reporting Model using SQL reporting Services 2005 with Forms authentication on which I implemented the security Filter based on the function GetUserID() to report only against data that belong to the login User, and I deployed the Model.

Using report Builder application I created a report that contain in the first column the user name (UserName) from entity “Users”, and in the remaining columns data from other entities related to table users, I saved the report on the report server.

I logged in into report manager with user “User1” and I ran the report, the result was the same as expected (in the first column “User1” appeared and in the remaining column other data related to this user appeared) every thing went good

After that I logged in with the user “User2” and I ran the report and here was the surprise the same data that appeared for "User1" appeared for "User2". but what was Expected is different data that belong to "User 2"

After some research that says that this problem may be caused by a session issue (the session created for the first user who enters the report server will remain for the other users that enter after him), I reset IIS and I logged in with “User2”, and I ran the report the correct data for “User2” appeared So it may be a session issue.

My question is:

Is there any way to control the session content and the session expiration?

Please note I used all the solution provided in my research such as URL parameter rs:ClearSession = true, and the Report Execution Options in report manager but non of this helped me.

I will be thankful for any one who could help me in this urgent issue.

Thank you

BOB

Hi Bob,

I have the same issue here. Did you manage to get a solution for your problem?

Julian Kooiker