I have a financial report that includes 3 fields that I'm trying to sum.  I only display a grouped total - not the detail.  One field sums a planned gift and both the grouped total and the final total works fine using sum(amount).  One of the fields is the asset balance and one is Net Present Value that is calculated on the report side.  All of the grouping totals work, but when I do the final totals I have a variety of problems.  I've listed some of the things I've tried and what the result is... sometimes it is an amount that is incorrect and sometimes it is an error.  The code I'm using (which I know very little about) is at the end of this.  

sum(asssetbalance)  - is the wrong amount - it is way too large (it should only sum the first asset balance)
sum(first(assetbalance)) - error that aggregate functions cannot be specified as nested aggregates
=Code.GetABTotal() - is the wrong amount - it appears that it totals each page, not a grand total
=sum(ReportItems!textbox72.Value) - gives me an error uses an aggregate function on a report item

I read that that you have to move the =sum(ReportItems!textbox72.Value)  to a footer so I tried that as well and it once again appears that it is totaling the page and not providing a grand total.  

Here is the code I tried and is for both fields that I'm trying to total:

Public Dim FVTotal as Double = 0
Public Dim ABTotal as Double = 0

Public Function AddFVTotal (Amt as Double) as Double
      FVTotal = FVTotal + Amt
      …

I have an SSRS report that displays the TextBox contain muliple fields and it's content correctly in SSRS but when I try to export it to Excel the data is not show .

LEDES-1998B.rdl

Background:
Sometimes when printing postal addresses to mailing labels, there may be a limited number of mailing addresses that do not consume an entire sheet of Avery labels. If an Avery sheet starts out with 30 blank labels and there are 20 addresses to print, this would leave 10 unused labels on the sheet. I was using a report that I created in SSRS 2008 to print the labels.

At a later time, when I needed to print more mailing addresses, I would have my SQL Server query generate 20 empty records, plus UNION in the actual mailing addresses, and this data would be passed to the SSRS report. This caused SSRS 2008 to skip over the 20 labels that were already used on the sheet, and begin printing on label 21. This allowed me to finish using the remaining labels on the sheet. The addresses would be properly printed on the remaining unused labels.

There was probably a better way to manage this, but at the time, it was the only idea that worked.

Current Day:
Several months ago, our environment was upgraded to SQL Server 2012 and uses SSRS 2012. The 2008 SSRS report was successfully deployed to SSRS 2012, but it no longer works as it did in 2008. If I were to repeat the scenario described above, the query is still generating 20 blank rows, but what SSRS 2012 appears to do is execute a carriage return / linefeed 20 times, and then starts printing, instead of skipping pass 20 "used labels" in order to start printing on label 21.

I have been researching to …

I have a report that needs to be run for 1 of 2 databases. The (2) databases are identical in structure, but not in data.

We have a company database that is identical in structure for 2 clients. I will call the clients "Coke" and "Pepsi" for this example.

I want the user to have a drop down in the report so the user can select to run the report for Coke or Pepsi. The stored procs that create the datasets exist in both Coke and Pepsi databases.

Is this possible or am I stuck managing 2 separate reports?

I hope to spend some time digging into SSIS and wonder what are the most useful aspects of SSIS?

Thanks

Migrated web application from one sever to another. couple of folders in web app have rdlc files.
When trying to browse on the browser <ip-address>/Reports/default.aspx , it prompts with windows username and password.

Then it displays error on browser saying

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly.

I can see on the web application drive the reports folder and default.aspx exists along with rdlc files. What am I missing here?

Is it possible to transfer usernames and passwords when adding an existing data source in SSRS? I have not had any success in finding a solution. We want to keep passwords secure so report developers cannot see them. I have created a Shared Data Sources folder in SSRS with the intention of having the developers simply add an existing data source from this folder into their solutions. However, when I ran a test, the existing data source did not import with the credentials.

Is that by design and if so, is there a workaround?

We are using SSRS 2008.

Thank you.

I have two tables A and B. Both have same fields names ( Group and Roles)
Now I want to compare two tables A and B, I only want to only field group, not roles

I want to have the results
1. common groups
2. Groups in A but not in B
3. Group in B but not in A

This may need 3 queries. How to do that?

I have problem in txt file output. I have record "His short film features 4 readings of a prose poem from Leonard Cohen’s novel Beautiful Losers". when output comes in txt file like"His short film features 4 readings".
It will shows half records.But in PDF format i got well result..I can not the drag the width of SSRS reports bez it will show unformatted manner.
1img.PNG
2img.PNG

I have column Name is FirstName and It has 30 characters like ' signs agreement with HTC continuing our big bet'. when I am displaying this value with ssrs reports it shows me half characters like 'signs agreement with HTC'. I need to display all values.

I need to make SSRS 2012 reports available to users on a mini ipad.
What would be the best way to implement?