|tree view in drop down list of report builder|
There is no way to use a tree control for parameters using the out of
box report viewer. You could simulate this type of functionality using
a Cascading Parameters. Here is a good technet article on how to do
this: How to Add Cascading Parameters to a report.
|One of two Textboxes in Page Footer does not repeat when page breaks|
I discovered what my issue was. When the report was built, the value
in the footer was referencing the value of an invisible textbox in the
body of the report, which contained the value I need to display on the
By changing the value of the textbox in the footer to reference the
data field instead of a report item I was able to get it to show up on
multiple pages. So the issue was:
|switch report manager URL to report server if access from Ipad|
This is more of an IIS feature than a Reporting Services feature, but
it is achievable. The following guide gives an example of solving a
Essentially, you need to create a list of URL rewrites in your config
file on the webserver that runs SSRS.
|SSRS Print one row then detail|
Do you mean you just want there to be a page break after each of your
packing slips? If so select the list, then at the bottom of the window
where it says "Row Groups" right click the first group and go to
"Group Properties". Finally, go to the "Page Breaks" window and click
"Between each instance of a group" and then "Also at the end of a
group". That should do it.
|SSRS Contains or Like Expression|
In String is your friend. You pass 2 arguments to the function
InStr(), the first is the text to search and the second is the text
you're searching for, it returns an Integer which represents the
starting position of the text you're looking for in the text you told
it to search. If it can't find the text, it returns 0, which you can
use as false (or simply use >0 to represent true). So...
|Reporting Services 2012 - display user name on Report Manager main page|
Here is the answer I got from msdn forum:
You can only show the name within reports not in the report manager.
If you want to show it in report portal screen you need to use a
custom viewer using .NET application.
|Rdlc: dynamically hide item in footer|
You can refer to report item from report body, like this:
You may need to create some invisible textboxes in tables or in other
area of the report body that would contain your visibility criteria.
The only catch is that you can refer to only one report item in your
footer, so without knowing more about the logic of the report, it's
hard to say if this would be suffi
|SSRS personal paper size issue|
If you right click the blue background and go to Report Properties,
you should see an Orientation selection there. Make sure that's set to
If it is already Portrait then the problem is likely to be that the
body of your report is too wide for the Paper Size you have selected.
|SSRS Format to display as percent|
A standard principle is to separate data from display, so use the
Value property to store the data in its native data type and use the
Format property to display it how you want. So rather than use an
expression formatting the Value property such as
=Format(Fields.SomeField.Value, "0.00%") leave the Value as
=Fields!SomeField.Value and set the Format property to P2.
This is especially important w
|Multiple condition formatting SSRS|
I have found success by adapting the code to the below, and this has
now resolved the colouring issue, many thanks for help received.
=IIf (fields!Flag.Value = "Non-Admitted" and
(SUM(IIF(Fields!WEEKS_BANDING.Value = "< value" ,1,0)) / count
(Fields!id.Value) < .95) , "Red" ,
IIf (fields!Flag.Value = "Non-Admitted" and
(SUM(IIF(Fields!WEEKS_BANDING.Value = "< value" ,1,0)) / count (
|Table of Contents Page with Dynamic Page Numbers|
Ok, I've found an adequate solution that I've built a POC on - and it
Its a two pass approach, using custom external assemblies. First
rendering sub-reports to populate a Table of Contents table, and then
running the master report and displaying the TOC results on the TOC
page, and after that the sub-reports agaain.
Here's the link that got me going.
|create multiple charts during runtime ssrs|
OK so, what you need to do is...
Create a List in your report
Group your list on the ID field of your dataset. This will have the
affect of repeating the contents of the List for each distinct value
that it finds (in your example table, it will the contents of the list
for ID 1, then for ID 2)
Insert your bar chart into the List
Set the Category Groups to be your "Name" field
Set the Values to b
|Is CheckBox checked or not in RDL reportview|
I assume you are using a Function or Stored Procedure Object from the
Whatever the object returns, declare a variable, and assign the value
from the object to the variable (is one way of doing it).
Then you can use:
if(variable == True)
CheckBoxYes.Checked = true;
|SSRS not returning any data with Table-valued parameters|
I have modified my answer after you supplied the stored proc. I think
accounttype will be 0 instead of null, since it is int datatype.
Try changing this:
AND (accountType= @accountType OR @accountType = 0)
|Finding a percentage at a aggregate level from variables in SSRS|
Your expression will be:
=Sum(Fields!OOS_Count.Value) / Sum(Fields!Range_Count.Value)
Sum will aggregate at the scope level, which in your department group
footer is per department. You can put the same formula in your table
footer and it will operate over the scope of the table - that is, for
all data reported.
|Issue with SSRS report with temp table|
So after some research I found out that using #temp tables created in
one data set cannot be used in another data set. And using ##tables
are not the way to go either as this will cause all kinds of issues
when people try to run this report at or near the same time.
I was finally able to get what I needed by using a stored procedure to
write the data I was going to use in other data sets into a s
|Moving SSRS Report with parameters to Dynamics CRM 2013|
You Should be able to upload the RDL directly to CRM...
Try creating a really basic report with the same data source and
something along the lines of "select top 10 from filteredincident" and
If it works then you know it's something with your query.
CRM is notorious for giving error messages that don't have enough
information, or are at worst misleading. I've seen this error when
|What is the limit/cap on the usage of Bing maps in Reporting Services (SSRS)?|
Bing Maps will not ban the IP address at this volume. Bing Maps
receives billions of requests a day. The usage from 1,000 users won't
really be an issue. The only real limit is what your database server
can handle in terms of processing these requests.
|OpenERP pentaho report error : Failed at query|
Keyur, I recommend that you post it on github page of WillowIT or this
Here is what I found
Is this query returning NULL?
|Charts and gauges not rendering in Report Viewer|
I re-installed SQL Server (just ran the installer in repair mode - ie,
without uninstalling first) and all the gauges and charts are
displaying correctly again. I have no idea what the problem was.
|Calculating Aggregate of Aggregate in SSRS Report|
You can do this with Row Grouping on your tablix. The images I'm
posting are from Report Builder 3.0, but it's very similar to 2.0.
Here's an article from Microsoft on how to group rows in 2.0:
Here are instructions for how I do it in 3.0, which is very similar.
Assuming you've already created a tablix to do this, right click on
|SSRS Iif always true when false part contains expression|
Excel will guess the type of a column based on the first few cells. If
there's typical DATETIME values in those, it'll guess the column is a
date column, and it will error with "#VALUE! on values that don't
match the type, such as "0".
You should ask yourself what you want to display in Excel for NULL
If you just want an empty cell, don't use an expression at all. Just
|How to get different background color in alternate columns in a table in ssrs?|
in tablix add new column at last & set the name of textbox to
'Rownumber' & set value of textbox as expression
change PrimaryColumnName & dataset1 based on you have in your
now select tablix row & set expression for background color to
=iif(ReportItems!Rownumber.Value Mod 2=1,"#dddddd","White")
|SSRS - I want to insert blank rows in tablix control|
Create a row grouping on col1 (or any unique/pkey col) and then right
click on tablix row and add a row inside group below ... you can merge
the inserted row according to your use/requirement
Based on your requirement.. you have to create a separate report bind
that to result set of stored procedure
CREATE PROCEDURE GETNUMNER(@N AS INT)
DECLARE @Numbers TABLE
|AxPrintPreviewControl - error while generating print preview - dynamisc ax 2012|
In my case the problem reason was report parameter with type
"DECIMAL". After replacing/converting it to "string" (in AX side and
in SSRS side) - problem was solved.
It was Standart AX 2012 Report: AssetExploatiation
|How do I total the results of a row group in a column?|
From the pictures you have posted, it looks like your dataset may be
pulling in all orders for a customer, and not just those with errors.
A good way to check this is to grab the SQL from your dataset and run
it in Management Studio. If you're getting rows that you don't want to
count, you could use a filter on your tablix.
To apply a filter on your tablix, right click on it and go to Tablix
|How to execute SSRS 2012 report using stored credentials?|
It turns out the "log on locally" post was incorrect. You simply need
to select the option to use credentials stored on the reporting
server, provide the credentials, then check the "Use as Windows
credentials when connecting to the data source" option. Test the
connection, Apply the change and you're all set.
|SSRS Expression To Return Last Day Number of Month When Only Have Month Number|
I would use a second parameter that's hidden and returns the date used
in your query. Then set the default value of this hidden parameter to
the following expression:
This assumes your month number parameter that the user enters will
always be for the current year.
|SSRS REPORT BUILDER 3.0 HOW TO GET SELECTED INPUT PARAMETERS DESCRIPTION|
I would create 3 data sets
1 for select * from emp tables where empno = @empno AND date =@date
2 one for select empno from table for the empno paramater.
3 select date from table where empno = @empno.
then build your report and parameters and the two parameters will
correspond with each other.
|Expression error when using LookupSet?|
Since the Join was causing problems with the NULLs in the LookupSet, I
decided to eliminate the Join by putting my commas into the Stored
So my data now looks like this:
TaskID | FundingID | RCPFundingCompany
100 1000 Intel,
100 1001 IBM,
100 1002 TI,
101 1003 Intel,
101 1004 <null>
101 1005 <null>
|SSRS Images in 3 by 3 format in a matrix|
this is little bit tricky ... try to get output of SQL query like this
Declare @Image AS Table(ImageName Varchar(50))
Declare @N AS INT
Set @N=3 -- N X N Matrix
Insert into @Image Values('Image1'),('Image2'),('Image3'),
Case (RowNum % @N)
When 0 then Char(64 + RowNum
|SSRS Count grouped rows|
You aren't restricted to doing everything in the one table.
Create a second table under the one you show here based on the same
dataset, group by destination, show the count, and hide the detail
|SSRS Category Grouping|
You're on the right track. The expression makes sense; I have tweaked
it slightly to use a Switch:
Fields!Total_Aged_Days.Value<=5, "0-5 Days"
, Fields!Total_Aged_Days.Value<=10, "6-10 Days"
, Fields!Total_Aged_Days.Value<=15, "11-15 Days"
, true, "16+ Days"
As you've seen, this will be sorted as a string, so will not be
ordered like you want. To get around this, add
|Does SSRS dynamically set the alignment of table cells based on the majority of cell types in the column?|
Just using the Default TextAlign property value doesn't work. SSRS
does not seem to check intime the values type (when multiple types are
used in the column.) I'm only guessing that it uses some other algo
to determine which alignment to use based on what the majority of
types are in a column. But one way to work around it that I've found
is to explicitly set the TextAlign based on the same exp
|Datasets/data sources no longer work when deploying reports to a new server|
If your data sources contain stored credentials, you need to backup
the encryption key from the original server and restore it in the new
one. Otherwise those shared data sources won't work. If this is the
case and you know the credentials, you can edit manually all those
shared data sources.
Credentials stored in embedded data sources won't work as well if you
don't restore the encryption keys.
|SSRS Format seconds as time (negative seconds)|
It worked like this:
|Can't connect to CRM Online from Reporting Services Manager|
Thank you Donal. There is answer for my question. It was surprise for
me that i can't use FetchXML datasource for connect to CRM online but
i found workeround. I implemented a Data Processing Extension for
Reporting Servies for request data from CRM Online. For a basis i get
|SSRS : calculated field based on other field and condition|
Yes.You can do it. Add new calculated field. You can write IIF
condition. Something like =IIF(Fields!.Level.Value="Lvl_0","
|Display empty point in bar graph|
You could join with another table, containing all statuses, and use
ISNULL for when there's no SnapshotTime:
ISNULL(f.[SnapshotTime], 0), f.[Id], s.[Status]
[Features] AS f
RIGHT JOIN [Statuses] AS s
f.[Status] = s.[Status]
([SnapshotTime] = (SELECT MAX([SnapshotTime]) FROM [Features]))
(FeatureSet = @System OR
@System = 'AL