Report empty?

I have created a basic report that just shows some columns from a query, I'm using a dataadapter and the reportviewer component.

If I execute the query it calles it returns some rows, but the report is empty.

What's wrong with the reportviewer and the report objects?

I'm thinking about just using gridviews because the reports don't work, altough I'd like to use the reportviewer because it can export to excel/pdf.

Thanks.

HI,onishirox:

I can not debug it without any codes from your scenario, but you can have a check with this following walkround to make your codes work:

Binding Data to the ReportViewer Control Dynamically in ASP.NET 2.0 -

http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/1/

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be

of assistance

|||

HI,onishirox:
We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

|||

Thanks. I think the problem was that I was using sqlserver2000, seems to work ok now with sql2005.

Report Distribution based on SQL Query in RDL

I need to create multiple reports with each report being sent to the specified user. For example, 3 Managers should each get their own report. A Stored Procedure receives a ManagerID parameter, so I need 3 instances of the report. I also need each report to be sent to its associated Manager:

Mgr ID Manager Name 1 John Q Manager 2 Jane Q Manager 3 Jack O Lantern

I set up a rss file to run the report and can run it multiple times, passing in a different ID value each time, but it will not be data driven because I must hard-code the parameters in the ReportParmaters object of the report for each execution.

Is there a way, either by designing the report in VS2005 or on the Reporting Services server, to accomplish what I'm intending to do?

Did you already have a look on the datadriven subscription option in Reporting Services ? That would exactly fit your needs.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Report Designer: Refreshing Fields VERY Slow

I have a query that uses temp tables, and the query seems to execute and
refresh fields fine, but as soon as I put in a parameter for a DateTime field
the query will run but the Refresh Fields button takes forever...like 2
hours! I think it is running my rather lengthy query without the parameters
which because of the size of the tables takes a long time.
I have tried changing the data type for the parameter from String to
DateTime and neither seem to refresh the fields quickly.
Can anything be done to refresh the fields list quicker?I thought my MSDN Universal Subscription entitled me to a response within two
days... I guess not.
"Chance" wrote:
> I have a query that uses temp tables, and the query seems to execute and
> refresh fields fine, but as soon as I put in a parameter for a DateTime field
> the query will run but the Refresh Fields button takes forever...like 2
> hours! I think it is running my rather lengthy query without the parameters
> which because of the size of the tables takes a long time.
> I have tried changing the data type for the parameter from String to
> DateTime and neither seem to refresh the fields quickly.
> Can anything be done to refresh the fields list quicker?
>

Report designer - turning off the query generator

Is there a way to stop the report designer from 'fixing' my query?

I tried to modify the where clause with an OR statement and when I ran the report it totally messes it up.

Any ideas?

It sounds like you are using the visual query designer (4 display panes). You can just switch to the generic query designer (2 display panes). More information is available here: http://msdn2.microsoft.com/en-us/library/ms365414.aspx

-- Robert

sql

Report Design help for Newb - Regarding Date Paramaters

I have been trying very hard for days now to build a report using VS 2003.net
I just need to query an order table by a date range. ie) from date a to
date b. The order table contains PO's and have recorded dates. I just need
an example of how to report based upon date range. Seems simple enough,
just cant figure it out.I assume you mean you want the user to be able to specify the date range?
If you currently have a sql statement that returns all orders and have a
report that displays that data, simply modify the sql statement and specify:
where datefield between @.startdate and @.enddate
That will automatically create report parameters. When you preview the
report, it will prompt you to type in start and end dates.
For more info, just do searches for query parameters and report parameters.
Mike G.
"tdodd" <tdodd@.discussions.microsoft.com> wrote in message
news:6A7F2EE5-FAFA-4852-B771-35FBC9431D71@.microsoft.com...
>I have been trying very hard for days now to build a report using VS
>2003.net
> I just need to query an order table by a date range. ie) from date a to
> date b. The order table contains PO's and have recorded dates. I just
> need
> an example of how to report based upon date range. Seems simple enough,
> just cant figure it out.

Report Definition in Crystal

Hi, everyone -
I just had a quick query that I was hoping one of the experts out there could help me with:

I remember, when we used WinQL as our previous report generator, the software provided a "report definition" print option. This would allow me to print off a page with the fields, formulas, groupings, etc. for reports so that I could recreate my report in what we now have -- Crystal 8.5.

Now that we are changing our housing program software from a DOS-based system to a Windows-based software, the vendor is telling me that I'll have to AGAIN :eek: recreate my Crystal reports because the fields will all be different.

I'm wondering whether Crystal provides the same sort of "report definition" print option so I can print off the reports I need to recreate without having to guess at the formulas..... I've looked around Crystal and wasn't able to locate anything like this.

Thanks for the help.I'm not sure about 8.5 but in developer 10 under exports there is an option to print the report definitions.

GJ|||Hi, GJ -

UUUGGG... :blush: :blush: :blush: I guess I didn't scroll down far enough under Export. I did find it though.

Thanks for the help!!!sql

Report Credentials Problem

Hi Everyone,
This problem is tying me in knots and I'd be very grateful for some help.
I am to set up my reports to query a database for their datasources rather
than using shared datasources. I am now able to retrieve the connection
string perfectly well with this method. The trouble I have is that I still
need to supply credentials for the database separately.
http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx
In the above MSDN section under "no credentials" tells me that I can include
my credentials as part of the connection string, and select the "no
credentials" option. This is exactly what I am trying to do, but I get the
error:
a.. The current action cannot be completed because the user data source
credentials that are required to execute this report are not stored in the
report server database. (rsInvalidDataSourceCredentialSetting)
The connection string that I am using is in the format:
Server={my server};Database={my database};User ID={my user};Password={my
password};Trusted_Connection=False
Can anyone tell me why the report server appears to be ignoring the username
and password supplied in the connection string?
I am using SSRS 2005 connecting to a SQL Server 2000 database.
Many thanks,
Ed AllisonDid you configure the Unattended Execution Account?
See: http://msdn2.microsoft.com/en-us/library/ms181156(SQL.90).aspx
I believe this needs to be done before the No Credentials option can be
used.
Dave
Ed Allison wrote:
> Hi Everyone,
> This problem is tying me in knots and I'd be very grateful for some help.
> I am to set up my reports to query a database for their datasources rather
> than using shared datasources. I am now able to retrieve the connection
> string perfectly well with this method. The trouble I have is that I still
> need to supply credentials for the database separately.
> http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx
> In the above MSDN section under "no credentials" tells me that I can include
> my credentials as part of the connection string, and select the "no
> credentials" option. This is exactly what I am trying to do, but I get the
> error:
> a.. The current action cannot be completed because the user data source
> credentials that are required to execute this report are not stored in the
> report server database. (rsInvalidDataSourceCredentialSetting)
> The connection string that I am using is in the format:
> Server={my server};Database={my database};User ID={my user};Password={my
> password};Trusted_Connection=False
> Can anyone tell me why the report server appears to be ignoring the username
> and password supplied in the connection string?
> I am using SSRS 2005 connecting to a SQL Server 2000 database.
> Many thanks,
> Ed Allison|||Well,
The first thing that caught my eye is the fact that your using RS 2005
to access MS SQL 2000 DB. IT could be that article is for 2000=>2000
and 20005=>2005. THis could be a unique case where the DB's cant
access one another for credential information.
What you could do is set up the RS DB with the same credentials as in
the 2000 DB. Meaning copy the credentials instead of using them.
Although, I wouldn't recommend on doing so since you'll need to make a
credential change in two locations.
This is a good question though and would be glad to get an answer for
it myself.
regards,
Stas K.|||Thanks for your reply, Dave. I'll look into that.
"SleepyLab" <david.blancard@.fairmont.com> wrote in message
news:1143900841.325395.80120@.t31g2000cwb.googlegroups.com...
> Did you configure the Unattended Execution Account?
> See: http://msdn2.microsoft.com/en-us/library/ms181156(SQL.90).aspx
> I believe this needs to be done before the No Credentials option can be
> used.
> Dave
>
> Ed Allison wrote:
>> Hi Everyone,
>> This problem is tying me in knots and I'd be very grateful for some help.
>> I am to set up my reports to query a database for their datasources
>> rather
>> than using shared datasources. I am now able to retrieve the connection
>> string perfectly well with this method. The trouble I have is that I
>> still
>> need to supply credentials for the database separately.
>> http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx
>> In the above MSDN section under "no credentials" tells me that I can
>> include
>> my credentials as part of the connection string, and select the "no
>> credentials" option. This is exactly what I am trying to do, but I get
>> the
>> error:
>> a.. The current action cannot be completed because the user data source
>> credentials that are required to execute this report are not stored in
>> the
>> report server database. (rsInvalidDataSourceCredentialSetting)
>> The connection string that I am using is in the format:
>> Server={my server};Database={my database};User ID={my user};Password={my
>> password};Trusted_Connection=False
>> Can anyone tell me why the report server appears to be ignoring the
>> username
>> and password supplied in the connection string?
>> I am using SSRS 2005 connecting to a SQL Server 2000 database.
>> Many thanks,
>> Ed Allison
>sql

Report Column Headers from Database table

Please is it possible to get the reports column names from database table via stored proc or a select query.

Because reports needs to be localized between spanish and english users, so if a spanish user is logged into the system, it must bring all spanish column names from DB table and show in the headers, same with english users.

Thank you very much for the information.

I am using SQL 2K Reporting services.

Are the column names from a different dataset than the rest of the data in the report? If so, you have the following options:

1. Modify the query to return them in the same dataset (since you can't use two datasets in the same table).

2. Modify the report to include two tables, one only has the table header for the column names, the other (without header) displays the detail data, and align them appropriately.

3. Use subreport embedded in the table to display the detail data.

sql

Report Catalog Database

Hi All,

In a scale out deployment, which component sends the query to the database, the report catalog or the Report Manager?

Report Manager is just a report portal. Running a report in report manager will send a request to the RS scale out deployment. If you are using a load balancer, it will send the request to one of the server nodes in the scale out deployments. This server node (a RS web service) will then execute the report which includes running queries, retrieving data, processing data, and rendering the result and sending it back to the client (which is report manager in this case).

-- Robert

Report Builders

Hello,
Does anyone know a report builder for ASP.NET, other than crystal
reports. I need a report builder that can take only an SQL query and
generate the report without the need to have designed it earlier.
Thanks,On Mar 2, 3:27 am, "Tatool" <raffee.parsegh...@.gmail.com> wrote:
> Hello,
> Does anyone know a report builder for ASP.NET, other than crystal
> reports. I need a report builder that can take only an SQL query and
> generate the report without the need to have designed it earlier.
> Thanks,
MS SQL Server Reporting Services is one option. It allows you to build
the RDL directly from within ASP.NET, in a designer solution, etc.
Also, I have worked with Dundas (www.Dundas.com) in the past; however
you would need to design this one. There are several other options
available; however, a majority of them will require designing the
report. There's always the option to use just basic Gridviews, which
can be exported to Excel, Word, PowerPoint, etc and don't particulary
have to be designed. Hope this helps.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?

Report Builder Query Timeout?

Is their a way when creating a Report Builder model to set a query timeout? Similar to what can be done when creating a Reporting DataSet in VS.NET during report development.

My ultimate goal is to be able to limit ad-hoc report users running Report Builder from waisting resources on my SQL instance. This has nothing to do with a report being published to a report server and setting a reports execution time limit.

Unfortunately, no, you cannot set the timeout of a Report Builder query. You can specify a query timeout in Report Designer so you could build the report in Report Builder and then import it into Report Designer. But this doesn't get what you want, which is a limit on end user queries.

This feature is under consideration for the next release.

|||

I'm trying to build a Report Model for a Data Source View that has a table in it with a little over 1 billion records. When I try to create the new Report Model, the process fails while trying to get a row count on the 1billion+ table:

An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Command:
SELECT COUNT(*) FROM [dbo].[Sor1_PageHist]

This timeout is at 5 minutes. Where is the query timeout setting for building the model, or is this like the problem above that there isn't a location to set the query timeout?

Any information would be great!

|||

I am getting the same error message.

"An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

How can I resolve this timeout issue?

|||"You can specify a query timeout in Report Designer"

How?
|||

I am setting the Querytimeout parameter in rsReportServer.config file to 10 seconds and timeout parameter to 10 sec in Dataset for query tab in Report Designer for particular ".rdl" file and expecting to get the query timeout error in 10 seconds from Report server but it takes more time to timeout around 40-50 or more seconds. Can u please tell me where I am going wrong ?sql

Report Builder Query

Can we view the query that is fired on the Report builder to debug as i am finding some error in data...

Can you run SQL Profiler to get the SQL command that is sent to SQL Server?

Jarret

|||

http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx tells how to do it.

R

Report Builder Query

Hi Experts,

I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.

When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.

The problem is report builder allows me to select either Policy count in the report or the amount field.

Have anyone faced this problem.

The same report works in cube browser.

Regards'

Neeraj

Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.

B.

Report Builder Query

Hi Experts,

I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube.

When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work.

The problem is report builder allows me to select either Policy count in the report or the amount field.

Have anyone faced this problem.

The same report works in cube browser.

Regards'

Neeraj

Make sure your calculated and non-calculated measures are housed in the same measure group folder. To move the calcualted measure to a measure group's folder, go to the Calculations tab in the Cube Designer. There is a Properties button in the toolbar which will allow you to choose the calculated member and which measure group to associate it with. (Don't set the display folder.) Deploy your cube and rebuild your Report Model off the DSV.

B.

Report Builder error with Cubes

Hi,
I am receiving the following error when I run the report builder query. I am
able to successfully select the dimensions and measures that I am interested
in but when I run the report I get the error message.
The 'PerspectiveID' custom property for the 'query' perspective is either
not set or is not set to the string data type.
--
Semantic query execution failed.
--
Query execution failed for data set 'dataSet'.
--
An error has occurred during report processing.
I am testing this against both Adventureworks standard and enterprise cubes.
Additionally I saw this post in another forum
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
that seemed related but I am using reporting services in sharepoint
integrated mode so I am having a hard time trying to troubleshoot this.
Thanks for your help!On Dec 14, 2:14 am, Kodi <K...@.discussions.microsoft.com> wrote:
Hi
Whats your query ? Seems like you are using parameters which have not
been set.
Cheers
Shai
> Hi,
> I am receiving the following error when I run the report builder query. I am
> able to successfully select the dimensions and measures that I am interested
> in but when I run the report I get the error message.
> The 'PerspectiveID' custom property for the 'query' perspective is either
> not set or is not set to the string data type.
> --
> Semantic query execution failed.
> --
> Query execution failed for data set 'dataSet'.
> --
> An error has occurred during report processing.
> I am testing this against both Adventureworks standard and enterprise cubes.
> Additionally I saw this post in another forumhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
> that seemed related but I am using reporting services in sharepoint
> integrated mode so I am having a hard time trying to troubleshoot this.
> Thanks for your help!|||Hi,
I work with kodi and he posted this for me while my subscription was in
progress.
When using Cubes with report builder the report model is generated
automatically by clicking generate a model from the data source (RDS) working
in Sharepoint in my case, Then you load that report model which opens up the
report builder and it is drag and drop from there. There are no parameter in
report builder that I know of, it is all add-hoc and you would use filters to
act like parameters.
Larry
"shaikat.das@.gmail.com" wrote:
> On Dec 14, 2:14 am, Kodi <K...@.discussions.microsoft.com> wrote:
> Hi
> Whats your query ? Seems like you are using parameters which have not
> been set.
> Cheers
> Shai
> > Hi,
> >
> > I am receiving the following error when I run the report builder query. I am
> > able to successfully select the dimensions and measures that I am interested
> > in but when I run the report I get the error message.
> >
> > The 'PerspectiveID' custom property for the 'query' perspective is either
> > not set or is not set to the string data type.
> > --
> > Semantic query execution failed.
> > --
> > Query execution failed for data set 'dataSet'.
> > --
> > An error has occurred during report processing.
> >
> > I am testing this against both Adventureworks standard and enterprise cubes.
> > Additionally I saw this post in another forumhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
> > that seemed related but I am using reporting services in sharepoint
> > integrated mode so I am having a hard time trying to troubleshoot this.
> >
> > Thanks for your help!
>

Report Builder Bug ?

Hi,
I have a table A with column say col1, col2,col3. I have a query which has self join on this table.
But I can not add same table twice to model from the list of tables ! When I click the table in left pane to right....its no more in left pane ...to select it again !!

somebody please help !
any idea ? or is it another bug of report builder ?