Viewing 15 posts - 4,276 through 4,290 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 3:16 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 3:04 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 7, 2017 at 9:06 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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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',...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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]
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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)....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2017 at 9:07 am
It's been quite some time since I've actually used VB, datagrids in virtualmode isn't something I've used so i wouldn't like to hazard a guess.
I did wonder, instead,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2017 at 8:54 am
Viewing 15 posts - 4,276 through 4,290 (of 5,109 total)