.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to show varbinary data on the report builder normally?

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

Hi everyone,

The varbinary column type data will show #error on the report builder, is there a way to show it correctly? convert or other?


Where there is great love, there are always miracles.

View Complete Post

More Related Resource Links

Report Builder Report manage data sources - relink programmatically

As part of a site definition solution several report builder report rdl files are uploaded to a report folder.  After a site is created with the defintion, the reports must be manually re-linked to the data source through the UI context menu ("Manage Data Sources").  I have been trying to figure out how to do the re-linking programmatically without luck.  Any ideas? ( Reporting Services is configured as integrated with sharepoint)

Report Builder 2.0: duplicate rows do not show on reports

Hello,Created a report using a report model.the problem is that duplicate rows do not show on the report.Why?And also how can this be fixed?the report shows product ids, that may or may not have serial numbersticket numbers can have mulitple products associated with them and they may or may not have serial numbersthe report data row is as follows:example:order number, ticket number, product id, manufacturer id, serial number123                  456               dsl_router 12  cisco123                  456               dsl_router 12  ciscothe above data shows as one row on the report, thus, showing it to be one product, but really there are 2 products and there should be 2 rows.is this a bug?how can this be fixed?Thanks.

SSRS 2000 report not able to show any data in ie6 and ie7 although found working in ie8 and firefox


we have a SSRS report which was working till few weeks backs on all the ie and started to show Diagnose the Internet connection error on ie6 and permission denied on ie7. although the report is running fine on ie8 and firefox with same security settings. There has been no recent changes done to the report. tried it through fiddler but gives a 200 status for http. IS also connecting to URL and is making connect to the DB. HAve tried to check the script and activex settings also and found nothing absurd which can stop the functionality.I have tried reducing the security to low also but with success. Can someone please help.

Report Builder:The type of the data source has not been specified.



I am getting the folloing error when I try to run the reeeport through report builder

The type of the data source has not been specified.

An error has occurred during report processing.

Please tell me what can i do to avoid this

show part of the Cube data in SSRS report prompts



I have generated one report in SSRS 2008 report designer, and one prompt was added in it. when I am running this report, selecting the data from prompts, it shows all the Cube data for this field.

But I want only a small part from cube data, how can I make this? Thanks!


Connie Zhu

Can Report Builder mimic something like MS Word's "Column" formatting with a lot of table data?



I want to make a report that shows the sign-in of a list of people. There will be anywhere from 40-200 people signing in per day. I need to print this data. The columns in the row are small: [firstname, lastname, id number].

What I would like to do is have 2-3 mega-columns, which each "mega"-column contains [firstname, lastname, id number]. I'm using the phrase mega-column to distinguish from a normal column in the context of a table.

Is that possible with report builder? My production platform is IIS7.5 with ASP.NET 4 and MVC3. I am planning on generating PDFs for the user to print. However, right now it looks simpler to just format html with stylesheets and have that print.

Any help would be appreciated.



data connections in data connection libraries as consumed by Report Builder and SSRS


A data connection to a SQL DB is created and published to a data connection library in SharePoint 2010.  When Report builder or SSRS consume this connection, does the actual network connection happen between the SP server and the DB or the client machine and the DB?  And is this different based on whether you use SSRS or Report Builder?  

The reason for the question is that the firewall is open between the SP farm and the DB but NOT between the client machine and the DB and I'm trying to figure out if this will be a problem or not.

Additional clarifications that may be helpful.  SSRS (SQL 2008 R2) is in SharePoint integrated mode and we are specifically talking about rsds files.

report builder 3.0, how to show a int type field(like id) in matrix format report


it always asking for the aggregate or sum, count ... I just want to show plain value like

1 myval1 myval2 myval3

2 myval2 myval2 myval2

not lile

(blank) myval1 myval2 myval3

(blank) myval2 myval2 myval2

2       (blank) (blank) (blank)

Refresh of a Report Builder Dataset does NOT show newly added field

I'm working with Report Builder 2.0 (we don't plan on getting SQL 2008 R2 - so NO 3.0 for us!) and have found that if I have an existing report using an existing stored procedure (it has 4 existing parameters) and I add a new field to the stored procedure it will not refresh the data set.  I have gone to the DataSet properties and executed the query(SPROC) where it does show the new field (so I know the sproc will execute), but when I click OK and hit Refresh Fields it stops responding.  I also tried the same steps without the Refresh Fields and still stops responding.  I also tried to add the field name and it errored out as invalid.

The only work around I've found is to

Stored Data Source Credentials in Report Builder 3.0



I have setup a SQL Reporting Services 2008 R2 server which contains data sources that connect to databases on a remote SQL 2008 server.  In the data source the connection string is defined and "Connect using:" is set to "Credentials Stored Securely in the Report Server", I have entered the credentials required to connect to the remote SQL 2008 server where the database resides and there is no problem when I choose "Test Connection". 

When I access the Report Builder through the SSRS website and create a new report I can add the data source to the report without an issue.  When I try to create a new dataset and specify to "Use a dataset embedded in my report" I can choose the data source but when I try to then open the Query Designer I am prompted to enter the credentials for the data source.  The username I saved in the data source on the Reporting Server seems to default in however the password does not.

I see on MSDN (http://msdn.microsoft.com/en-us/library/ms159736.aspx) the following:

"You can specify a single set of stored credentials that a report server uses to access external data for a report. Stored credentials are used if the report runs unattended. The report server retrieves and uses the credent

GridView control to show master-child or master-slave data, written in c#, asp.net

I previously made a master slave datagrid using Visual Studio 2003 .Net (original article) that would allow users to show data to clients using collapse and expand features. These features however did not carry over to gridview for many users. This tutorial will explaing how to create a collapsable/expandable gridview in frameworks 2.0 and higher

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

show data in grid view error Arithmetic operation resulted in an overflow.



i have a table there is 17 columns in 17 column 3 are number and other are varchar . when i try to display all data of that column error occures.

one more intersting think is when i try to display 6 column then grid show there data an no more error occures. 

when i run my project this error occures in grid view

Arithmetic operation resulted in an overflow. 

Display multivalue data in crystal report


i Want to show data for single employee like this like this

Emp Id : xyz

Emp Name : abc


Child name      Date of birth     education

abc                     12/12/2000    o levels

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

The report cannot be opened because the data source associated with it is not a report model.


i tried to open a report i created in sql business intelligence development studio in the report builder in wss3 and it gave me this error:

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report 'http://servername:port#/Reports/report.rdl' cannot be opened because the data source 'http://servername:port#/DataSource Library/datasource.rsds' associated with it is not a report model.

This report was not created in Report Builder. Try opening this report in Report Designer instead.

can i fix this so i can open my reports in report builder?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend