one page vs mult pages results

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Reporting Svcs
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Group Filter doesn't work as expected Employee (Group H1) AVG( of all Ratings) Job # (Group H2) Rating Rating is a "Calculated" field in the Dataset. I put a filter on Job# (Group H2) to only include Ratings > 25% Results: Job#'s are filtered properly and every job < 25% does NOT show. HOWEVER, the AVG (of all Ratings) ignores the Group 2 filter and includes every job even those with a rating < 25%. How can I get the "Avg Rating" to also only average those ratings according to the group 2 filter I setup? mythreads Tag: one page vs mult pages results Tag: 65458
  - 2
    - Bug with text orientation I've found following bug: When there is an polish letter (=B3, =E6, etc.) in a textbox which is set to display vertically ("tb-rl" mode) then you may encounter problems with orientation format in Excel export file. Kamel Tag: one page vs mult pages results Tag: 65456
  - 3
    - Matrix Subtotal Dear all, I have a sales break down matrix report like following Prod1 Prod2 Prospect Status Amount Porbability Status Amount Probability p1 Declined 0 0 Follow-up 100 50 p2 Closed 200 100 Sub Total Closed 200 100 Follow- up 100 50 Now, i don't need the subtotal -- status and probability so what should i do inorder to hide some speicfic fields from subtotal Thanks and regards Tag: one page vs mult pages results Tag: 65452
  - 4
    - Problem: render a report which should show data in coulmns Hello, I'm designing a report which contains a sub report. The sub report show a list of data (firstname, lastname). I'm tyring to display data separated by columns. When you use the report Item "List" there is only the possibility to use a page break before or after. Is there a way to use or implement a kind of "column break" ? Thanks Tag: one page vs mult pages results Tag: 65451
  - 5
    - Urgent: MS-BI (SQL Server 2005-AS/RS/IS)-CMM 5-Hyderabad (with possible onsite) Hi, A CMM Level 5 company is looking for Microsoft Business Intelligence (MS BI) professionals for its Hyderabad location. There is a an element of onsite travel & work to this position. Please keep the following points in mind before mailing your CV. 1. STRICTLY NO FRESHERS PLEASE. FRESHER CVs WILL BE IGNORED. 2. Location for these positions is Hyderabad. 4. Experience criteria : 1+ years of experience in Microsoft Business Intelligence (MS BI) in SQL Server 2005 (2005 only, not any previous versions) Mandatory Experience i. Specific expertise of SQL Server 2005 Analysis Services and/or Reporting Services and/or Integration Services. i.e SSAS,SSRS and SSIS. Preferred (not compulsory) Experience: i. Appropriate Certifications. ii. Experience of working in well known software services / product companies. 5.If you do not have relevant experience or you do not have enough experience, please DO NOT MAIL YOUR CV. 6.If you are sending your CVs, please put in relevant subject for the mail; for e.g. "MS BI - SSIS - 3 yrs experience" or "MS BI SSRS - 2 yrs experience" 7. Important: - In your mail, (not in CV) please add the following information : Current Location: - Current Salary: - Expected Salary: - Willingness to relocate to Hyderabad: - How fast can you join if selected (i.e. notice period)? 6. Again: - Please mail your CV to wiprojects@yahoo.com Thank You. From, WI Projects Tag: one page vs mult pages results Tag: 65448
  - 6
    - Execution 'g5l5ch55vliffcvwme3wma55' cannot be found error! I have SQL 2005 installed on my server. When I ran a SQL report return with less data, it will work but when I select more data, it returned with below error. Any suggestion? Below is the exception error in detail for your reference. Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound) Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound)] Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +291 Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) +110 Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollect= =AD ion requestParameters, Boolean fullReportLoad) +90 Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +269 Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +508 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +9 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionSt= =AD ep.Execute() +154 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 Tag: one page vs mult pages results Tag: 65442
  - 7
    - SQL 2005 Reporting Service Requirement Hi, What are the requirements for installing SQL 2005 Reporting Service? Can I install it in a windows 2000 server in NT4.0 Domain? I tried to install sql 2005 reporting service in a windows 2000 box, when I went into Configure Report Server, everything is fine except there is a red cross in front of Web Service Identity, and under Specify the application Pool in which runs the report web service, there is nothing. Can you tell me what could be the problem? Thanks, Tag: one page vs mult pages results Tag: 65439
  - 8
    - ParametersUsed Always Polulated after calling ReportingService.Ren In SSRS 2000 SP2 the documentation for ReportingService.Render states that the ParametersUsed output parameter should only be populated only if the report being rendered is a report history snapshot. I'm invoking the Render method with a null HistoryId as follows, so I would expect the ParametersUsed output parameter not to get populated. results = m_RptService.Render(m_RptCatalogItem.Path /*Report*/, m_Format /*Format*/, null /*HistoryID*/, null /*DeviceInfo*/, m_RptParameters /*Parameters*/, null /*Credentials*/, null /*ShowHideToggle*/, out encoding /*Encoding*/, out mimeType /*MimeType*/, out historyParms /*ParametersUsed*/, out warnings /*Warnings*/, out streamIDs /*StreamIds*/); The call generates the following HTTP traffic. As you can see the HistoryId is not sent in the request yet ParametersUsed is populated in the result. If I'm interpreting the documentation correctly this value should not be populated in the response. I really don't what ParametersUsed to be populated in the response. Is this the correct behavior? POST /ReportServer/ReportService.asmx HTTP/1.1 Content-Type: text/xml; charset=utf-8 SOAPAction: "http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/Render" Content-Length: 524 Expect: 100-continue Host: localhost Cookie: sqlAuthCookie=****; UsrTkn=>****; AppTkn=>**** <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><Render xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices"><Report>/ReportServerStatistics/PTest</Report><Format>HTML4.0</Format><Parameters><ParameterValue><Name>p1</Name><Value>2/11/2007 7:32:50 PM</Value></ParameterValue></Parameters></Render></soap:Body></soap:Envelope> HTTP/1.1 200 OK Date: Mon, 12 Feb 2007 00:32:50 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private, max-age=0 Content-Type: text/xml; charset=utf-8 Content-Length: 9021 <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header><ServerInfoHeader xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices"><ReportServerVersionNumber>Microsoft SQL Server Reporting Services Version 8.00.1038.00</ReportServerVersionNumber><ReportServerEdition>Enterprise</ReportServerEdition></ServerInfoHeader><SessionHeader xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices"><SessionId>glbci3rl3utt1iqmon253t45</SessionId><IsNewExecution>true</IsNewExecution><ExecutionDateTime>2007-02-11T19:32:50</ExecutionDateTime><ExpirationDateTime>2007-02-11T19:32:50</ExpirationDateTime></SessionHeader></soap:Header><soap:Body><RenderResponse xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices"><Result> Base 64 Encoded response removed to shorten post </Result><Encoding>Unicode (UTF-8)</Encoding><MimeType>text/html</MimeType><ParametersUsed><ParameterValue><Name>p1</Name><Value>2/11/2007 7:32:50 PM</Value></ParameterValue></ParametersUsed><StreamIds /></RenderResponse></soap:Body></soap:Envelope> Tag: one page vs mult pages results Tag: 65438
  - 9
    - A4 Page Size settings How can I set a default of A4 Page Size for my Reports? -- Rae G Tag: one page vs mult pages results Tag: 65437
  - 10
    - Crystal designer features I can't find in SSRS Coming from a Crystal background, I was assessing SSRS 2005 and ran into two things I know will generate a lot of pushback from my coworkers. In Crystal you can place group heading fields anywhere you want in a group band, where as grouping appears to be accomplished in SSRS by consuming an entire table column. I suppose I could fake it by making the detail of the main report contain my grouping data and render the detail with a sub-report, but that's overkill for such a common formatting feat. Example (note the horizontal positioning of the group field): Crystal lets us do this: Group1 Detail1 Detail2 Detail3 Detail4 SSRS tables require me to group like this: Group1 Detail1 Detail2 Detail3 Detail4 I would be thrilled if I'm just overlooking something obvious and you can place a group heading anywhere you want. Also, we recreate paper forms in some reports (invoices, POs, etc.) and positioning of drawn lines and text is *much* easier when you zoom in with the designer to 200%. I didn't see how to do this in SSRS designer, what am I missing? Rob Tag: one page vs mult pages results Tag: 65434
  - 11
    - q; users in RS2005 How do you set up user as who can access what report in Report Manger. I do not see security tab in RS2005. Tag: one page vs mult pages results Tag: 65430
  - 12
    - Complex data processing in reporting remote mode / Asp.Net Hi, I wonder what is the best practice to use ASP.Net and reporting service when using remote mode with complex data processing. The report data from a few data sources and needs to use business logic (vb code) to prepare. Can these data processing code integrate into report? If so, where to place the trigger and load the processing function(s) before the report is loaded? Thanks, Luke Tag: one page vs mult pages results Tag: 65429
  - 13
    - Subscription Job Hi, I have the following two questions. 1. Does anyone know if I want to re-schedule the subscription, do I have to change it using Reporting Manager or I can directly change it in a job --> schedule under SQL Agent? Currently I have the job setup to run every one hour but I would like to change it to every two hours, any idea if i can change it in a job directly? 2. I found out the user account to start the job is Network Serivice Account. If I change the startup account for Reporting Serivces under SQL Configuartion, would the job be run under the new startup account? Thanks Tag: one page vs mult pages results Tag: 65427
  - 14
    - rsInternalError I have reporting services installed on my xp laptop and haven't used it for a while. Now when I try to run a report I get the following error message. @AwaitingFirstExecution is not a parameter for procedure CreateSession Anybody seen this before? I can't find any information about this. Thanks MG Tag: one page vs mult pages results Tag: 65425
  - 15
    - RS 2005 Configuration error Has anyone seen the following? RS Virtual Directory System.Management.ManagementException: Provider failure at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path) RM Virtual Directory System.Management.ManagementException: Provider failure at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options) at ReportServicesConfigUI.WMIProvider.RSReportManagerAdmin.CreateVirtualDirectory(String virtualDirectory, String path) Server is an IA64 Windows 2003 Enterprise Edition, SQL 2005 IA64 Enterprise Edition. Is this what happens if the the install location isn't made to the default on C:? Thanks in advance. -- jl Tag: one page vs mult pages results Tag: 65421
  - 16
    - blank report - problems with datasource? I creted a web project with visual studio 2005 express but the report is blank. My report's source is on MySql; I connect runtime and send datatable to the report. this is the rdlc file; I canceled some rows [code] <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/ 2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/ SQLServer/reporting/reportdesigner"> <PageWidth>21cm</PageWidth> <rd:DrawGrid>true</rd:DrawGrid> <InteractiveWidth>21cm</InteractiveWidth> <rd:GridSpacing>0.25cm</rd:GridSpacing> <rd:SnapToGrid>true</rd:SnapToGrid> <Body> <ColumnSpacing>1cm</ColumnSpacing> <ReportItems> <Textbox Name="comune"> <Left>0.25cm</Left> <Top>0.25cm</Top> <rd:DefaultName>comune</rd:DefaultName> <ZIndex>1</ZIndex> <Width>14.25cm</Width> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>0.63492cm</Height> <Value>=First(Fields!comune.Value)</Value> </Textbox> <Textbox Name="textbox2"> <Left>15cm</Left> <Top>0.25cm</Top> <rd:DefaultName>textbox2</rd:DefaultName> <Width>3.99471cm</Width> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>1.00529cm</Height> <Value>Scheda cliente</Value> </Textbox> </ReportItems> <Height>25cm</Height> </Body> <rd:ReportID>2c8fb28d-af14-4a5f-b557-de3fbbfb5378</rd:ReportID> <DataSources> <DataSource Name="reminder_local"> <ConnectionProperties> <ConnectString /> <DataProvider>OLEDB</DataProvider> </ConnectionProperties> <rd:DataSourceID>47284d9e-3aa3-4350-9732-405dc3c0abbf</ rd:DataSourceID> </DataSource> </DataSources> <DataSets> <DataSet Name="DSCliente"> <rd:DataSetInfo> <rd:TableAdapterGetDataMethod>GetData</ rd:TableAdapterGetDataMethod> <rd:DataSetName>dbDataSet</rd:DataSetName> <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod> <rd:TableAdapterName>ProductsTableAdapter</ rd:TableAdapterName> <rd:TableName>tbCliente</rd:TableName> </rd:DataSetInfo> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText>select * from tbCliente</CommandText> <DataSourceName>reminder_local</DataSourceName> </Query> <Fields> <Field Name="id"> <rd:TypeName>System.Int64</rd:TypeName> <DataField>id</DataField> </Field> <Field Name="ragsoc"> <rd:TypeName>System.String</rd:TypeName> <DataField>ragsoc</DataField> </Field> <Field Name="via"> <rd:TypeName>System.String</rd:TypeName> <DataField>via</DataField> </Field> <Field Name="comune"> <rd:TypeName>System.String</rd:TypeName> <DataField>comune</DataField> </Field> <Field Name="prov"> <rd:TypeName>System.String</rd:TypeName> <DataField>prov</DataField> </Field> </Fields> ... fields tolti... </DataSet> </DataSets> <Width>20.25cm</Width> <InteractiveHeight>29.7cm</InteractiveHeight> <Language>en-US</Language> <PageHeight>29.7cm</PageHeight> </Report> [/code] and this is the page code loading the report [code] protected void Page_Load(object sender, EventArgs e) { DataSet dsCliente = new DataSet(); dsCliente.DataSetName = "DsCliente"; MySqlConnection mycnn = new MySqlConnection(ConfigurationManager.ConnectionStrings["reminder_local"].ToString()); MySqlCommand cmd = new MySqlCommand(); MySqlDataAdapter DA = new MySqlDataAdapter(); cmd.Connection = mycnn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("P_ID", 1)); cmd.Parameters.Add(new MySqlParameter("P_AncheAnnullati", "True")); cmd.CommandText = "spSelectClienteByID"; DA.SelectCommand = cmd; DA.Fill(dsCliente); dsCliente.Tables[0].TableName = "tbCliente"; rwScheda.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; rwScheda.LocalReport.ReportPath = MapPath("SchedeClienti.rdlc"); ReportDataSource rptDS = new ReportDataSource(); rptDS.Name = "DSCliente"; rptDS.Value = dsCliente.Tables[0]; rwScheda.LocalReport.DataSources.Add(rptDS); rwScheda.DataBind(); //rwScheda.LocalReport.Refresh(); } [/code] I've already seen that in the table there is one record. Why I don't see anything?? Tag: one page vs mult pages results Tag: 65420
  - 17
    - Handle Hyperlink on winforms report viewer In a recent application i built, we had a requirement to connect to a Sharepoint 2007 site, and pass in user form auth. credentials through our own custom form (which had a webbrowser control built into it). On one of the reports, the client wanted when the user click a detail item, for it to open the link , but in the custom browser form I described above so that it could take care of the "single signon" behind the scenes. I accomplished this by using the Microsoft.Reporting.Winforms.ReportViewer control to render the report, and then on my form which contained the report viewer control, I handled the RepoertViewer.HyperLink event, canceled the event, and passed the hyperlink to my custom browser form. Hopefully this small little tid bit helps someone else Tag: one page vs mult pages results Tag: 65419
  - 18
    - Multiple Formats... I have a textbox that reads " Money: " and then a cash amount..... I have formated the expression like this - ="Money: " & Format(Sum(Fields!Amount.Value),"C") but my question is how can i get the SUM to be a different color than what the word Money is. Currently money is defaulted to black but I want the SUM to be green. Any help will be greatly appreciated, thx! -- CipherTeKST MCSE: Security 2003, CCNA, Security+ Tag: one page vs mult pages results Tag: 65418
  - 19
    - Multiple option report parameter against single field data I am trying to build a report that has a multiple option parameter that is used to restrict data returned based on if all the options exist in a field. The parameter lists multiple values (versions of a document), i.e. 1.0, 1.1, 2.0 etc. Each version is a separate option. Multiple values can be selected. The data for the versions is stored in a single field, i.e. ;#1.1;#1.2;#2.0;# I have been having difficulty in getting this to work when multiple options are selected. I started with the dataset query as: SELECT stuff FROM table WHERE ([Version] LIKE '%' + @VERSION + '%') This worked fine when a single version was selected, but not when multiple versions where selected. I have tried a bunch of things including creating a function that takes @VERSION and parses out the chosen options and concatenates the command string for another like operation. This almost worked, except that the input from the report is supplied as: N''1.1'',N''1.2'' and when put in the function, the comma is interpreted as an additional parameter. I have tried to add single quotes around the input without success, RS escapes it all out. I get the impression that I have completely missed the boat on this one so I am interested in other idea on how I can accomplish this. Tag: one page vs mult pages results Tag: 65417
  - 20
    - Getparameter() problem how to get current Getparameter() value ? i always get the old value after i try to call getparameter() ? Thank you Iwan Budihalim Tag: one page vs mult pages results Tag: 65416
  - 21
    - Export to PowerPoint Is there a way to export a MS Rep Services report to PowerPoint? Thank you. Tag: one page vs mult pages results Tag: 65415
  - 22
    - Document Map - Need to Remove I have removed the Document Map labels on my text boxes. When the report is rendered in RS, the document map pane is still displayed with only the name of the report in the pane. Question: how do I make this go away? Tag: one page vs mult pages results Tag: 65414
  - 23
    - Deploy problem; RS2005 I am not able to deploy report to report server, I have this error: The permissions granted to user <IUSR_MashineName> are insufficient for performing this operation. Tag: one page vs mult pages results Tag: 65413
  - 24
    - Reporting Services 2005 report in Outlook 2007 I have a Reporting Services 2005 report that is emailed to users. I created/formatted the report based on how it looked in Outlook 2003 which all of our users had at that time. The report is wide, but just fit in the email window when it was full size. Now I have a user who has been converted to Outlook 2007 and he emailed me a copy of the report he received in Outlook 2007 and it looks like it reduced the column sizes; it does not fill the entire email window and wraps the wording on most lines because the column sizes have been reduced. The report is: Delivered by: Report Server E-mail Include Report is checked Render Format is Web archive Any ideas on how I can fix this? Thanks in advance. -- DJanson Tag: one page vs mult pages results Tag: 65412
  - 25
    - Permissions I am writing my own security extension, I have it working perfectly fine on the web service end.. I can run reports, etc... but on the report manager site the http://host/reports site.. I dont get anything except the header... what permissions does the user have to have to see a toolbar and reports list? right now I get an Icon then "SQL Server Reporting Services" then "Home" then 3 options "Home | My Subscriptions | Help" and that is it... I cant figure out what permissions are missing... thanks! Tag: one page vs mult pages results Tag: 65411
- Next
  - 1
    - Key can not be null I am trying to write a security extension but every time I get past my forms based logon screen it says "Key cannot be null. Parameter name: key" which I cant figure out what that means, nothing I have that is a key is ever null... however if I do this... Public Function GetPermissions(ByVal userName As String, ByVal userToken As IntPtr, ByVal itemType As SecurityItemType, ByVal secDesc() As Byte) As StringCollection Implements IAuthorizationExtension.GetPermissions Dim permissions As New StringCollection() return permissions end function and return an empty string collection of what should be permissions, it goes right into the report manager but with no permissions, so I assume my problem is coming from here, but no clue what it means, any help on this? thanks! Tag: one page vs mult pages results Tag: 65406
  - 2
    - HTML Tags in Text Boxes I'm using a 3rd part infragistics to store comments with formatting. Where reporting back something as simple as <STRONG><U>testing</U></STRONG> is not rendered. Does anyone know how to achieve this rendering within report pages? Thanks Tag: one page vs mult pages results Tag: 65401
  - 3
    - Anyone knows about this? I have SQL 2005 installed on my server. When I ran a SQL report return with less data, it will work but when I select more data, it returned with below error. Any suggestion? Below is the exception error in detail for your reference. Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound) Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound)] Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +291 Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) +110 Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad) +90 Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +269 Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +508 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +9 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 Tag: one page vs mult pages results Tag: 65394
  - 4
    - Anyone knows about this? I have SQL 2005 installed on my server. When I ran a SQL report return with less data, it will work but when I select more data, it returned with below error. Any suggestion? Below is the exception error in detail for your reference. Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound) Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot be found (rsExecutionNotFound)] Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +291 Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) +110 Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad) +90 Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +269 Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +508 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +9 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 Tag: one page vs mult pages results Tag: 65393
  - 5
    - How to use Parameters without letting it to Prompt to enter Hi All, We are using 10 parameters in SRS report. When the report is executing, it prompts us to enter all 10 parameters. But we don't want to enter all parameters, we should be able to enter blank parameters without mandatory parameters. SRS prompts to enter all parameters. Kindly help. Regards, Manoj Mobile: +91-9989010205 Tag: one page vs mult pages results Tag: 65390
  - 6
    - Data Driven Hi, I understand I can create a stored procedure to return all the parameters for data driven. The last statement of the Stored Procedure is Select * DataDrivenTableName. However, after I put Exec SPName, and when i go to the next page to fill out all the To, CC, Subject..., there is nothing in each drop down box and I can't continue to finish the setup. Any idea what's wrong. Thanks Ed Tag: one page vs mult pages results Tag: 65386
  - 7
    - Reporting Services Login Issue I have a client that has a unique situation. Here is the back ground information: A Reporting Services 2005 server in a DMZ. This server is not part of any domain, only has local users. A SQL Server with the Report Database and an Analysis Services Server with the Cubes on which the reports are built are behind the firewall. These servers are in a Windowss 2003 Domain using Domain accounts for access. The issue is getting the Report Server in the DMZ to successfully open a report based on a Cube. Using a Standard SQL Server Login we can successfully open a report from the Reporting Server in the DMZ that uses a relational database behind the firewall. This works obviously since we can use a Standard Login and not deal with the domain/no domain issue. When we try to setup a report that uses the CUBE, we can not get the Domain Server to accept our "ghost" user we created. We create a user, "reptusr" on the local server in the DMZ. We also created a user, "reptusr" in the domain behind the firewall and gave that user id access to the CUBE. This is not working. I can't find a lot of information on this specific scenario so any information anyone may have would be greatly appreciated! Thanks in advance! Martin Tag: one page vs mult pages results Tag: 65385
  - 8
    - Multi-value parameters in URL I can't find anything on passing multi-value parameters in the URL. I can pass one and it selects from the combobox, but when I pass more than one, it doesn't select any. I have a parameter named Locations that is multi-value. I have tried passing "&Locations=1,2". I have tried "&Locations='1,2'". I have tried "&Locations=1%2c2". Nothing works. Tag: one page vs mult pages results Tag: 65383
  - 9
    - Document Map does not display on reports rendered from a snapshot Where I work, we are converting from SQL Server 2000 to SQL Server 2005 and VS 2003 to VS 2005. So, I'm having to convert all of our reports to 2005. Here's the problem...I have linked reports that generate via a snapshot. When I open the linked report, the document map does not display. Instead, I get an error message "Some parameters or credentials have not been specified". This seems to only happen to reports that have a query based default parameter. The query returns only one record. The reports run successfully in 2000, it just the 2005 version seems to be less forgiving. Has anyone experienced this same problem and found a solution? Thanks in advance for any help you can offer. Tag: one page vs mult pages results Tag: 65380
  - 10
    - Data-Driven Subscription and Multi-Value Parameters I have see several references to the fact that you could not use data driven subscriptions for a report that has a multi-value parameter/s. Can anyone confirm that this is true? If so, are there plans to change this in future releases? My life would be soooooooo much easier if I could combine the two functionalities. Thanks! Tag: one page vs mult pages results Tag: 65376
  - 11
    - SQLServer Express Reporting Services Permission Problem I have installed SQLServer 2005 Express with Adv services sp1 onto a windows 2003 platform. I have published some existing reports and when trying to run these from the Report Manager on the actual server, I get the following error: An error has occurred during report processing. Cannot create a connection to data source 'Mydb'. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I have checked the settings for SQLServer and remote connections are enabled (I can access the database ok). The datasource Mydb has the correct connection settings for the database and the credentials are set to be stored in report server and are valid. I can't see what else is wrong - any ideas? Tag: one page vs mult pages results Tag: 65373
  - 12
    - SRS 2000 Ampersands and GUIDs Hello: I'm an SRS 2000 newbie. Two questions: 1. Is there a way in SRS 2000 to convert a GUID to a string or to pass a GUID as a parameter? 2. When a user clicks on a detailed line item, they are navigated to a new browser window with that detail field value as a parameter. This field may contain ampersands. The URL gets rejected due to the ampersand Does anyone know a way around this? Ex. ParamName = Test&Data URL would look like the following: http://...<reportserver>.../ReportName&ParamName=Test&Data Can this somehow be encoded and if so, how? Thanks so much for your help! Tag: one page vs mult pages results Tag: 65372
  - 13
    - Multi-Column Layout hello, I am trying to create Mailing Labels. I clicked Report --> Report Properties --> Layout tab, then chose to output in 3 columns. The result is still one column of labels. What is the proper way to print data on multiple columns? Thanks Tag: one page vs mult pages results Tag: 65371
  - 14
    - Subreports - Fixed Length I have a master report with 3 Sub report each aligned to specific space. Since one report that feed data to the sub report has 5 pages it makes my Master report to go 5 pages too. Is there any way that I can make those data to show under a sub report with scrollbar (horizontal and vertical) so that I show all the 3 sub reports in one page (like a Dashboard) thanks, PDG Tag: one page vs mult pages results Tag: 65369
  - 15
    - Reporting services 2005 crashes Hi All , I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003 enterprise edition 64 bit machine. I created a project and using a wizard created a report with Analysis services cube as a datasource.Preview works fine but when I try to fix the fonts or add elements and try to save it it crashes.How ever with out saving I build the report or use the debug it works fine for the first time the next time all the columns are deleted from the dataset. I reproduced this problem thrice using diffrent prifile logons and creating the project in different drives. Thank you . Rose. Tag: one page vs mult pages results Tag: 65367
  - 16
    - Report designer 2005 crashes Hi All , I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003 enterprise edition 64 bit machine. I created a project and using a wizard created a report with Analysis services cube as a datasource.Preview works fine but when I try to fix the fonts or add elements and try to save it it crashes.How ever with out saving I build the report or use the debug it works fine for the first time the next time all the columns are deleted from the dataset. I reproduced this problem thrice using diffrent prifile logons and creating the project in different drives. Tag: one page vs mult pages results Tag: 65366
  - 17
    - Report Manager in SQL Sever 2005 I just loaded Reporting Services for 2005 and when I go to http://localhost/reportserver I do not see the Report Manager like I did in Reporting Services 2000. I have deployed a test report to the server and it works, but when I go to the server I get a list view of the directory and don't get the report manager. I have a report manager directory on my c: drive but cannot seem to find out how to launch it. Does 2005 have a web based Report Manager? or do I have to access it through the Server Management Studio? John Wright Tag: one page vs mult pages results Tag: 65364
  - 18
    - Back Button in RS 2000? Hello. I'm developing reports in Reporting Services 2000 and Visual Studio 2003. I have a "drill-through" report. Upon drilling through to the report, and then clicking the back button to return to the main report, the report doesn't even render. However, while developing the report and previewing it in VS 2003, there is a back button supplied there that works perfectly every time. My question is this: is there a way to tell Reporting Services to include a back button like the one in the report designer on the deployed report? Alternatively, is there a way to provide a hyperlink in the drill-through report that takes the user back to the original report (with all parameters included in the link)? Thanks! John Tag: one page vs mult pages results Tag: 65363
  - 19
    - sql server 2000 RS client-side prints strange characters Hi, I'm at my wit's end on this. I printed my reports from the development environment and all characters came out right. It's only when I printed my reports using the client-side printing after I deployed them to my web server that the strange characters come out. Instead of a smooth comma, I get a dot with a wavy line underneath it. The letter y looks like the letter v with a wavy line beneath it. The letters p and g all have strange wavy lines on their undersides. Can someone please help me? Tag: one page vs mult pages results Tag: 65362
  - 20
    - Problem with Drillthrough event from dll Hello forum We are developing a WinForrms application that uses muti-layer technology in which the report viewer is a layer that includes a winform that belongs to a separate project within a single solution. This tier shows all the application reports using a single ReportViewer control in Local Mode. We use drilling to show detail reports through links in master reports. It works fine if we generate an exe file and it executes isolated. But when we change the project to a class library application type and runs the report layer (a generated dll) from the initial exe, this one show the first master report with no problem, but when we "drilltrhough" to any detail report an error occurs: "The definition of the <my_detail_report_name> report has not been specified". We solved this issue by including the form with ReportViewer control and rdlc files in the initial project but it isn't what we want. We need to let the report layer in a separeted layer (DLL). We thanks any help Tiempo Hard development team. Tag: one page vs mult pages results Tag: 65357
  - 21
    - Bold AND Italic Text Not Possible? Is it not possible to format text as bold and italic in SRS? I find this hard to believe, but whenener I specify both properties (FontWeight and FontStyle), the italic property overrides the bold property. Anyone else encountered this problem? Is there a work- around? Tag: one page vs mult pages results Tag: 65355
  - 22
    - Subscriptions I am sure this has been answered in here before, however, I really need some help here. I am trying to do the following from within SQL Server RS 2005 without additional code or other application. Suibscription should send report once a day to a static distribution list. This distribution list does not change enough to require a data- driven subscription. However, I dont know how to avoid it. The report should fire once a day, once a certain process is complete and data is updated. I thought about setting a flag in the recipient data that would cause the report to fire, but then if nothing else is done, the report would fire over and over all day until the flag was reset. I suppose I could check the execution log with an sp and unset the flag once the report has successfully been sent once that day. I was also thinking of firing a subscription once the process to update the data is complete. This seems so much more complicated than it needs to be. Any insight would be appreciated Tag: one page vs mult pages results Tag: 65352
  - 23
    - Field Error I am getting the following error: The group expression for the list â??Titleâ?? refers to the field â??Title. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. When I reference the stored procedure in my report, I do not get a field list. I believe it is because I am trying to build a report that references a stored procedure using dynamic sql, and I am told that it has to be dynamic sql by the DBA. If I am correct in this, question I have is how do I build a report referencing dynamic sql without getting this error? The stored procedure works and returns a resultset. Tag: one page vs mult pages results Tag: 65350
  - 24
    - Date Time Picker for RS 2005 Hi, For some odd reason, the DT Picker on my Report(which has been deployed and which is open via the web) is taking quite a long time to display when a user clicks to select a date. Could you please provide me with a solution to this issue. Thanks. Tag: one page vs mult pages results Tag: 65348
  - 25
    - SQL Reporting Service SubReport Query Hi All, Im new to the Reporting Services. I have a report which will display all the department Report 1 : --------------- DeptID Department -------------------------------- 101 Software 102 Marketing Report 2 : -------------- EmpId Empname DeptID ---------------------------------------------------- 202 AAA 101 203 BBB 102 204 CCC 101 On selecting on Department number (101)at report1 i need to list all the employee in the who all belongs to that department. I have used a sub report. but when i select the department number in the report1 it is redirecting to the Report2 where i get the employees of that department details. I need to club both the report on the same page. I dont want the content to be displayed in separately. i want to display both the content in the same report (Report1 & Report2) Expected Output -------------------------- Select Department ============= 101 Software 102 Marketing List Employees for the department Department : Software -------------------------------------------------------------------------------------- EmpId Empname =========================== 202 AAA 204 CCC pls do advice on this regard. thanks in advance. Franklin Tag: one page vs mult pages results Tag: 65343

I have a lengthy report that can at times span 50-60 pages. One of the other
dba's modified the report, now the results all show up on one verrrry long
page. we have been tying for a few days to figure out how to get it to span
multiple pages again, with no luck. Would someone please advise what property
to modify to get the report to span pages again?

I would greatly appreciate it if someone could help out!!

Top

Re: one page vs mult pages results by Bruce

Bruce
Mon Feb 12 12:39:57 CST 2007

Interactive Size property, expand it and look at height. If set to 0 then
you get one long page when rendered to html. You still get pages if PDF.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Carl Henthorn" <CarlHenthorn@discussions.microsoft.com> wrote in message
news:D0715FCD-3E74-462F-93AB-12BC9C897FB4@microsoft.com...
>I have a lengthy report that can at times span 50-60 pages. One of the
>other
> dba's modified the report, now the results all show up on one verrrry long
> page. we have been tying for a few days to figure out how to get it to
> span
> multiple pages again, with no luck. Would someone please advise what
> property
> to modify to get the report to span pages again?
>
> I would greatly appreciate it if someone could help out!!

Top