SSRS Bigint Data Type Export Problem

Posted on 2009-12-17
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
    LVL 13

    Expert Comment


    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


    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

    But how about converting binary to bigint and bigint to varchar?

    Author Comment

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now