.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Ugly SSRS Front Page?!

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
 
Is there any way to make the SSRS Front page (Home page) a little better?  I've seen SSRS used at some sites, where the Home Page looks much more professional than the default one.    I don't really want to go and edit the asp pages and do a lot of manual stuff to make this happen.   Any other better way? 

Thanks



View Complete Post


More Related Resource Links

I need help with the syntax for passing a record field value from SSRS to an asp page

  
I have tried several variations without success.  Here is where I am now.  The goal is from inside Report Manager report, link to an asp page with a filed value. This is from the expression line of the Jump to URL entry. Also I am trying to open a new page http://www.whereever.com/CSSurvey01.asp?RecordID=" & Fields!respid.Value            

SSRS 2008 - repeating a non column header column on every page

  
Hi - I am working on my first SSRS report and I have mostly all of it down except one issue. Per requirements, I need to display a column that is a non header column to repeat on every page while printing and or when I save the generated report in SSRS as a PDF file. I have seen some previous blog from 2007 where RepeatWith property is recommended to be set to the same name of the Tablix in which the column(s) are embeded, tried that but it is not working. Can any one help me on this or guide me how to resolve this? Thanks, Manny

Passing parameters from ASP.Net web page to SSRS report

  
I have a web page that displays some data.  The user first selects a date range on the web page and then can edit some data.  When they click a submit button, I want to run a report.  But I would like to pass the start date and end date values that the user already entered on the web page to the report.  Is this possible?  Can I use the value of a session variable in the report? Bob

Problems passing parameters to SSRS report from ASP.Net web page

  
I have a web page that displays some data.   When they click a submit button, I want to run a report.  But I would like to pass the start year/month and end year/month values that the user already entered on the web page to the report.  Here is what my url looks like when the report is displayed: http://xyzserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fDevicesAllNew&rs:Command=Render&StartYYMM=201007&EndYYMM=201008 But my report displays the 2 textboxes for my StartYYMM and EndYYMM parameters as empty.  What am I doing wrong?  I did a google search and I saw something about using ReportServer instead of ReportManager.  I notice at the top of the browser when I run my report, it reads "Report Manager - Windows Internet Explorer".  Is this correct? Bob     Bob

SSRS 2008 group footer totals on a new page has a non-expected large cell height

  
SSRS 2008 group footer totals on a new page has a non-expected large cell height. When the group total is the first component on a new page, then this happens, but when it is part of the group on but not the first component, then it reverts to normal cell height. I have played with the advance settings now for hours, but cannot get this to work. Any ideas?  

SSRS page break issue

  
Hi, I am using SSRS 2005. I have developed a SSRS report which prints multiple invoices, having invoice numbers and the parameters. The report is printing multiple invoices having page break after each invoice ends. But there is a header and body section. The body section contains the line items. The issue is after the header part the body part is moving to the next page for some invoices. When the line items are less, it is printing contineously after the header. If the line items are more the whole body is moving to the next page. When I try to fix this issue, some records are printing in the same page of the header and only last record is printing in the next page leaving a long blank in the first page of the invoice. I appreciate any one can solve this issue and it will be really helpful in solving this issue. Thanks , Mahalingam

SSRS page break when export to PDF

  
Hi, I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices. I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer. My issue is after the header is printed, an automatic page break happens after the header and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape. I wish any one can solve this issue and grateful if they can give the solution for my problem. Thanks, Mahalingam

SSRS Report issue blank page is coming

  
I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

SSRS page break when export to PDF

  

Hi,

I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

Thanks,

Mahalingam


SSRS Report - Page break after the Header when export to PDF

  

Hi,

I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header, and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

Thanks,

Mahalingam

 


Blank page while exporting the SSRS report to PDF format

  
While exporting SSRS report to PDF, I am getting blank page in between and at the end also. The report page size is set to 8.75in x 15.00in with 0.02in margin from left, right, bottom and top. I tried in changing the tablix and rectangle box "KeepTogether" property also. In both the case (true/false), I am getting blank pages. Can anyone help me out?

SSRS blank page iisue while export to pdf

  

Hi,

I have added conditional page break in my ssrs report 2008 , because of blank page issue . After adding Conditional page break the blank page issue is fixed while i am preview the report. But if I export that to PDF alternate pages are coming as blank. I have checked the report width and body width and it is satisfying the condition, Please help to avoid this blank page issue while export to PDF


Jeeva Jacob

SSRS Report printing blank first page

  

 

Greetings,

I have a pretty basic SSRS report that has a table header, body (with a table), and table footer.  When I view the report in normal layout,all is well.  However, when I switch to print layout only the table header and table footer are displayed on the first page.  I don't see any of my table data until page two.  So, this is adding an additional page to the beginning of the report and it's make a 17 page report 18 pages.  And because I am including the page numbers on the report, this is noticeable to the users of the report obviously.  Any feedback on things I could do or check to remove this blank page would be greatly appreciated. 

Thanks

jrock630


Exporting one particular page from SSRS report

  

Hi,

I have developed a report using 2 sub-reports. The report data spans across many pages.
User wants to export one of the sub-report in TIFF format.

Is this possible? Can I export one particular page using export option? Here I don't know the exact page number as well because sub-report may get displayed on any page 2,3.4 etc.

Regards,
Neeraj

 


How to Freeze page header SSRS 2008

  

Hi All,

Can someone tell me how to repeat page header on each page, i am using SSRS 2008.

Thanks in advance.


Font/letter spacing issue when printing from SSRS 2008 report page

  

We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
abcdefghijklmnopqrstuvwxyz
123456789000,000,000.00

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

Page Breaks within tablix (SSRS 2008)

  

Hi,

page breaks seem to be a real issue in SSRS, according to the number of posts, but I haven't found a solution for my problem yet.

My report contains a tablix which is used to group the data by keys. The tablix has one column and one row, and this cell contains several subreports which get their data from another table depending on the keys of the groups. This works quite well. However, I would like to insert a page break in between the subreports. I tried inserting a rectangle with the PageBreak property set to Start and/or End, but this is ignored. Page breaks in the subreports themselves are also ignored. Having the subreports in rectangles with PageBreak property set to Start or End is ignored as well.

The only way I have found to force page breaks is cross-joining my query of the main report with a table containing page numbers, add the page number field as the last grouping in SSRS and check the "Page breaks between each instance of the group", then showing or hiding the subreports conditionally depending on the page number retrieved from the database. However, this obviously multiplies the amount of retrieved data by the number of pages and is therefore a rather slow approach.

How can I insert a page break between rows of a tablix or even within one row?

We are using the Report Viewer control in local processing mode

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend