Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
0
votes
1 answer

SSRS - Sum of calculated percentage

I have a summary tablix that contains 2 columns 1) Count 2) Percent. The Percent value is calculated based on the count divided by total count. For example, to get 35.8% it is 1,011 divided by total count of 2,824. I'm trying to SUM up the total…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

Error as please use version that support this project

I need to make the change son rdl files so I had installed Visual studio 2008. but when I am trying to open the project below issue arises. please use version that support this project Please review below image How can I open it successfully or…
Mitesh Jain
  • 555
  • 4
  • 13
  • 40
0
votes
0 answers

Parameter not showing before while loop

I have a report that needs the user to enter a number that is passed to a parameter and that number determines the number of rows populated in a table. I then need the other parameter to pop up once per row. This is to populate a form that will be…
Caroline Allen
  • 183
  • 14
0
votes
1 answer

Dynamic Report title base on parameter selection in ssrs

Hi i have a report where i have 2 parameters and each parameter is populated by getting the value from their respective Data-set. Now i want to create the title of the Report in a way that if the User Select just one account number then i want to…
deep
  • 41
  • 1
  • 12
0
votes
1 answer

SSRS how to create dynamic title with date range

I have a SSRS Report where in the Header i have inserted an expression to make the reports title dynamic, like this report title Now i want to achieve the result that when i select invoice start date as 1st January 2018 and END Date as 1st January…
deep
  • 41
  • 1
  • 12
0
votes
0 answers

Filtering on MS SSRS 3.0

Can anybody please give me a idea how to filter this out? When Somebody buy something, they can add optional warranty to their product. I need to create a report when they attached that warranty, I need to see the product too. I don't need to see…
PrasadD
  • 77
  • 1
  • 9
0
votes
0 answers

web form ssrs report date icon not displaying

I have an ssrs 2008 r2 report that has a date icon on 2 of the parameters that are dates that runs on an ssrs 2012 report server. This report is accessed by running a vb.net 2010 web form application via a report view control. The date icon works is…
user1816979
  • 511
  • 4
  • 13
  • 25
0
votes
2 answers

Nesting IIF in SSRS 2008

I'm writing an expression which needs to calculate the number of days between current report rundate and the date value in field (named cmp_lastap), then return a value of: "delinquent" if the number of elapsed days is >= 60, "past due" if >= 45…
Justin
  • 3
  • 3
0
votes
1 answer

Tablix inside Rectangle inside Textbox not visible when report renders

I have built a report with a list of caveats at the end within a text box. Inside this list I need to display a table of static text. The only way I have found to show the table is to put a rectangle inside the text box and place the table inside…
Caroline Allen
  • 183
  • 14
0
votes
1 answer

how to create parameter in ssrs with hard code value yes and No

Hi i am creating a report using SSRS and i am getting value for this report from a store procedure; now i'd like to create a parameter which should have only YES and NO values in the drop down list. Base on this value when i should select YES i…
deep
  • 41
  • 1
  • 12
0
votes
1 answer

First of Function in SSRS / show first row of each page

In my SSRS report, I have more than 500 pages. In the header section, I have used an textbox with expression First (Productname), where the productname is one of the column in my report. How to display the First row productname of each page on that…
Ramanathan N
  • 1
  • 1
0
votes
1 answer

Parameters Hidden or not in SSRS

In SSRS, we have parameters and also DataSets in Report Data. I want to know whether or which parameters are hidden or not ( hide if it is any database key field ).
vysnav05
  • 3
  • 2
0
votes
1 answer

add parameters in ssrs url in report viewer

Hello I have ssrs report and I want to pass parameters within URL is it possible? report link: http://serverName/reports/reportname it is possible when I access link like…
Piyush Jain
  • 5
  • 6
0
votes
1 answer

Return a Revenue Total from previous month using SSRS Expression

Is there a way to return previous month's Revenue as an Opening balance? For Example: Create an expression to pull the revenue field for all In progress deals on the last day of the previous month using an expression I can get the the last day using…
JR83
  • 39
  • 4
0
votes
0 answers

Keep getting "conversion failed" message in SSRS

I keep getting the error message "Cannot read the next data row for the dataset... Conversion failed when converting the varchar value '4y 5m' to data type int" when running an SSRS report that pretty much just returns the rows from my dataset.…
Dom Vito
  • 507
  • 8
  • 38
1 2 3
…
99 100