Questions tagged [ssrs-2008-r2]

1 votes
0 replies
using VB.net how do I pass credentials to ssrs report server?
I'm trying to pass credentials to the ssrs server to load the report as PDF but am getting 401 unauthorized error. I have a vb.net web forms pro...
asked 4 months ago
0 votes
2 replies
color first five rows of a table in SSRS
Iam developing a report where I need to provide special effects on 1st few columns. How can I color code or provide 3D effect for first five rows...
0 votes
1 replies
Data in 2 Tablix to be summed in a 3rd
I'm trying to add two fields from two different tablix's in a 3rd tablix. The same dataset for all. I've tried using field referencing, custom...
asked 5 months ago
0 votes
1 replies
if we have 2 category group name, how to put Category Groups name on top and one on bottom?
enter image description hereI have in my example 2 category groups, one is the 'username' more granular and the other one is 'date of week'. I wo...
0 votes
1 replies
Summarized Production Report (Static Filters)
i have a report to be developed with specific static format: for each row i have to filter based on the requirements mentioned in the screen sh...
1 votes
1 replies
Word Print Preview not honoring my SSRS format settings
<InteractiveHeight>11in</InteractiveHeight> <InteractiveWidth>8.5in</InteractiveWidth> <LeftMargin>1in&...
0 votes
1 replies
SSRS Printer pop up not showing in Internet Explorer 11
I cannot get SSRS base report print pop up in Internet Explorer 11. But it successfully worked with ie 8.. Server os is 2012, SQL version is 2008...
2 votes
1 replies
SSRS parrameter display
Hi I am using State as parameter. I have 10 states in my data. And I am showing which state user selected in the report. And I am using Join(Para...
0 votes
0 replies
SSRS How Do I Display a Webpage In a SSRS Report
I have a SSRS Report that rotates thru 5 subreports. I was recently asked to enhance the rotating report to "automatically" show a webpage that a...
0 votes
1 replies
How put minutes value in axis Y in report builder 3.0?
I have a graph and I want to put the minutes on the Y axis, it only gives me data that I do not understand. Does anyone know how to represent the...
0 votes
0 replies
Font issue in SSRS Report
In Report Design Structure i have use Arial Font But When I Print Report Then Show Different Font. So How to Solve This Issue. Show in Print Lay...
asked 6 months ago
0 votes
2 replies
What is the correct syntax in Expression to count date column rows if both parameter values are in date?
I have 2 parameters in my query @selectedMonth and @selectedYear. I have 5 different date columns and I need to count all rows for each column w...
asked 7 months ago
0 votes
1 replies
SSRS 2008 r2 column group writing mode does not work on CRM
I have a report column group which I set WritingMode property to "Rotate 270" as I need the text presented vertically. It works like a charm when...
asked 7 months ago
-1 votes
1 replies
How to get rid of the whitespace when rendering a subreport in the main report?
I have report that I'm running that uses 3 subreports. When the subreports are shown in the main report there's a white space in the backgroundwh...
-1 votes
1 replies
SSRS Hidden Parameter Logic Approach For STRING values
DECLARE @rpmProvider varchar(MAX) = 'Prudhvi, raj,Lalith, Kumar'; CREATE TABLE #PrvFilt(ID varchar(50)) DECLARE @xml xml BEGIN SET @xml = ca...
1 votes
1 replies
SSRS count duplicate IDs
I want to count the number of duplicates in SSRS. So for example if an ID appears more than twice count the number of ID's that do this. For exam...
asked 7 months ago
-2 votes
1 replies
In SSRS 2008, how are parameters passed down to the DatSet Query… or can they?
In SSRS 2008, how are parameters passed down to the DatSet Query... or can they? I have a simple question. I think this is pretty straight-forw...
1 votes
0 replies
calculate the sum of a column based on another column values(SSRS)
The data is as shown below(Source description and total shares) are the two columns Source 494,482,729,319.98998 Initial...
0 votes
0 replies
RSTempFiles - Linking Them To A Specific Report
Is there any way to identify which report/subscription caused an RSTempFile to be written? We have had a few sizeable ones recently, and short o...
-1 votes
1 replies
SSRS Report to show hide a message based on the browser the report is loading in
Does anyone know if I will be able to show/hide a message on ssrs report based on the browser the user is using to view the report. Basically I...
asked 7 months ago
0 votes
1 replies
SSRS - Limit users to upload certain file types?
Is it possible to limit the types of files that can be uploaded into SSRS 2008? So far I have only been able to completely restrict file upload...
asked 7 months ago
0 votes
1 replies
SSRS Returning incorrect WW
I have an SSRS report (2008R2 3.0) that uses parameter filters for workweek in the format YYYYWW. In 2018 there were 52 work weeks based on the I...
0 votes
1 replies
SSRS Report Query
Is it possible to insert a clickable + sign in an SSRS report column header? If "yes," then, on clicking that operator, I would like to display o...
asked 8 months ago
0 votes
1 replies
How to produce a Gregorian Calendar in SSRS like is shown in the image
How can I produce in SSRS this Gregorian calendar (to choose a start date or an end date for a filter like is shown in the picture)? Should I use...
1 votes
1 replies
SSRS Expression will not affect chart title visibility
I'm trying to use an expression in the visibility tab of the Chart title properties window to hide the chart title based on a Boolean parameter....
asked 8 months ago