reporting-services Questions
8
I have an SSRS (SQL Server 2008 R2) report with several parameters. I'm having an issue where one of the parameters is not consistently choosing its default value when the report is first loaded.
...
Inflexion asked 23/9, 2011 at 4:35
3
Solved
I have tablix named tablix2 and have 3 columns ,I want to calculate rows sum and count in 2 textboxes out of the tablix scope, I try this expression.
=RowNumber("Tablix2")
And
=CountRows("Tabli...
Slouch asked 27/11, 2013 at 7:50
7
Solved
I have a report (BIDS SSRS 2008 R2) that has a parameter that allows the user to select multiple values from a list (Sales Regions, lets say).
I want, though, since the list is long (15 or so pos...
Wrest asked 30/9, 2013 at 20:12
2
I have a report that displays the total hours a person worked for each project they are assigned to, aggregated on month. I would like to sum the total hours for each person, for each month, in SSR...
Disincline asked 12/6, 2014 at 21:9
3
Solved
I've been wrestling with this one report for a long time, and finally figured out what to do but it was serendipitous .
Well I changed a parameter that depends on a previous one to be "Interna...
Brehm asked 6/1, 2013 at 4:14
8
In the layout screen of an SSRS designer e.g. Visual Studio, I have lost the report data panel.
It has disappeared and I can't remember what it is called in order to get it back.
This usually l...
Armin asked 24/3, 2009 at 17:5
3
Solved
If you have multiple report subscriptions that are set to be triggered at the same time will all of them start at that time and run concurrently? That is, if you have too many reports scheduled for...
Coddle asked 24/2, 2014 at 4:29
6
Solved
I often check the following option in the hope that it will be implemented when the report is rendered on the RS web portal - but it never works...
The reports usually have some Row Groups - doe...
Alongshore asked 27/2, 2013 at 20:42
4
Solved
any advice appreciated
I have as a column heading the expression =WeekdayName(weekday(fields!date.value))
This returns the day of the week, however, it is returning a day of the week one day in a...
Ancestress asked 4/12, 2014 at 8:17
2
Solved
(using C#, Web API, SQL Server2012 w/report server, authentication is NTLM)
I am getting an intermittent error when attempting to download a report (as an excel document) from SSRS. I build out th...
Cacodemon asked 16/11, 2015 at 18:9
2
Solved
Finally saw that there is "Microsoft Reporting Services Projects 2022" available for VS2022, which should by idea work as a report designer and open the existing reports. But it turns out...
Caesium asked 18/3, 2022 at 10:40
6
Solved
I have a solution file that was developed with VS2015, and it has about 20 project files. When we opened the file with VS2017 a prompt appeared: "The version of the report server project is not sup...
Reichel asked 7/8, 2018 at 16:3
10
Solved
I want to show up Todays date as report generated date on SSRS report.
How can i do that ?
should I use any variable ?
please help me I'm newbie to SSRS.
For example refer this image:
Zook asked 11/4, 2013 at 4:43
3
Solved
I need a row value in my SSRS report that is a calculated one based on a couple of fields that are already being used in the report. I want it to display in the textbox named 'textboxPercentageValu...
Guyguyana asked 12/1, 2016 at 17:5
7
I have been wanting to deploy my SSRS reports to a Test server. However I found that on that server the SSRS service had stopped, and I had to change the setting so that it used a built in Network ...
Shill asked 14/12, 2011 at 15:25
5
Solved
I have a report with a field whose value was the expression:
Fields!TotalPrice.Value/Fields!TotalSlots.Value
Although sometimes TotalSlots was blank and thus I was getting a divide by zero runti...
Raskin asked 3/5, 2012 at 13:45
4
I have datetime type from DB table.
In SSRS report, I'm getting datetime format mm/dd/yyyy. I want to change it to dd/mm/yyyy.
I have added expression like:
=FormatDateTime(Format(Fields!Transac...
Mercenary asked 20/6, 2014 at 9:15
3
Solved
I've written an SSRS report to help me keep track of SSRS subscriptions. I've repurposed a script that will use Reportserver.dbo.Subscriptions.LastStatus to view email recipients, however, it will ...
Iy asked 23/9, 2013 at 13:47
7
Solved
I have created a ReportProject with Visual Studio data tools 2015. When I create a report.rdl file using the report wizard, the rdl file has schema for 2016. My reporting server is of version 12.0....
Wreckful asked 28/3, 2016 at 22:48
3
Solved
I have a SSRS report one
Stock#_______Description_____Colum1_____Colum2_____Colum3
ABC__________XYZ_____________4334________4354_______454
detail part
Transaction#_______Date
1____________...
Lura asked 9/2, 2015 at 17:42
2
Solved
[VS2010/ASP.NET Web Forms]
Hi,
In a report (RDLC) I need to provide localization/globalization in two languages (pt-BR and en-US) to the following elements:
- Labels/Captions (fixed text)
- Repo...
Crossways asked 21/6, 2011 at 15:7
2
I'm trying to define interactive sorting in a tablix. The sorting should affect the row order.
Attaching image of the tablix in order to explain what I'm trying to get:
I already tried to defin...
Confessedly asked 31/12, 2012 at 9:14
12
Solved
I am doing computations on that data that will result in #Error at times. The underlying cause is a divide by zero. I could jump through the necessary work arounds to avoid the divide by zero, but ...
Ventriloquist asked 4/2, 2012 at 20:36
3
Solved
Greetings.
I have a SSRS 2005 report that shows prices of things. For some customers, I hide a column from the table (with an expression on the Visibility - hidden property).
When I do this, my t...
Cagliari asked 17/9, 2009 at 17:57
4
Solved
I have a tablix box that has a division expression. When dividing by zero or nulls I get #Error displayed in my report. I tried to create an IIF statement and tested with static values. This verifi...
Antidote asked 4/10, 2013 at 19:19
© 2022 - 2024 — McMap. All rights reserved.