reporting-services Questions
2
Solved
Lets say that I have 10 columns to view report and I want to hide 3 of these columns at runtime based on the value of parameter which the user would select. This can be easily done by setting the c...
Plunger asked 28/4, 2013 at 11:2
8
Solved
I'm back with another SSRS question :-)
I'm dealing with survey data. I have a procedure that's returning an organization's response counts per question. So my report is defined as Group on Organi...
Silvereye asked 1/12, 2009 at 14:13
4
Solved
When upgrading a machine, we lost the Visual Studio project that was used to create SSRS reports. The Data Sources and the Reports still exist on the server however. Is there a way to re-create the...
Eb asked 24/10, 2011 at 11:58
3
I have been tasked to look into ways to automate the deployment process for our SSRS 2012 reports. Are there any good tools out there? I'm thinking of something along the lines of press a button an...
Overdraw asked 2/6, 2014 at 19:54
4
Solved
I have an .rdl file that I need to open in Visual Studio. When I try to open this file, I got an XML file. However, I am unable to see the designer format.
I don't know which version of Visual Stud...
Legitimist asked 7/2, 2017 at 7:33
8
I have just opened up a project that contains SSRs reports and yet I am unable to view them in Design Mode. When I click on them, only the XMLS appear and I am not sure how to resolve this in VS 20...
Expressage asked 22/1, 2015 at 23:50
3
I am using SSRS 2008. Currently everything works find so long as I put all reports in the Reports folder of the Report Server Project in Visual Studio.
I attempted a work-around, which is to have...
Circlet asked 22/9, 2009 at 14:22
4
Solved
I added an additional, new DataSet to my report and have been getting this cryptic error ever since.
Shenitashenk asked 11/8, 2009 at 18:26
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
10
I have a live report that's somehow showing cached data despite the fact that I've disabled all caching (that I'm aware of). When I run the query in the BIDS query editor, it shows the current data...
Acidify asked 13/8, 2013 at 13:12
3
I am using Visual Studio Professional 2012 and trying to add web reference for ReportService.asmx through Add Service Reference>Advanced>Add Web Reference.
In the Add Web Reference dialog I enter...
Gamin asked 6/1, 2015 at 6:13
8
Solved
I am so close to getting my last report up and running. I have not had this problem with any other reports. I am trying to create a report based off a database record. When I go to create the repor...
Raze asked 6/8, 2019 at 21:44
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
2
Solved
I have a table like this.
And I want to use SSRS to present the report like this.
I use a Matrix in this report. Add [Category], [Commodity] to row group, add [SaleDate] to column group, add ...
Damato asked 2/2, 2014 at 14:5
3
Solved
I have converted a report file from Crystal (.rpt) to SSRS (.rdl) using an automated service tool. When I preview the report in Viusal Studio SSDT I am getting a very strange error message:
“The n...
Sappy asked 23/7, 2018 at 17:52
9
Solved
I've one main report with 5 sub reports.
Sub report contains more than 10 parameters. (With 10 Multi valued parameters - So I've used Join method to pass value from Main report to Sub Report)
I'...
Meatman asked 28/10, 2015 at 7:24
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'm using Join(Lookupset) to find unique group values which returns a sequence number. This is my function:
Join(LookupSet(Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Val...
Briggs asked 20/11, 2014 at 19:3
6
Solved
I would like to use a sub report, since it gets used on many reports, in the header. However, sub reports won't go into the header and neither will field values. Although, parameters will go just f...
Correggio asked 19/10, 2009 at 15:18
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
2
I'm having an issue processing an excel file with SSIS unless I manually open the file and click 'save'.
I've noticed that it doesn't mater if the file is .xls or .xlsx
The file is downloaded to...
Mangrove asked 11/12, 2014 at 16:19
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
7
Solved
I'm attempting to show a sum in a table footer on a report. It will be in the body of the report and can't be in the header or footer. The table footer repeats on each page but should show the sum ...
Ensample asked 17/11, 2009 at 20:23
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
8
Solved
I'm working on a SQL Reporting Services report (in VS.Net 2005) which displays a count of different data in a matrix. The columns have a count on the amount of customers in a certain set. So I have...
Rat asked 26/1, 2009 at 12:56
© 2022 - 2024 — McMap. All rights reserved.