ssrs-2008 Questions
3
Solved
It's that simple: a query that runs in just a few seconds in SQL Developer connecting to Oracle 11g takes 15-25 minutes in SSRS 2008 R2. I haven't tried other versions of SSRS. So far I'm doing all...
Serpentiform asked 25/1, 2011 at 1:3
5
Solved
I have SQL Server Reporting Services 2008 and when I open the following URL:
"http://localhost/Reports/Pages/Report.aspx?someReport"
I'm getting report screen in which I fill my parameters and...
Fears asked 7/8, 2012 at 12:30
19
Solved
Have just deployed my Project on to my reporting Server.
I have multiple datasets which are referencing views which exist on the db on that server.
When I try to go into any report part I am gettin...
Pina asked 1/6, 2012 at 8:41
7
Solved
I have a report I am doing with SSRS 2008 with some rows that have multiple elements inside them. On the preview the row automatically expands to support the extra elements but however when I expor...
Duley asked 22/8, 2014 at 9:30
5
Solved
Is there a simple way to view the SQL Queries actually generated by SSRS other than running profile traces to capture them?
Is there some way from within the BIDS editor to see this?
Federico asked 9/8, 2010 at 14:36
4
Solved
I'm creating a report in SSRS and across the top I have a header with a placeholder for "Last Refreshed" which will show when the report last ran.
My function in the placeholder is simply this:
=...
Naresh asked 22/9, 2015 at 8:53
3
I have a fairly wide Tablix, and I would like to add similar expressions to each of the textboxes in the row. For example:
TextAlign:
=iif(ReportItems!TextBox1.Value<>0, "Right", "Center")
...
Hertford asked 9/11, 2012 at 16:34
9
Solved
I want to get a copy of all .rdl files in one server.
I can do the download manually one report at the time, but this is time consuming especially that this server has around 1500 reports.
Is ther...
Novosibirsk asked 17/10, 2017 at 5:34
4
I have a tablix that has data for one day, and I need to have the same data at the bottom but in 3 different lines. I'd like to copy the main day table 3 times at the bottom, and then use different...
Publicist asked 11/8, 2014 at 21:6
19
Solved
I have updated the SP for the attached dataset that the tablix is using. The refresh worked fine and I can see my new fields in the shared data set when I look in the Fields tab. My problem is the ...
Cheiro asked 20/2, 2014 at 16:50
4
Solved
Stumbled on an obscure problem. Posting this because my searches of stack overflow did not find my answer. Hopefully this will help someone else.
Problem:
My reporting services report will compile,...
Buttonball asked 29/7, 2014 at 18:17
3
Solved
How can one programmatically determine logins/users that have permission to access specific SSRS reports?
I want to create a datamart in order to populate reports for managers who want to see who ...
Retributive asked 6/7, 2011 at 17:25
17
I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the layo...
Failing asked 12/12, 2008 at 14:27
7
Solved
I've installed a SQL Reporting server (2008 R2), with some reports. But I've some performances issues.
The first call of the day to the server(going on the report interface by example), is VERY sl...
Chibcha asked 26/6, 2012 at 12:11
6
Solved
I have built a report using Report Builder 3.0 (that uses SQL Server 2008 R2). Now i wish to now how many records are being fetched from database to the report?
This is possible either by count fu...
Plaudit asked 3/2, 2012 at 10:32
6
Solved
I'm using SSRS for reporting and executing a stored procedure to generate the data for my reports
DECLARE @return_value int
EXEC @return_value = [dbo].[MYREPORT]
@ComparePeriod = 'Daily',
@Over...
Mordecai asked 7/12, 2012 at 13:25
6
Solved
I'm working with SSRS for the first time. When adding a table to a report, is there any way to add all fields of a dataset to it at once or does it have to be done individually? Drag & drop, in...
Dissidence asked 19/7, 2011 at 17:51
9
My Application is in Asp.Net MVC3 coded in C#, i have a SSRS solution in SQL Server Business Intelligence Developement Studio in Visual Studio 2008 , I'm calling the SSRS report through my Asp.Net ...
Quantify asked 8/10, 2013 at 12:25
3
Solved
Is there a way to control the size of the parameter drop down box? In my current drop down box, the width increase according to the option with label of the longest length, in which causes my repor...
Subjoin asked 5/3, 2013 at 23:46
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'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
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'm working on an SSRS 2008 report. I have a very simple report with three tables, a different data set/tablix (with the same fields displayed) for each. I have PageBreak.BreakLocation set to End f...
Sac asked 2/1, 2012 at 15:44
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
1 Next >
© 2022 - 2024 — McMap. All rights reserved.