Search results for query: *

I have a matrix which reads a stored procedure. The stored procedure produces multiple columns, some of which are subtotals. I would like to only include 3 of the columns in the grand total column. How do I create a column of only the sum of certain columns? Sorry if this is confusing. I'm in a...

Thank you all. I was able to make it fit using the margins.

What the output looks like is State Total White Black Am Ind Chin Jap Haw Phil As Ind And so on. Each entry in the title is a column. When it displays on the preview screen (SSRS 2008) everything looks fine. But when I go to create PDF, it only produces about half the columns and then goes to...

Thanks but no. I actuallly read that. I'm not using any special fonts.

I'm using SSRS 2008. My report looks fine in the preview window but when I try to write it to PDF it gets all screwed up. How can I get the onscreen to look like the pdf.

Thanks Crowley16, sorry took so long to respond. The use of a second dataset with the method outlined earlier produced the desired results. Not wanting my program written for me but any idea how to get an character to print if a rate numerator is less than 20? Not in the totals, but in teh...

I can get the rate per 100,000 population into a variable but how do I get the variable into my SSRS report? If the dataset is queried it returns just teh variable and not the rest of the fields in the table.

I recoded my SSRS report and it works now as before. I still am having trouble inserting the code I was given into T-SQL stored procedure. I've gotten the stored procedure to compile and output the proper data but i haven't figured out how to get the right arrangement to get it into the proper...

See here for info on adding a subtotal. One of the options on the list is Before/After. Choose Before and it will go on top. If you are using SSRS 2005 its different. But I beleive this is the method for 2008. http://msdn.microsoft.com/en-us/library/ms157334(SQL.90).aspx

Something to add. This report has been moved to SSRS 2008 from SSRS 2005. For some reason it used to work but isn't anymore. Its wrong, but at least worked in SSRS 2005. The actual error displays "An error occurred during local report proecessing. An error has occurred during report...

Understand your advice. I have a t-sql stored procedure calculating the data for the SSRS table. My trouble incorporating the new code into the existing stored procedure which seems to work except for calculation of the rate for the state totals. Also I seem to be caught in a situation where...

The query works right as expected. I was expecting to use and expression in SSRS to fill the textboxes containing the numbers. I might not have thought about how to use the query enough. You know anyway to access the method you showed me to fit into an SSRS table texbox? I appreciate the help...

Have a dataset in SSRS in table format by State and AgeGroup. The table has State as rows and AgeGroup as columns. For each row there are zeros in all teh columns except the column containing the particular AgeGroup and the last 2 columns which are totalageid and totalpopageid. I want to do...

Thanks for taking the time to respond. Below I repeated the table and after that I post the results that I expected. Alabama 0 0 0 0 0 0 0 0 0 0 14325.41 11393 79530 Alabama 0 0 0 0 0 0 0 0 0 5987.25 0 12500 208777 Alabama 0 0 0 0 0 0 0 0 2569.587 0 0 8410 327290 Alabama 0 0 0 0 0 0 0...

I understand your statement. My first statement was that since there is no SSRS forum that I would post this in the next best area, which seemed like SQL Server forum. Thank you. If someone would like to move this post to a more appropriate area that is okay by me.

There is no SSRS forum so I figured this is the closest thing. Anyway here is my problem. Have a dataset in SSRS in table format by State and AgeGroup. The table has State as rows and AgeGroup as columns. For each row there are zeros in all teh columns except the column containing the particular...