SSRS Newbie and feeling a bit silly. Im working on my first report(in VS 2008) and cant seem to work out the group footer for my tablix. This must sound really simple but how do I add it and configure it to show on every page of my report? I have the group header working fine but I want the overall totals to display at the bottom of eac...
I have a report that shows customer appointments, by sales rep for the past 3 months grouped by customer sector. In the Customer Sector group header, I want to show the percentage of the overall total of customers in this sector that the appointments represent. For example, my report shows that 6 appointments were made by John Smith fo...
Hi, I've deployed a report using reportViewer on my local machine. It's a wide report so requires a horizontal scroll bar across the bottom of the report but fits fine vertically. This is fine in FF, however IE renders it with the vertical scrollbar as well and no matter what I do I cant get rid of it! Is this a problem with IE? Can I...
I work as a consultant at a company that have around 30 reports in a reporting services 2005 server. All of the reports use around 10 parameters to change the data loaded into the report. The parameters is depending on eachother also. The problem is that the reports causes long loadtimes for booth changing parameter and processing/loadi...
I have a simple report maid in bids 2008 and deployed to a ssrs2008 server. it has this report properties: page unit : Centimeters page size : Orientasion: Landscape paper sise: A4 width : 29,7cm Height: 21cm all margins ar 2,5cm Showing and printing this report works fine making it perfekt on a A4 paper. expor...
I have a SSRS report which displays daily status report for the team members. The dataset of the report depends on User!UserID as a parameter which is passed to the SQL Query to fetch the data. I want to create a data driven subscription on this report so that every user gets his/her daily status report each morning. But when I click on ...
I have a report that uses User!UserID. But "Data Driven Subscription" cannot be created on reports using the "User Collection" or having data source with Windows Integrated Security. What is the work around for this? ...
I have an SSRS report that calls out to a stored procedure. If I run the stored procedure directly from a query window, it will return in under 2 seconds. However, the same query run from an 2005 SSRS report takes up to 5 minutes to complete. This is not just happening on the first run, it happens every time. Additionally, I don't se...
Hello, Whether in SSRS 2005 or 2008, someone said that SSRS Report Model will cache the data defined within the report model and you will be required to update the report model regularly to get the new data into the report model views... is that correct? To me, it seems the report mdoel stores the definition/metdata only... could some...
how to set the group in table footer? for Ex: i need to count the items of columns based on grouping? ...
Hi All, I created the Reports in SSRS and i deployed in my local Report Server. Now one of my client wants that solution in their server(Development) in a Package. But i have no idea how to create MSI package for SSRS.... So please help me, i want to deliver that Package please Thanks in Advance Vinay K ...
I have a basic report in Reporting Services 2005, with a few header text boxes and a table with a header row and some detail rows. I have the page layout setup as an 8.5 x 11 with 0.3in margins set all the way around. The table and all the textboxes have a 7.625in width. In the viewer the report looks fine. In the viewer in the Print ...
I have a table with a group. I'm using a toggle item in the details group. If the user clicks in the header group the details are shown. I want to change the background color of the header group rows that have its details expanded. In other words, I want to change the property of a report item based on the status of a toggle item. Is t...
I need to run the reports on SSL, how can I configure it for the reporting services? ...
Is it possible to have 2 report parameters set the same actual parameter? For example, the user should either be able to type in an ID, or select it from a dropdown list - for the query to then take that id and run the proc for that id. ...
I have a MS Reporting Services subscription implemented which emails out a CSV report as an attachment. The email is received with the attached CSV file no problem, EXCEPT for users with Lotus Notes. With LN users the contents of the csv file are embedded in the body of the email. Any suggestions on this? UPDATE: Might Lotus be handin...
I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial Period Types in sequence correctl...
Hi Team, I have an report to be sent in email using SSRS 2005. I have created subscription through C# code, some time back. It used to send emails successfully. Now, it does not send. There is a message as "The delivery extension for this subscription could not be loaded." [The report is rendering properly when I try with Report Man...
Hi I am new in SSRS reporting service.. So please guide me how can i develope report ? also tell me which tool required and what are the pre-requists ? i want to develope report using linq datasource and to use it in my wpf application.. please guide me... i need help.. ...
I tried to be the most descriptive I could. Ok, so since I've never done anything like this before, I guess it's better to ask before starting at all to just don't get the whole process wrong. We have a report that has to be called from an ASP.NET application, it could be a simple button. Through the code-behind, I gotta pass in a para...