reporting-services Questions
7
Solved
Is there a way of fully-justifying text in SQL Reporting Services?
I've been searching around and it seems the feature is still not supported by Reporting Services, but are there any workarounds?
...
Cantatrice asked 21/6, 2012 at 7:41
6
I want to deploy a report that I have created in SQL Server Business Intelligence Development Studio 2008 R2. I have set TargetServerURL to http://mohammad-pc/Reports. I can access this path throug...
Methuselah asked 1/7, 2012 at 5:45
6
I know this question has been asked before, but all questions were for reports being accessed using C# or VB.NET code. My problem is that I am building and accessing the report using Business Intel...
Erna asked 14/4, 2014 at 13:16
3
Solved
I have a report with one group (Office Name) which page breaks between each group - so the data for only one Office can appear on a given page. How do I get that Office Name to appear in the page h...
Unchartered asked 10/3, 2009 at 20:49
2
Solved
I have tabbed my report in SSRS 2012 by having my page breaks based upon grouping classname and it works great. How do I change the tab names when exporting to Excel? I tried having an expression f...
Hemicrania asked 14/7, 2014 at 20:37
5
I have been combing the internet for some clue as to how to display reports in angular 2. So far I haven't been able to find anything I could rely on.
I will appreciate it very much if any one can...
Chymotrypsin asked 10/3, 2017 at 22:3
4
Solved
I'm trying to create doughnut chart and insert label inside the chart's hole. When I render report, label is being moved outside the chart.
Is it possible to force report items to overlap instea...
Triton asked 24/10, 2014 at 9:41
6
Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns?
This crude diagram shows roughly what I'm looking for:
The basic idea is that each line item is a...
Looper asked 27/10, 2010 at 17:7
1
Solved
In my report I have 1 tablix with 1 row group and 1 column group.
When I deployed, my report showed me the following error :
Warning : The tablix 'Tablix1' has an incorrectly set FixedData prop...
Fibriform asked 15/10, 2019 at 14:52
3
Solved
Excel 2016 (16.0.6965.2076)
SQL Server 2014 (12.0.4213.0)
I have an SSRS report with 10 parameters - two are dates and the other 8 are text dropdowns using a query to populate the options. If I t...
Cabman asked 31/8, 2016 at 13:8
1
Solved
I commonly display the number of rows of my datasets in SSRS e.g.
=CountRows("MyDataSet")
However this doesn't work when the dataset is a shared dataset with a parameter.
=CountRows("MySharedDa...
Twister asked 20/2, 2020 at 23:45
4
Solved
I have a SQL Report that insists on printing an extra blank page at the end, even though all the report items should fit on one page. I tried shortening the elements on the page that is spilling ov...
Eltonelucidate asked 5/12, 2008 at 15:51
5
Solved
I have been searching hi and lo, within and outside internet but it seems I cannot find a definitive answer:
Can I change the default layout-items in SSRS reports? If so, how?
So that a textbox d...
Agreement asked 13/2, 2013 at 9:43
7
Solved
I have the following SP which works correctly when ran on its own:
USE [Orders]
GO
SET FMTONLY OFF;
CREATE PROCEDURE [dbo].[Get_Details_by_Type]
@isArchived varchar(10),
@Type varchar(50)
AS
B...
Ellerey asked 29/1, 2014 at 15:2
5
I have a large report that I built in Report Builder 3.0. The report consist of several tablexes and several (800 - 1000) textboxes. When I get an error in an expression, the system says I have an ...
Behre asked 1/11, 2012 at 18:0
6
I have a tablix in an SSRS 2008 report. It has two-level row groupings, and I'd like the value for the left-most grouping to continue to be displayed on each row. Eg, I get this:
group1 subgroup1 ...
Crossbow asked 15/5, 2009 at 11:5
4
Solved
I am trying to consume webapi in ssrs ( XML source ).
If will use parameter in the url (for testing purpose ) then its working really fine for example - http://some_xyz_url.com/Api/Report/GetRepo...
Breathing asked 5/11, 2013 at 13:29
2
I will try to explain the issue as best as I can by oversimplifying the report structure. Report one contains 1 group called ResourceCenter and then one line of totals under it. The totals are actu...
Genteelism asked 3/4, 2013 at 16:40
3
I've be searching and trying for hours to get a query that gives me all current subscriptions from an SSRS serv with parameters and their values, so that they can be recreated on a new server (afte...
Alkmaar asked 13/9, 2012 at 0:5
1
I have True Type Font Verlag installed on my Developer machine & SSRS Server. The Font embeddability value = "Preview/Print"
When I render to pdf from inside Visual Studio it renders correctly...
Iolenta asked 28/3, 2017 at 18:8
5
Solved
I think a lot of developers are facing the problem of try to display page numbers by using SSRS 2008 R2.
There is an alternative solution which requires SSRS 2010 + version. Otherwise you will get...
Reed asked 13/6, 2014 at 5:31
6
Solved
I've seen a few examples but I just can't figure it out for my case.
My expressions sums all values from field Total from the dataset AutoDeliveryCount. I need to reference the dataset since I'm us...
Benitez asked 30/1, 2015 at 18:36
7
Solved
In SQL Server Reporting Services, how would I calculate the last day of the current month?
Quentinquercetin asked 17/5, 2010 at 21:17
8
When I run the report, the date shows in format YYYYMMDD but I need to convert it to format MM/DD/YYYY
For example: 20150213 - expecting result 02/13/2015
The expression below does not work. Sug...
Dichogamy asked 13/2, 2015 at 0:30
6
Solved
I get the following error when trying to run reports:
The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. ...
Skaw asked 21/6, 2012 at 13:55
© 2022 - 2024 — McMap. All rights reserved.