View Complete Post
The formatting of the report is perfect when viewed in Visual studio and also after exporting it to pdf or excel. But when I deployed my solution and opened it on IE/Firefox there is a lot of problem in formatting. Specifically the row height is giving me
a problem. I manually entered them to be 0.1in and made the CanGrow field as false to force that row height but some rows in the tablix expand ( to 0.15in, which is the height of my header). This is true for a matrix as well. Is there is a feature to lock
the row height in IE o any other web browser?
Can someone tell me how to repeat page header on each page, i am using SSRS 2008.
Thanks in advance.
When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dyanamically.Sp Please try to give me a solution.
IÃÂ have a reportÃÂ created in SSRS 2005 which is running on our new SSRS 2008 box.ÃÂ It has 3 nested levels of visibility so the recipient canÃÂ click the twist tie toÃÂ viewÃÂ different levelsÃÂ of detail.ÃÂ Each Zone has many Districts and each District has many Stores.ÃÂ The report renders displaying the summary of the Zones.ÃÂ If you click onÃÂ the twist tie on the Zone it opens up a list of Districts.ÃÂ If you click on the twist tie on a district, it opens up a list of stores.ÃÂ If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.The report renders fine in report manager.ÃÂ The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.ÃÂ The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts andÃÂ Stores.ÃÂ The client is not happy about this.ÃÂ This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.I tried converting the report to SSRS 2008, but that did not solve my problem.ÃÂ Is there anyway to fix the export process to Excel?ÃÂ ThanksCarolP.S. I tried to upload the code, but it caused my question to be too many characters
I have created fairy simple report having a table in body section and Header, Footer. I have set the Report Properties
Orientation - Landscape
Paper Size - Custom
Width - 11in & Height - 8 in
Margins - Left 0.25 in , Right 0.25 in, Top 0.5 in, Botton 0.5 in
Issue NO 1: When i export the report to Excel, it takes margin as Left 0.75 in , Right 0.75 in, Top 1 in, Botton 1 in, because of this some part of my Report is cut. what should i do to keep margins of Excel as per margins set in RDL.
Issue No 2: In Footer excel shows Page 1 of 1 for all the pages
Expression used :
"Page" & Globals!PageNumber &
" of " & Globals!TotalPages;
Issue No 3: when i export the Report to word, it does not consider landscape and show only middle part of report, cut rest of the report data.
I have created a new report & add a table to it. When I select "Tablix Properties" and check on Columns Headers -> "Repeat Cheader columns on each page" the header columns do not repeat on each page. I also tried "Repeat header rows on each page". "Add page break before" seems to work ok. I am using VS 2008 9.0.30729.1 SP
I also tried deploying butÃÂ it stillÃÂ does not work on the deployed version.
Interestingly, reports migrated from 2005 & unchanged seem to be ok.
Any ideas? Am I not setting soemthign up properly?
I have a SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups. I dont have this displayed in the report and dont want it displayed in teh excel
export, is there anyway to turn this off?
I've had a search of this forum but so far i've been unable to find a solution(or someone else having the same problem)
Is anyone aware of this new feature of 2008 R2. How to have the excel tabs renamed after the report will be exported to Excel. What properties I have to set to do the same. ?
I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend. Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint. The upgrade went fine, no errors that i could
find. The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.
I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application
however when i do click the new report builder report it kicks me over to
http://company.com/ReportServer_MossEnt which itemizes out each individual sharepoint site in the farm.
Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work? did i install the wrong version of the report builder add in? The above is the only problem i am having now.
all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu
I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS. Here is the run down:
Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)? Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?
I am required to plot the following graph in an SSRS report.
Sum of Total Credits to be shown on Positive side and total sum of Debits for a month on negative side. I have created a query which retrieves all the expenses for the month and sums them up before feeding the same to the graph for plotting. Both values returned are positive integers.
(Sorry for the diagram below, i tried to paste an image but it didn't work)