Viewing 15 posts - 31 through 45 (of 51 total)
Hi,
In your SSRS Deployment, try below url,
TagetDataSetFolder : http://server1/Data%20Conn%20Library
TagetDataSourceFolder : http://server1/Data%20Conn%20Library
🙂
July 13, 2012 at 4:06 am
Thanks derek for prompt reply.
It's good idea to create linked table, however i have few more reports like that to many linked tables.
The report is gone little bit bigger cause...
July 12, 2012 at 3:05 am
might be margins.. try to reduce it and try
June 26, 2012 at 7:48 am
Hi,
use below function,
to create this function click on Report menu Report Properties and Code tab,
add below code.
Public Function CalcRatio(ByVal Numerator As Object, ByVal Denominator As object, ByVal DivZeroDefault As...
June 6, 2012 at 3:00 am
including all margins total size is less than page size ...:(
April 30, 2012 at 2:00 am
including all margins total size is less than page size ...:(
April 30, 2012 at 2:00 am
Add SET FMTONLY OFF before SELECT statement in your proc and you Done...!:w00t:
April 27, 2012 at 9:50 am
You gonna Love it....!
Add SET FMTONLY OFF in your proc at top and done.
thanks
April 27, 2012 at 9:45 am
Hi Daniel Bowlin,
Thanks for your reply, there is plenty room on the page and i have reduce margins TOP & Bottom to 0.7cm .... stiil no joy!
Thanks
April 27, 2012 at 9:12 am
I Agree with Grant, Parameter Sniffing could be one the reason, worth it to try and easy to apply...:w00t:
April 24, 2012 at 2:04 am
I agree with Parameter Sniffing, could be one of the reason... worth it to try and easy to apply as well.:w00t:
April 24, 2012 at 2:02 am
Lynn,
Just different way to write a code, if both works then nothing to complain:-D
April 3, 2012 at 1:57 am
DECLARE @Day INT
SET @Day = datePart(dd,getDate())
DECLARE @i INT
SET @i = 0
CREATE TABLE #temp1
(para VARCHAR(50))
WHILE (@i<20)
BEGIN
IF @DAY < 21
BEGIN
INSERT INTO #temp1
SELECT CONVERT(VARCHAR(25),((dateAdd(mm,-(@i+0),getDate() ) - datePart(d,getDate()))+21),103)+
' - '+
CONVERT(VARCHAR(25),((dateAdd(mm,-(@i+1),getDate() ) - datePart(d,getDate()))+20),103)
END
ELSE
BEGIN
INSERT...
April 2, 2012 at 9:52 am
could explain your problem into more detail, plz?? if possible then with example??
19 drop-downs means, 19 previous months??? is that 19 different parameters??
April 2, 2012 at 8:51 am
Viewing 15 posts - 31 through 45 (of 51 total)