[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SSRS Bigint Data Type Export Problem

Posted on 2009-12-17
Medium Priority
Last Modified: 2012-06-27
Version  SQL Server 2005

I have a report that has a binary field which is the Unqiue Id column needed for a report.
In SSRS I used a convert and converted this unique Id column to Bigint.
On using the export option to excel or .csv this column is amended and the values are not coming out correctly and giving duplicates. However in the report displays correctly.
Just seems the export and probably excel restirctions changes the values.

Any suggestions on how I get use this column in SSRS and successfully export to Excel.

Basically I just need the column to be a unique Id that can be used to identify each row through SSRS.
My column can't be converted to Int as it's too large.....
I just need something I can use through SSRS that will deploy and export successfully as a Unique Id into Excel.

Any suggestions ?

Question by:EHardie
  • 2
  • 2
LVL 13

Expert Comment

ID: 26071700

Please do not copy it as it is to Excel. You can change the format of the column to varchar(40) before you export. E.g. If my table has b as bigint, while doing export I would go to DTSWIZARD, use Query instead of table, type SELECT CONVERT(VARCHAR(40),B) FROM MASTER.DBO.BIGINT;, then execute export. This definitely works.


Author Comment

ID: 26071945

Sorry but the actual source column is Binary.....
So basically I tried converting to Bigint because SSRS wont deploy the report with a Binary column.
So I tried converting the Binary to bigint and although it displays the report correctly I can't export it.
I can't convert Binary to Varchar.....
LVL 13

Accepted Solution

sameer2010 earned 1500 total points
ID: 26072854
But how about converting binary to bigint and bigint to varchar?

Author Comment

ID: 26072887
Yeah after your response I tried that. Was just trying to avoid using temp tables but just tested and worked ok. Thanks for your help.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Integration Management Part 2
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question