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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS Paga no. issue when subscription

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server


I am using SSRS 2005 version. I am generating invoices in the Report by passing multiple invoice numbers separated by commas as a string. There is a grouping on Invoice no. in the report and the invoices are printed in order. I have used page number in each page and the page no. is printed for each page of the invoice. The page no. resets for each invoice and it starts from Page:1 in the next invoice. This works correct when we run the report from report server by passing the parameters.

When I Schedule the reprort using subscription, invoices are generated and the page no. is not printing correctly. I find this issue only in the subscription of invoices. I am giving the codes used for this report below.

The following code is used inside the text box where the Page number is printed.

 ="Page No: " &Code.GetGroupPageNumber(ReportItems!txtInvoiceNo.Value,Globals!PageNumber)

View Complete Post

More Related Resource Links

Is Conditional Subscription possible in SSRS 2005?


Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???


ssrs space issue

Can anyone please explain how to reduce the blank space between two rows in ssrs report, I tried with adjustingthe row hight but it does not help meJeeva Jacob

Printing Issue in SSRS reports

Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are mentioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.   The issue now is with the Printing.My client complains that they are not able to print the Reports properly.Some of the columns are moved to the next page,it seems.Reports are having different number of columns and we dont know how to resolve this issue.Should I use Landscape or Portrait?..If I give the table's width in the place of Report's width,will it work?    Your help would be greatly appreciated.

SSRS integrated mode email subscription to AD dist group

I have MOSS 2007 running SQL 2008 SSRS integrated mode and have created some reports and report subscriptions. Everything is working great. Now I want to use an Active Directory Distribution Group as a recipient for a report subscription - does not work, however the "last results" show no error. Try again using Dist Group in TO: field but adding regular email in CC: field...only email in CC field receive report, again all successful. Does SSRS integrated mode support AD distribution groups? if so is there any special setup required? Thanks LmmMmmm...yummy...

using SSRS Windows File Share subscription to send file to sharepoint

Hello, I'm looking for the simplest way to automate sending SSRS reports to a Sharepoint document directory.  I know a document library is not a real directory but I am able to run copy scripts into one using the virtual path thats shown when I do Actions-> Open in Windows Explorer. However when I set up a subscription to send a report to this directory, I get an error: Failure writing file \\intranet\projects\docs\test.pdf : The network name cannot be found.  Just checking if anyone knows if this should be able to work or not. Thanks

Multivalued parameter & Data driven subscription for SSRS 2005

I need to create data driven subscription for our reports. Most our reports have multi valued parameters (7-12 parameters with at least 4-5 with multiple values)and need to be send to a users between the range of 25-200. So standard subscription is really not a choice.I have gone through most of the threads before. Question 1:Does any one have a solution for the SSRS 2005 regarding passing mutiple values for a parameter for the Data subscription table. If yes, could you please share the information. Question 2:I found some solutions using the SOAP API. Can any one explain that in detail- how we can do it ?Reference:http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8ab615b4-1373-4258-bf49-c2843cfea8e9/http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516735&SiteID=1 Question 3:Here is the other solution I found in one of the postsApparently passing in values like {A, B, C} only works when you configure the parameter values not to come from a dataset so that SSRS doesnt check for ValidValues.Reference: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/b2c50aea-2032-4025-a155-306c00fcb856/Any commends about this solution?Thanks

SSRS Subscription Management: Restart, Stop, View Status, update properties, etc

As SSRS admins, there are times when a user comes to us and ask: I didn't get my reported emailed to me today?or worst, a report subscription going to multiple people doesn't run and now you have lots of people missing their subscription - (suppose server crashed, or something happened).One idea of course would be to have the subscription owner re-schedule it to run now, or create a new -- but - i'm thinking - we should create a subscription adminstration tool.a .net app that queries the ssrs web service, gets a list of subscriptions in the ssrs system (or perhaps by folder) and then is able to 'restart a subscription', "stop a running one", 'view all subscription status, schedule, owner, etc' if I wanted to d this - what is the web service that I could use this for?and most importanly - has anybody dont anything like this that they can share?this is for ssrs 2005 & and I'm hoping 2008 can be called through the same .net app tool

Setting Title on SSRS (SharePoint Integrated Mode) subscription.

I have some subscriptions in SSRS where the report goes directly to a Document Library on Sharepoint.  The subscription works fine, however, I would like to have the Title of the report be the current date that the report is run.  Is there a way to put a formula such as =[today] in the Title field of the File Options section on the Subscription properties?  I have tried this but either it is not possible or I am not using the correct syntax.  Thanks, Tim Olig

SSRS Subscription Defaults

Hi, We use SSRS 2008 for many of our reporting needs, and it is set up in Sharepoint Integration mode.  If you click on "Manage Subscriptions" --> "Add Subscription" --> "Configure" under the "Delivery Event" option and change the frequency to "Month", the default is to send the report on all months on calendar days 1, 3, 4, and 5.  Is it possible to change this default so that it will just populate "calendar days" with 1, instead of 1,3-5? This gets a bit annoying because many of our users set up their own subscriptions and fly right through the screens, keeping the defaults... Then they get the same report on day 1, 3, 4, and 5, and only want to receive it once.  Thanks.

SSRS Integrated: Program Subscription Building?

We have a few hundred clients, and we need to run a daily sql report for each of them. Saved in a document library, they can be picked up by the Search. I'd like to avoid the manual work of setting up 200+ report subscriptions. What would be the recommended route?1) Work with the sql 2008 object model?2) Work with the MOSS object model? (I see no class methods available for this - is this even possible?)3) Work directly with either the report server database or the sharepoint database and with ado.net just loop through a set of insert statements, one for each client we want a report for?Thanks for any input/direction.markusMarlin7

SQL 2005 - SSRS - timeout on Subscription Creation

SSRS failing when we are trying to create the subscription with a "timeout" failure.  The report runs when run normally, and we have created subscriptions of this report on other computers.  We have adjusted the timeout value to a very long time.  The error message returned is:   The operation has timed out (System.Web.Services)   ------------------------------ Program Location:      at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)    at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)    at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetWebResponse(WebRequest request)    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)    at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials)    at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials)    at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetReportParameters(String report, String

Issue with Enable and Disable Parameters in SSRS 2005

Hi Guys, I am currently facing an issue with Enabling and Disabling Parameters in SSRS 2005. Here is my scenario. I am having the following 4 parameters - ParamType (has values 1,2,3), ParamMonth, ParamStartDate, ParamEndDate Now What I want is When I select ParamType = 1 and 2 then ParamMonth should be enabled and ParamStartDate and ParamEndDate should be disabled. When I select ParamType = 3 then ParamStartDate and ParamEndDate should be enabled and ParamMonth should be disabled. I have done google search on this issue and found out that this is not possible at run time. Is there any alternative for this issue? If the above is not possible, I would like to get atleast in this way : When I select ParamType = 1 and 2 then ParamMonth should show the values (from dataset named MonthDataSet and default should be the latest Month) and ParamStartDate and ParamEndDate should show as NULL. When I select ParamType = 3, then I need to enter ParamStartDate and ParamEndDate values manually or pick via datepicker and ParamMOnth should show as NULL. I am not sure whether this is possible or not....but just trying to get in some way. Here is the query used in MonthDataSet : Select Month_Code, Month_Name from MonthTable. Thanks

Character spacing issue SSRS 2005 custom font

Hello together, we are facing a strange character spacing issue in SSRS 2005 SP3 (Version 9.00.4035.00). As we export the report to a pdf file, we get unwanted spaces between each character. The report uses custom fonts. Is there any known issue related to this? I appreciate your help. Thanks!  Kind regards Moritz Mars

SSRS 2008 Conditional Column Visibility Whitespace Issue

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

SSRS 2008 Paging Issue 0 of 0

I have several reports that are many pages long when rendered in visual studio, but when rendered on the web client it show pages 0 of 0 with the next and last buttons disabled. Only the first page is displayed but if I export to any format it renders all the pages correctly. Please help!

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 2008 web portal issue, urgent!!

I created a report using reporting services 2008, now I want to upload the report into the web portal so that users can start running the report from the web browser. When I opened the http://server1/ReportServer url from the browser, I just see the below, I installed full version of reporting services 2008, so I am trying to figure out what piece is missing from the installation. Please advice. Thanks. server1/ReportServer - / --------------------------------------------------------------------------------       Friday, January 02, 2009 4:15 PM        <dir> Data Sources    Tuesday, January 20, 2009 10:13 PM        <dir> HR      Friday, January 02, 2009 4:15 PM        <dir> Accounting --------------------------------------------------------------------------------Microsoft SQL Server Reporting Services Version 10.0.1600.22 sqldev
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