Home » C# Programming

Report builder 2.0 - Some parameters or credentials have not been specified

I am using Report Builder 2.0 Version 10.0.2746.0 connecting to a model that is on 

Microsoft SQL Server 2008 (SP1) - 10.0.2734.0 (X64)   Sep 11 2009 14:30:58   Copyright (c) 1988-2008 Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) 

I connect to the model and design a simple report that returns 3 fields from the same table.  No parameters added to the report.  Just a basic SELECT field1, field2, field3 FROM table1 

When I run the report, I get "Some parameters or credentials have not been specified".  
I click the refresh button in the report builder ribbon and data returns.  
I click refresh again...."Some parameters or credentials have not been specified".  
Click again: "Some parameters or credentials have not been specified".  
Click again: data returns.
Click again: data returns.
Click again: "Some parameters or credentials have not been specified"

The report server is NOT in a cluster.

If Some parameters or credentials have not been specified, shouldn't I be getting the error all the time?



I have report with 3 parameters: 2 datetime (left and right border) and 1 interval (day, week, month...).

How to do when changed interval - automatically changed left border of data (right border "automatically" constant and equal Now() )?


We have installed Report Builder 3.0 with WSS and can edit a report in the ReportingServices list of reports using the dropdown menu on the report name.

We added the Report Builder Report via Library Settings > Content Types But we do not see the option on the New menu at the top of the ReportingServices page. To be sure it was working correctly we added other content types and we see those on the new menu when opened.

Are there any setting that need to be made in any config files anywhere to allow the report builder options to be available on the new menu on a document list?





Hi All,

I'm trying to understand the following.

I've installed Sharepoint 2010 on Windows Server 2008 R2 and SQL 2008 R2 November CTP.

I also installed the Reporting Services add-in for Sharepoint.

What I can do is u;oad a working rdl from RB3.0 to a SP2010 library and I can view it, The report works fine.

But I cannot edit that uploaded report in RB3.0. When I try to edit the report, the RB 3.0 gets started but not with that report.

What I obviously can do i download the rdl locally and edit it there and then upload it again, bit that is not what I want.

Can anyone tell me in what direction I''ve to look for a solution?

Thanks in advance.









In Report Builder 1.0, we dont need to create different dataset for the parameter population. In report builder 2.0, I see that the parameter does not get populated automatically. Is there any way of getting the parameter getting populated automatically is RB 2.0 when report model is used as datasource ?

hi, i'm making this report from a sharepoint list. i want to add some of the fields as the parameters for the report. (e.g : Category, Department)

i tried to run the report, the parameters were shown as expected

but the problem is when i create a query in the dataset.

i'm using caml query builder for the query expression. it goes like this :

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>IT Helpdesk</ListName>
    <FieldRef Name="Employee_x0020_Number" />
    <FieldRef Name="Title" />
    <FieldRef Name="Department" />
    <FieldRef Name="Category" />
    <FieldRef Name="Time_x0020_Spent" />
    <FieldRef Name="INT_x0020_Time_x0020_Spent" />
    <FieldRef Name="Severity_x0020_Level" />
    <FieldRef Name="Ticket_x0020_Source" />
          <FieldRef Name="Department" />
          <Value Type="Text">'Department'</Value>
          <FieldRef Name="Category" />
          <Value Type="Text">'!Parameter.Category.Values'</Value>

the bold parts is where i got confused. i want to fill the value type from the parameter which i created.

so the value type populates the options from the parameter.

how can i do that? i tried to type @(parametername) but it won't work.

when i run the report, the parameter boxes have no options at all..

i tried to fill the value type with one of the category i have (i typed directly "Hardware") it worked, the report is shown correctly. i supposed that my intention is do-able, to populate the value type from the parameter which i created.

note : i create parameter from the parameter section, not in the dataset section. i use no parameter in the dataset.

anybody can help me?


thx in advance.



I have a report that is using Parameters. I found that when I have the same Available Value, then the report automatically changes the selection to the last Available Value in the list that matches the selected Value.


Parameter - @Selection

Available Values:

Label     Value

1            A

2            B

3            A

4            C

5            A

6            B


In this case, if I select 1, then the report automatically changes my selection to 5. If I select 2, the report automatically changes my selection to 6.


Does anyone have any ideas of how to keep the original selection?


Note: I assume people will next say, why have multiple Labels with the same value. The report I built is more complex than the example, but in any case the user needs to only select the Option for their area while they are not aware of what the Value is equal that filters the report.


I have a SSAS 2008 R2 cube.  I have created a shared datasource in SSRS 2008 R2 that links to the cube.

Users need to be able to use Report Builder 3.0 to build reports based on the cube.  The reports will have multiple cascading/linked parameters.

Using BIDS, I can connect to the cube and create reports.  It also creates additional datasets within the report to handle the datasources for the parameters.

ReportBuilder 3.0 creates the report with the parameters, but the datasets for the parameters are not created, resulting in the parameters not being usable.  I cannot expect end users to go back and create the additional datasets, and link them correctly.

Am I doing something wrong, or is this a limitation of ReportBuilder ?



Is it possible to create optional parameters in Report Builder?

An *ordinary* parameter is created by marking a filter expression as "prompted". At run-time, the user will be asked to provide a value for this parameter (or accept a default value if it is available). This works fine. What I want is to let the user choose whether to provide a value, or leave the parameter empty. In latter case, the reports should not take the parameter into account and display all available data.

Example: I have a list of products grouped by the name of the supplier. I want users to be able to see the entire list, or narrow it down to one supplier only. So I create a free text parameter that will contain a part of the supplier's name. It works ok, but if parameter is left blank, or set to NULL, the report will display no data (all products always have their suppliers).

I tried to create a filter formula to check for empty value and bypass the filter if necessary, but the formula only allows me to use the parameter expression once. So I cannot check for empty value and apply the filter in the same expression.

As a last resort, I used the following workaround: created a new formula named "Enter 'ALL' to see all suppliers" that would return text constant "ALL". I then added another prompted filter expression for this field and grouped it with my supplier prompt using "Any of" group. User is now able to choose a supplier, or enter "ALL" to the second prompt field. This clumsy approach actually works, but then another problem emerges  - although I mark both filter fields as Prompted, the Report Builder will forget this flag for one of the fields when the report is reopened. I think it could be a bug (we use SQL2005 SP1)

Anyway, it'd be nice if I could create an optional parameter as one expression, not two. Is there any way to do that?



I have a report driven by a parameter stored proceedure that filters the output by task. In Visual Studio 2005, this automatically generates the Parameter Bar in "Preview". I recreated the report in Visual Studio 2008. I added the Report Parameter, but when I debug to test/preview the report it indicates on Form1 that the paramerter is missing & Form 1 does not have the Parameter Bar. What am I doing wrong??

Has anything been done in RB 3.0 to allow integration of custom query builders? The interfaces for custom query builders have been supported in Visual Studio for a long time now but Report Builders 1.0 and 2.0 did not expose the interfaces.

I did post a feature request on connect for this back in 2008 but have seen no indication that interface extension has been worked on in RB3. 



Our users complain that certain reports take a long time to run. Those reports are actually retrieving information from the combination of CRM database and our accounting database, which are located on different servers, and I think that makes the reporting slow.

So I'm trying to create either a report snapshot or cache the report for a short period of time (from Report Server).

However when creating a report snapshot in CRM, when clicking on the newly created snapshot, I keep getting an error "The selected report is not ready for viewing. The report is still being created or a report snapshot is not available." even after I waited for 24 hours. When I click on Try Again I got another error "The report cannot be displayed".

I ran the diagtool and I received this error message:

">Crm Exception: Message: The path of the item '/CompanyName_MSCRM/4.0/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath), ErrorCode: -2147220332, InnerException: Microsoft.Reporting.WebForms.ReportServerException: The path of the item '/CompanyName_MSCRM/4.0/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)"


Because of this I'm trying to go the other way by caching a temporary copy of the report from the Report Server. However I keep getting an error message "Credentials used to run this report are not stored", even though I already selected the option "Credentials stored securely in the report server" and "Use as Windows credentials when connecting to the data source" from the Data Source option. I read somewhere that there might be an impersonation problem? However creating report subscription is not a problem at all here.

Can someone please clarify me on this issue? Thanks in advanced for your help,


-Elizabeth K.



I have created SSRS reports using SQL Server Business Intelligence Development Studio 2008 and deployed on a sharepoint website.

When i am trying open these reports (rdl file) in report builder following error message is shown.

"This report cannot be opened in report builder".


Please help.


Thanks in Advance.






I have created a Data Model for report builder 2.0.


From one dataset I have selected few columns to show in the report. Say Dataset1.

Now, I need to create a parameter from those report columns.

When I create parameters in the Report builder Pane and select the Dataset1, and execute the report, the report doesn’t refreshes with the parameters that I select. Also, the value in the parameters are repeating.


Now I created another dataset say DatasetParameter and in the parameter value section I am providing the newly created DatasetParameter. Doing this, the repeating of parameter values are gone.


When I select any value from the parameter and then execute the report, the report doesn’t take that parameter. It always shows me all the values.


Can anyone tell me how to resolve this?


The report builder will be used by business users who doesn’t have understanding of sql queries.


Please reply



I do not think this is possible but will ask anyways.  We have setup SSRS and the Report Manager site.  Users are starting to access the site and we are now introducing them to the Report Builder functionality and running of ad-hoc reports.  My question is; is there a way to add a discalimer or something of that nature to each Report (reports ran from Report Builder) so that we can diferentiate between reports built by and ran by our Reporting Dept (in BIDS) versus Ad-Hoc reports ran by the normal end users using the Report Builder tool.  We are worried about some users not understanding how to use the Filter function to limit reports properly.  This would just be a way to cover our behinds in regards to our contractual obligations.  Thanks for your thoughts everyone!!

hi ,where i can find reports (.rdl) of report builder 2.0  


I installed ReportBuilder 2.0 because I am using Windows 7 64 bit and Sql Server 2008 developer edition

I set the "Use this report server or sharepoint list by default" to http://<machine name>/reportserver

I then click save as on the report to save to the ssrs server. and I get an error that it cannot find the location.

I have tried pasting the report server url from the ssrs config manager and I still can't save the report.

I am logged in as Administrator


But I can use the same url and it works

http://<machine name>/Reports_<sql server instance name>/Pages/Folder.aspx


ideas? I'm lalmost done with the setup...so close


Hi everyone,

A quick question surrounding join limitations in Report Models.

I have a situation where an entity has relationships with two other entities, and I want to include fields from all 3 entities in the one report.

For example, Customer has a many relationship with Orders, and also has a many relationship with Addresses

I want to add fields from all 3 tables to the same report.

I can add fields from Customers and Orders
I can add fields from Customers and Addresses

But, I cannot add fields from Customers, Orders and Addresses on the same report. It will however, let me add the count (#) field from the 3rd table, but not any of the detail columns.

All 3 are tables with normal PK - FK relationships.

Is this a limitation of report models, or do I need to tinker with the roles in the SMDL some how?


I have installed SQL Server 2008 Enterprise with Reporting Services. I can configure reporting services and view the report manager web page with no problem. I can do anything I need in the rrpeort manager. I can create reports using the Report Builder 1.0 using data sources and models created in the report manager web site.

I cannot get Report Builder 2.0 to connect to the Report Manager. I have set the default URL to the address I use to access the report manager, but this gives the following error when I try to create a data source.

Connection Failed.

Unable to connect to the server that is specified in the URL, 'http://<server name>/reports/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I am able to create an embedded data source using the same server the reporting services are installed on.

John Pearson
Systems Analyst/Programmer
Unified Trust Company, N.A.


I have a concern, I have been able to build a report using Report Builder 3.0.

It is on the server.(SQL 2008 R2 64 Bit Enterprise Edition).

I can see the report in the Builder but not on the server.

I am local admin and SA on the server.

What am I missing?

Also I will be using Report Builder to demo and give a tech talk on SSRS. an early response will help.

Thanks in advance

Paresh Motiwala


I have a concern, I have been able to build a report using Report Builder 3.0.

It is on the server.(SQL 2008 R2 64 Bit Enterprise Edition).

I can see the report in the Builder but not on the server.

I am local admin and SA on the server.

What am I missing?

Also I will be using Report Builder to demo and give a tech talk on SSRS. an early response will help.

Thanks in advance

Paresh Motiwala


<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure