Report Builder - Convert datetime to Local Time

Posted by James Jones on Stack Overflow See other posts from Stack Overflow or by James Jones
Published on 2010-03-17T19:02:22Z Indexed on 2010/03/17 19:11 UTC
Read the original article Hit count: 488

Filed under:

reporting-services

|

reportbuilder

|

sql

|

sql-reporting-services

I'm using Report Builder 2.0 to construct a report that contains datetime data stored in the database as UTC time. Is there a way to convert the UTC time to local time of the computer viewing the report?

Thanks.

© Stack Overflow or respective owner

Related posts about reporting-services

Subtotal error on calculated field in a Reporting Services Matrix

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a Reporting Services report that has two row groups: Category and SubCategory. For columns it has LastYearDataA, ThisYearDataA, LastYearDataB, ThisYearDataB. I added two columns (one for A and one for B) to handle an expression calculation (to show a percentage different from LastYear to… >>> More
Reporting Services: Two Tables One Sum

as seen on Stack Overflow - Search for 'Stack Overflow'
My report is as follows: One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data) The second table is a variance report for data that has been shipped… >>> More
Sharepoint/WSS Reporting Services Integration woes

as seen on Stack Overflow - Search for 'Stack Overflow'
after a number of failed attempts i seem to have successfully installed the Reporting services add-in to my WSS farm. However, I seem to be missing most of the enhanced functionality eg no report library template, no report center site template. the only additional functionality available is the report… >>> More
SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

as seen on Server Fault - Search for 'Server Fault'
When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. Error Code 800706B3 This error appears before I can even attempt to connect to an SSRS instance. In… >>> More
SQL Server Reporting Services Data Extention

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello! So... here's my story: I'm trying to create a SQL server data extension (to be precise, I'm trying to get some sample code to run) (SSRS2005). I've done the following: Placed the extension assembly into the ReportServer/bin folder. Placed the assembly into the Private Assemblies folder… >>> More

Related posts about reportbuilder

ReportBuilder.application fails on my PC - but works on localhost

as seen on Stack Overflow - Search for 'Stack Overflow'
We're running SQL 2005 on Win2K3 server and are using SSRS. Here's the situation: I can run Report Builder from localhost My coworker can run Report Builder on his Vista computer Another coworker can run Report Builder on his XP SP3 computer (IE7) I can NOT run Report Builder on my XP SP3 computer… >>> More
How do I make Master/Detail subreports in ReportBuilder come out right?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a report in ReportBuilder that's supposed to report on two objects. I didn't create this report, and I can't ask the person who did about how it works. Before running the report, we have some code that goes through, finds all the properties on the objects, and loads them into a memory dataset… >>> More
How can I remove the blank line caused by an empty sub-report? (Digital Metaphors Report builder)

as seen on Stack Overflow - Search for 'Stack Overflow'
I created a report with a sub-report but not every line in the main report has something in the sub-report. So when it prints the empty sub-report prints a blank line. How do I get rid of the blank lines? >>> More
Report Builder - Convert datetime to Local Time

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Report Builder 2.0 to construct a report that contains datetime data stored in the database as UTC time. Is there a way to convert the UTC time to local time of the computer viewing the report? Thanks. >>> More
Numbered list in Report Builder export to word

as seen on Stack Overflow - Search for 'Stack Overflow'
I have created a SQL Server Reporting Services Report Builder 3 report that contains a list of several items from a SharePoint list. I would like the list on the report to be a numbered list, so that when exported to Word, if a user adds another item to the document, the numbering is updated automatically… >>> More