ssrs-2008 Questions
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
5
Solved
I am using sql reporting and written query
SELECT * FROM users WHERE created_by = @createdby
and passing parameter using this code in code behind file to call this report.
param[0] = new Repor...
Evertor asked 14/11, 2011 at 9:43
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
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
4
Solved
I have an SSRS report to which I am passing a Start Date and End Date parameter but I keep receiving the following error:
Procedure or function 'MyReport' expects parameter '@startDate', which w...
Absorbed asked 24/8, 2015 at 19:11
7
Solved
We are in the process of migrating our reports from Crystal Reports to SSRS. In Crystal Reports we use variables to dynamically generate our filenames so when the report gets sent out via email, th...
Thermos asked 7/9, 2012 at 21:8
5
I want to change the Datetime parameter to DDMMYYYY format.its default value is MMddYYYY.when user will select date from date picker the date should be display in ddmmyyyy format.
I tried all expr...
Hyoscyamus asked 21/4, 2015 at 14:29
3
How can I get SSRS reports to show a web page view?
When I go to the SSRS reports page, it's not showing the web page view. It shows a list of data sources, data sets and report folders.
After g...
5
Solved
I have added a filter expression using the like operator. What do I put in the value field? my parameter is named @test and I'd like the filter to function as a like %@test% would in SQL. I want it...
Queer asked 4/2, 2011 at 13:13
7
Solved
i'm recieving the following error:
Error 1 [rsInvalidAggregateScope] The Value expression for the text box
‘Textbox2’ has a scope parameter that is not valid for an aggregate function.
The scope...
Berate asked 4/2, 2014 at 12:7
7
Solved
How do you check if a textbox is empty in SSRS 2008?
I've tried this code and it doesn't work.
IIF(ReportItems!txtCountVolunter.Value = "", false, true)
Dichy asked 5/10, 2012 at 2:7
3
I have an ssrs matrix , the design of which looks like this :
The sql query used in the above dataset looks like this :
select [YEAR], [MONTH] as MONT , ProductName, NumberofSales from XYZ ;
...
Ufo asked 6/12, 2013 at 0:30
4
Solved
I have created a report in ssrs 2008 r2.It is larger then the normal A4 size .So when i export the report in word i see it clearly but when i see print preview of the report in to the word its cont...
Bornholm asked 15/12, 2012 at 7:27
5
Solved
I have some reports with drilldown, and I have now been asked to add a breadcrumbs style navigation to the report so the user can access the parent report again without having to use the litte 'bac...
Paganism asked 17/6, 2011 at 10:58
17
Solved
Can anyone advise what the syntax should be when using the IN operator within a table filter.
I have tried the below but the snytax is wrong:
Washing asked 7/11, 2013 at 16:8
5
Solved
I have a customer table that I want to use to populate a parameter box in SSRS 2008. The cust_num is the value and the concatenation of the cust_name and cust_addr will be the label. The required f...
Albuminoid asked 19/9, 2012 at 18:52
3
Is there any chance to do vertical merge of fields in tablix?
I am working few years on SSRS, but only saw horizontal merge of cells, vertical not.
Sparrow asked 26/7, 2013 at 12:0
12
Solved
I have a report that has about 10 parameters and about 10 datasets and one datasource. I typed alot but I really need help so I figured I would try and provide as much info about the problem as I c...
Dorrisdorry asked 9/3, 2011 at 21:47
9
Solved
I have report, which takes YEAR as one parameter and I wanted to calculate the start and end of the financial year. Here is how I'm trying:
CREATE PROCEDURE [dbo].[sp_name]
@StartDate as datetim...
Clothes asked 26/8, 2015 at 5:21
7
I got a problem while creating a report in SSRS.
The ERROR shows:
Error 1 [rsInvalidReportParameterDependency] The report parameter ‘COUNTRY’ has a DefaultValue or a ValidValue that depends on...
Ranged asked 22/10, 2010 at 7:32
10
I'm having trouble adding a line break in SSRS 2008.
I've tried all of these different ways but nothing is doing it.
"+ chr(10) +" , "& chr(10) &" , "& chr(13) & chr(10) &" , ...
Lotta asked 28/2, 2014 at 13:56
5
Solved
I have been trying to resolve this simple issue for a few hours with no joy.
I have two tables within my SSRS 2008 report which are bound to different datasets and I need to show or hide the appro...
Deni asked 15/10, 2015 at 8:40
5
I'm exporting an SSRS Report to Excel and when the user tried to sort it for some column. They got the message "This operation requires the merged cells to be identically sized.
How can I generat...
Logic asked 20/6, 2012 at 1:50
5
Solved
My SSRS report contains 7 input parameters and while running my report the size of the parameter(i.e. length) is increasing.
One of my input parameter(drop down list) may contain 100 characters so...
Shrewish asked 14/8, 2010 at 11:55
3
Solved
I have a Pie chart generated using SSRS. I would like to Show both Count and percentage in the Pie chart.
Right now, I am able yo show the count in pie charts as well as in the report.
I want to...
Miniature asked 30/10, 2014 at 5:39
© 2022 - 2024 — McMap. All rights reserved.