Viewing 15 posts - 4,276 through 4,290 (of 5,111 total)
You'd need to convert it again on the outside. Like below, but why not handle this in your presentation layer? For example, on Excel a format of 0.00 would only...
February 8, 2017 at 3:23 am
February 8, 2017 at 3:04 am
I feel like this question isn't as simple as I think it is, however, in your Variables Pane you have a column called Value. You can enter the value of...
February 7, 2017 at 7:54 am
Yes, you can pass multiple values for a parameter in SSRS. I've assume you have already configured your report to allow to submit multiple parameters, so I'm going to straight...
February 7, 2017 at 7:11 am
Something like this?CREATE TABLE #Sample (Contract INT,
Line VARCHAR(5),
Amount DECIMAL(12,2));
INSERT INTO #Sample
VALUES (1478, 'A1',...
February 7, 2017 at 5:24 am
Yes. If you wanted to run each service (let's say the Database Engine (DE), Reporting Services (RS), Analysis Services (AS)) on 3 different servers would would need to licence each...
February 7, 2017 at 2:13 am
I'm actually wondering if the Like button(s) are bloating people's points. I've noticed that since the new forums have come out I've probably earned about 700 points (700!). That's almost...
February 6, 2017 at 1:37 pm
I might be able to do something for you when I get to the office tomorrow with our own logs table again, like in the other post, but without DDL...
February 6, 2017 at 1:27 pm
nhapzz - Monday, February 6, 2017 10:31 AMwhat about cast(datecolumn as date) ?
OP has Posted in the SQL Server 2005 forum. The...
February 6, 2017 at 10:40 am
Use a CASE statemnt: SELECT
[AUTHN] AS [Auth Number]
,convert(date, [AuthDate], 1) AS [Effective Date]
,convert(date, [ExpirationDate] , 1) AS [Expiration Date]
February 6, 2017 at 10:00 am
I think you need to handle this in your SQL, NOT SSRS. What version of SSRS and SQL Server are you using? Can you provide a copy of your query?
February 6, 2017 at 9:51 am
Updated. It is worth noting that the values that SSRS is giving you is correct, 0.99995000 = 1 when rounding to 4 decimal places (2 decimal places in percentage format)....
February 6, 2017 at 9:22 am
Edit reread, will post back an answer.
Edit, try:=FLOOR(Fields!MyField.Value * 10000) / 10000
This preserves the field as a numeric, rather than turning it into a string.
February 6, 2017 at 9:07 am
Viewing 15 posts - 4,276 through 4,290 (of 5,111 total)