Bug in Tutorial: Creating an Ad Hoc Report Application with Report

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
    - Subreport Question? I have a main report with 4 subreports. Which subreports are visible on the report is determined by the user at runtime via a custom parameter page. I have implemented the show/hide without any problems but the report seemed to be running very slowly. The issue is that even if a subreport is hidden it still executes the generation of the subreport which in my case is very time consuming. What I would like to do is dynamically not only hide the subreport but also stop the report from ever generating. Is this possible? Any other suggestions would also be greatly appreciated. Thanks, Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26944
  - 2
    - PDF Export Prompts for Authentication I am having a weird problem with just one report in production. When exporting to PDF format only, the browser prompts for user authentication. No matter what you type in the window (even admin for server) it just keeps popping up. When you click cancel you see the following error. HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials. Internet Information Services (IIS) The log file shows the following w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ### GetReportChunk('RenderingInfo_PDF', Other), chunk was not found! this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5 w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown., ; Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> System.StackOverflowException: Exception of type System.StackOverflowException was thrown. --- End of inner exception stack trace --- at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) --- End of inner exception stack trace --- w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services error Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> System.StackOverflowException: Exception of type System.StackOverflowException was thrown. w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dsChangesInLargeLoss'. ---> System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found System.StackOverflowException exception: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> System.StackOverflowException: Exception of type System.StackOverflowException was thrown. w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker process Other reports in production export to PDF without a problem, just this one report is causing issues. Any idea what might be causing this issue? The report exports to PDF fine in development for this report. Has anyone else seen this issue before? Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26943
  - 3
    - History Snapshots I must have misunderstood something about the history snapshots. Can I not set it up so that every newly generated report creates a snapshot in the history. I need to store all the reports that are generated by users as snapshots in history. Maybe I missed something though. Thanks, Brian Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26942
  - 4
    - Unknown in user listing I am not sure why my username is showing up this way .. this account is a part of the administrators group. Modified Date: 3/31/2005 11:42 PM Modified By: ASP06\dan[Unknown] Creation Date: 3/31/2005 11:42 PM Created By: ASP06\dan[Unknown] I am using sql authentication to connect to the db .. the user I am connecting with is the dbo of the ReportingServer db Thanks Dan Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26938
  - 5
    - Problem Deploying Reports when using SSL Here is my current setup. I have Report Services sp1 installed on a Windows 2000 machine with SQL Server 2000. We have successfully configured RS to produce reports over the internet via SSL. The actual viewing of the report over the internet works great. However, in Visual Studio I receive the following error when trying to deploy the reports... "The underlying connection was closed. Could not establish trust relationship with remote server" The only work around I have found so far is to modify the rsreportserver.config file and change secureconnectionlevel= from 2 to 0. Then I am able to deploy the reports and do not receive this message. Because SSL is a must, I then have to change the secureconnectionlevel= back to 2. Users externally are accessing the report server via http://FQDN/reportserver. I had gone into the rswebapplication.config file and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl> to <ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck. My certificate name uses the FQDN as the site name. My question is why I am not able to deploy my reports when the SSL is turned on? I hope this makes sense and I am sure I left something out. Please let me know your thoughts. Thanks! Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26937
  - 6
    - Jump to URL's I have a report that needs to "jump" to 2 URL's at the same time. I also need them to open in a second and third window leaving the first open to the orginal report. Can this be done? I have the report right now that can "jump" to one of the links in the cell. But it uses the original window. Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26936
  - 7
    - 2003 Server SP1 broke Reporting Services Installation of WS2003SP1 broke reporting services SP2Beta. I now get "The request failed with HTTP status 401: Unauthorized." I've re-set the database credentials via RSCONFIG. I think it's in IIS, but I can't seem to find it. Any help would be appreciated. Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26935
  - 8
    - Jump to Report Not Functioning Correctly Hi all, I'm having a problem with a series of reports I'm developing that allow the user to design their own reports. They involve passing parameters (and sometimes not passing parameters) between many different reports. The issue I have is this: I have an opening page with no parameters. When I jump to the next report (using Jump to Report in Properties -> Navigation tab) it begins to load the next report, but the parameter bar is missing (not hidden) and the report itself doesn't load (although the report title is displayed in the top frame). If I use "Jump To URL", these issues appear to be less of a problem but passing parameters is more difficult. A couple of questions for you: 1) Has anyone else experienced this issue? 2) How can I pass parameters in a Jump to URL string, based on either report parameters or report datasets? I've had a look around on the forums and have found some similar problems, which is why I ended up looking at the Jump to URL option. I haven't found anyone with the same issue though. Can anyone help?! Thanks in advance, Jon Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26932
  - 9
    - Dynamic Placement of Textboxes Is there a way to dynamically place textboxes within report headers based on a change in size of the report? My report consists of one table and four matrices, each of which are configured to page break at their end. Some are wider than others. I have horizontally aligned the textboxes within the header, but of course as I go to each page, they're then out of center. I don't have the ability to set the "Location" of the object with an expression. I was hoping there was a better way to dynamically center objects at run time. Why isn't the renderer smart enough to do that based on the change in size of the report? Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26930
  - 10
    - Installing developer edition of RS Greetings all! I've had an Evaluation Edition for all those 120 days :). Today it broke down and told me that my Evaluation edition has expired. I decided to install Developer Edition and got the following. 1) A pleasant, but strange thing: it said to me that because of sharepoint services, i'll have to initialize report server manually, but at the end of setup, report server ran succesfully by itself (perhaps because i've done all the steps of troubleshooting earlier, for my Evaluation Edition) 2) All my parameters have russian propmpt. When I upload an rdl with russian parameter prompt into the report manager, it starts showing '????????' instead of the propmt itself, and it also spoils values of hidden parameters. But!!!! when I had Evalution Edition - everything was OK. What happened?!!! What it the solution? to install again Evalution Edition? Earlier we used a temporary "solution" where we took correct russian values from the correct report server database and wrote them to the spoiled one. But still ... some of rdl's were not spoiled and are uploaded quite properly. I can't guess what's the problem with the '?????' rdl's, why do they differ. Please, pay some attention at my message :) The reason of the problem is extremely interesting for me. Thanks Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26926
  - 11
    - HELP NEEDED - URGENT Hi All, I am having a report with a table and 3 graphs. When I render the report into the HTML3.2 format I am getting only 2 graphs. On refreshing the page, sometimes I am not getting the other two graphs also. I haven't set hidden property of the graph. My report server runs on windows server 2003 machine. and i am accessing the reports only through its IP not by name. My Report is working in the following scenario i am having two datasets. the 3rd graph is coming out of the second dataset and the table and other 2 graphs are coming out of the first dataset.The first dataset executes an SP and which will clear the contents of the table and the insert the values in to it as per the business requirement. The second dataset is query which will fetch the data from that same table. Till today this report has worked fine for me. I have given "no data found " caption for the NoRows property of the 3rd graph. On consecutive refreshing i am getting this caption sometimes and sometimes i am also able to see the graph. The output has now become totally unpredictable!!! Can anyone please help me in fixing this issue? Thanks in advance Bala Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26924
  - 12
    - ToolBar display through WebFarm - rewriting URL I have Reporting services working fine for all cases but one. When putting the ReportServer in a WebFarm, the SSL from external is only until the Web Farm interface, traffic is then redirected using the same URL HTTPS://<site name> but the Web Servers do not have SSL running on them. Reporting Services is rewriting the HTTPS://<site name>/ReportServer as HTTP://<site name>/ReportServer which is causing failures. This is happening for the Toolbar and for the charting image references. How can I get Reporting Services to not rewrite the URL. I have tried everything. I do not want to install SSL on the web server but I need to access through the web farm using https. Any help would be great! Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26922
  - 13
    - Can Reporting Services display images from SQL Server where field is a reference to an image? This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C53688.2BAEB810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can Reporting Services display images from SQL Server where field is a = reference to an image? For example, if the field called images contains = the text" ~/Images/Image.jpg" ? I know it can be done if the object is = embedded, but what about the case where there is just an address? If = so, how? if not, any work-arounds?=20 TIA, Paolo ------=_NextPart_000_0008_01C53688.2BAEB810 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.3790.259" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> <P><FONT face=3DArial size=3D2>Can Reporting Services display images = from SQL Server=20 where field is a reference to an image?  For example, if the field = called=20 images contains the text" ~/Images/Image.jpg" ?  I know it can be = done if=20 the object is embedded, but what about the case where there is just an=20 address?  If so, how?  if not, any work-arounds? </FONT></P> <P><FONT face=3DArial size=3D2>TIA,</FONT></P> <P><FONT face=3DArial size=3D2>Paolo</FONT></P></DIV></BODY></HTML> ------=_NextPart_000_0008_01C53688.2BAEB810-- Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26913
  - 14
    - CUSTOM ASSEMBLY IN RDL - ISSUE - NEED YOUR HELP! Hi All MSTR Mentor's I have a RDL, where the stored procedure returns 10 fields among that 1 field is the creditcard# which is encrypted, I need to decryt the creditcard # and display it in the report. I use a .net custom aseembly which has a decrypt function and it is added as a reference to the rdl and it is WORKING FINE when i view the report in the PREVIEW TAB of the report designer. When I deploy the report to my ReportServer of the localmachine and view the report it is showing #Error on the field value. What could be the problem, plese help me on this issue. using System; using System.Text; using System.Collections.Specialized; using System.Configuration; using System.Security.Cryptography; using FCLX509 = System.Security.Cryptography.X509Certificates; using WSEX509 = Microsoft.Web.Services2.Security.X509; using WSECRY = Microsoft.Web.Services2.Security.Cryptography; namespace RDLCustomCode { public class DataDecryptionClass { public DataDecryptionClass() { } public static string DecryptCardInfo(string cc,string subjectName,string storeName) { try { string sCreditCard = ""; WSEX509.X509CertificateStore.StoreLocation location = WSEX509.X509CertificateStore.StoreLocation.CurrentUser; WSEX509.X509CertificateStore.StoreProvider provider = WSEX509.X509CertificateStore.StoreProvider.System; WSEX509.X509CertificateStore store = new WSEX509.X509CertificateStore (provider, location, storeName); bool fopen = store.OpenRead(); if(fopen) { WSEX509.X509CertificateCollection certs = store.FindCertificateBySubjectString(subjectName); if (certs.Count > 0) { WSEX509.X509Certificate cer = certs[0]; WSECRY.RSACryptoServiceProvider rsaCsp = (WSECRY.RSACryptoServiceProvider)cer.Key; byte[] cipherData = Convert.FromBase64String(cc); byte[] plainData = rsaCsp.Decrypt(cipherData, false); sCreditCard = Encoding.UTF8.GetString(plainData); } } if (store != null) store.Close(); return sCreditCard; } catch { return ""; } } -- Message posted via http://www.sqlmonster.com Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26910
  - 15
    - SMTP configuration Hi all, When you install the SQL Reporting, you have the option to add the mail server. Where can I find this infomation after the installation. In my case I didn't add it during the installation so I need to add my mailserver! Thanks! Björn Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26909
  - 16
    - Chart: legend should not scale with the chart The legend scales with the Chart. My client would the rectangles in the legend to be perfect squares. Is this possible? -- Callidus Software Designer Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26908
  - 17
    - PDF rendering: Characters overlap in Verdana On some of our RS machines the Verdana font doesn't render correctly in PDF format, there is no spacing between the letters (all at the same location). Other fonts like Arial render correctly. Is this a known issue? sp1 has been installed (I know there were some issues with this before service pack 1). -- Callidus Software Designer Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26907
  - 18
    - Chart: Adding extra fixed gridlines Can I draw extra gridlines at a fixed number in my Charts? Can I add Extra text on the axes? -- Callidus Software Designer Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26906
  - 19
    - Chart: Combining color and fill patterns in bars. Can I combine color and fill patterns (e.g lines) within my bars for different series? I use the palette Gray Scale for the fill pattern and then try to use an expression like this =Iif( (Fields!bar_name.Value = "response"),"Transparant","Red") for the Fill Color. However, the red bar doesn't contain a fill pattern, only the transparant one does. Is it possible? -- Callidus Software Designer Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26905
  - 20
    - One Stored Procedure For Multiple Table Hi, I have a report consisting of a chart and 4 tables. I have written a stored procedure to return different (single) result depending on the input parameter. E.g. @Param is 1 for chart, 2 for table 1 and so forth. The issue here is, although with different dataset created, I am not able to set the chart or tables to pass in their respective value when executing the stored procedure. My best bet now is to duplicate the stored procedure for each chart and tables and name them differently. I hope this is not the only way to go about achieving what i need. Anyone able to shed some light on this? Thanks. Jordan Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26904
  - 21
    - Chart: space between bars of different series It seems there is no space possible between the bars of different series in the chart? I know how to use <PointWidth> to determine the width of my bars, but I would like the bars to stand seperate (not joined) with space in between. -- Callidus Software Designer Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26903
  - 22
    - Date Issue - All Months showing as Jan I recently deployed an updated version of Reporting Services. All reports that rely on displaying stats by month are now showing each month as Jan only. Has anyone any experience of dealing with this problem? Thanks Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26902
  - 23
    - Excel report displays empty subreports Hi everybody, I'm having a problem with excel reports. My report is designed in the following: * Header report * Subreport * and, Master report The master report contains a header and many subreports. Based on what subreport users select, a master report with a header and only selected subreports are displayed to the users. This is working fine when rendering reports in pdf and html. But in excel output, non selected subreports appear as empty in the excel report. Setting the excel report deviceInfo property didn't help in my case devInfo = "<DeviceInfo><RemoveSpace>0.5in</RemoveSpace></DeviceInfo>" Any one know how to solve this problem? Thanks Regards Abdi Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26897
  - 24
    - DB LOOK UP Hello, Is there a way to use something like LOOKUP COMBO in reporting services. What I want to do is, to be able to GO AND LOOK FOR some value from another table in a report.. The report name is mainreport mainreport : [Product Code] 1243 Intervention# LabourCost MaterialCost 43 5$ 3$ 45 7$ 8$ SUBTOTAL #interventions:2 12$ 11$ ---> Can we make a lookup to SALES table where we can find ---> sales QTY of product 1243?? SALES : 50 , 2*100/50 = %4 [Product Code] xxxxx ..... Thank you so much! Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26878
  - 25
    - HOWTO: Install RS2005 (Beta) I need assistance to install RS2005. What software I need (with beta indexes)? What is order of installation? Thanks Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26871
- Next
  - 1
    - Excel Export Does not print Date Hi Guys, I have a date in the report Page header. When i export this report to .pdf it shows the date in the adobe but when i export it to excel file date does not appear plz help me Thanks Chandra Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26867
  - 2
    - Difference Between Query Parameters and Report Parameters Hi Guys, Can somebody explain me cleraly the difference between Query and Report Parameters. Report Parameters r automatically created when u put some variable in a query. 2) One more thing is there a way we can hide query string in the IE as I dont want the users to see the report URL. 3) My Stored Proc expects 2 parameters but I dont want to pass them in the URL string is there any other way I can pass parameters to the report from the front end other than URL strings Many Many Thanks Chandra -- Message posted via http://www.sqlmonster.com Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26865
  - 3
    - multiples charts and tables on the same report from multiple datasets Hi, I am trying to use Reporting services toi create a report with a number of charts and tables from the same datasource but multiple datasets. When I created a table and dragged the data fields into the column it is =First(Fields!OrderID.Value, "DataSet1") It keeps repeating until the end of rows where in the dataset I used top5 SQL what should be the correct way to do it? Also I am wondering if I can modify the color of and space between bar chart items. Thank you in advance, Sunny Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26863
  - 4
    - SP2 Beta does not fix Excel visibility problems. With RS SP1, setting the Hidden attribute of a table, or row, or matrix, or rectangle, etc works as expected when rendered using html, but when rendered to excel, these objects could not be hidden. This seems to be a well known problem. I tried SP2 Beta Version 8.00.902.00 and found that excel rendering has become completely unstable with respect to setting the hidden attribute. My tests have indicated the following: * Pre SP2 Excel would never honor the hidden attribute. Now it sometimes sorta does. * I cant figure out the pattern of what happens when I set tables to hidden using formulas. It works sometimes, and sometimes not. * I set the hidden attribute of a simple rectangle in response to a formula based on a parameter and it seems to work consistantly. For example: <Hidden>=iif(Parameters!Color.value.indexof("green")>=0 ,false,true) * I tried two rectangles, one after the other and put a table in each. If I try to hide the top rectangle, and show the bottom one it works. If I try to show the top one, and hide the bottom one, then space is taken up for the top table, and some(!?) of its grid lines are displayed, but no data, and the bottom rectangle/table is not displayed. yikes. Now I've just got to figure out how to uninstall the beta...I wonder if I can just rerun sp1, or maybe just replace the excelrendering dlls with the ones from sp1... Cheers, Jeff Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26855
  - 5
    - Unstable Permissions? Hello, I've been using Report Services for several months with no problems, suddenly I started getting 401 unauthorized errors with no changes on my part. The strange part is that it works fine for an hour or two, then quits. If I restart IIS the problem goes away, but there are several web applications on the same server and would prefer to not restart it several times a day. Any ideas? Jeremy Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26843
  - 6
    - Using an ADO.NET DataSet as a Reporting Services Data Source I found this article on the MSDN library written by Christ Carpentiere - Sept 2004 and deployed the extension to the Report Server. I noticed that the XSD Configuration file is hardcoded in the Report Server Config file. Has any one used this technique to deploy mulitple reports and how? Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26840
  - 7
    - HOWTO: Get page count when rendering PDF We have a Windows application that renders reports via the MS Reporting Services web service. We are rendering these reports in PDF. As we retrieve the reports we save them to the local disk. Before retrieving the next report, we need to know how many pages were rendered in the current report. We are currently rendering the report as result = _RS.Render("MyReportName","PDF",null,null,parameters,null,null,out encoding,out mimetype,out parametersUsed,out warnings,out streamids); In this case, the streamids is empty (i.e. streamids.Length == 0). It seems that the only way to get a populated streamid array is to render the reporty specifying a format of IMAGE (at least this is the only format illustrated in the page count examples we've found). result = _RS.Render("MyReportName","IMAGE",null," <DeviceInfo><OutputFormat>EMF</OutputFormat></DeviceInfo>", parameters,null,null,out encoding,out mimetype,out parametersUsed,out warnings,out streamids); We've tried result = _RS.Render("MyReportName","PDF",null," <DeviceInfo><OutputFormat>EMF</OutputFormat></DeviceInfo>", parameters,null,null,out encoding,out mimetype,out parametersUsed,out warnings,out streamids); but, once again, the streamids.Length == 0. 1) Is there a way to determine the number of pages a report has when we render it PDF? 2) If we have to make the second call specifying an IMAGE format, does this execute the entire report again? Though I suspect so, I am hoping that perhaps the report is somehow cached for some length of time. Thanks, Chris Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26837
  - 8
    - Query very slow when executed using Reporting Services Hello, I have a dataset that uses a stored procedure as the data source. In the query analyzer, it takes just over 2 seconds to execute. However, in the execute query mode in the Visual Studio reports designer, the query takes several minutes. The report, when run from the server, also takes a very long time to complete. There are only 4 parameters, two varchar(2) and two datetime fields. The particular query I am running returns 12 rows. There are no filters applied to the report, not that would affect the query in the VS reports designer. Does anybody have any ideas on how to improve the performance? Thank you, Brian Takita Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26836
  - 9
    - Error Running With SharePoint This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C53602.65E443A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Installed Reporting Services on the same box as SharePoint. Followed instructions in the article: Troubleshooting a Side-by-Side Installation of Reporting Services and = Windows SharePoint Services http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSinst= all/htm/gs_installingrs_v1_9fdy.asp However when I got to the last step to activate the site using the = RSactivate utility I got the following error: "The Report Server Web service has not generated a public key. The = service may not have started successfully. Check the log files for more = information" I checked the logs (I didn't write it down or save it) but saw a message = about the "client is not a local admin" So I went into Service Manager and opened up Reporting Services and = changed the login. I tried both an administrator user account and a = local services account. Now when I run the RSActivate utility I get the = error: "Failure starting the web service: The local NT Service is disabled 0x80090005" However the Reporting Service is running as I can tell from Service = Manager. Help!!!! Alan ------=_NextPart_000_0006_01C53602.65E443A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Installed Reporting Services on the = same box as=20 SharePoint.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Followed instructions in the = article:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Troubleshooting a Side-by-Side = Installation of=20 Reporting Services and Windows SharePoint Services</FONT></DIV> <DIV><FONT face=3DArial size=3D2><A=20 href=3D"http://msdn.microsoft.com/library/default.asp?url=3D/library/en-u= s/RSinstall/htm/gs_installingrs_v1_9fdy.asp">http://msdn.microsoft.com/li= brary/default.asp?url=3D/library/en-us/RSinstall/htm/gs_installingrs_v1_9= fdy.asp</A></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>However when I got to the last step to = activate the=20 site using the RSactivate utility I got the following = error:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>"The Report Server Web service has not = generated a=20 public key.  The service may not have started successfully.  = Check the=20 log files for more information"</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I checked the logs (I didn't write it = down or save=20 it) but saw a message about the "client is not a local = admin"</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>So I went into Service Manager and = opened up=20 Reporting Services and changed the login.  I tried both an = administrator=20 user account and a local services account.  Now when I run the = RSActivate=20 utility I get the error:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>"Failure starting the web = service:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>The local NT Service is = disabled  =20 0x80090005"</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>However the Reporting Service is = running as I can=20 tell from Service Manager.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Help!!!!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Alan</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C53602.65E443A0-- Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26832
  - 10
    - Problem with Search on Newsgroup When searching, I only get results back for this month (March 2005)!! Has anyone else encountered problems with the search tool on the newsgroup?? Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26830
  - 11
    - Report Server serious issues!!!! I am having serious issues with RS. i have installed the SP1 and I am able to launch the main reports page, i.e. http://myserver/Reports and it re-directs to http://myserver/Reports/Pages/Folder.aspx. Here i can see all the various options etc. Now I created a sample connection as per the \MSSQL\Reporting Services\Samples\Reports\Readme.htm file. The problem is I am unable to upload any RDL file. It tries to do it, and then comes back with this message: "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. " I also tried using the rs -i PublishSampleReports.rss -s http://gacorwks7047a/reportserver -v parentFolder="Sample Reports" method but that too times out on me. "The operation has timed-out. The operation has timed-out. The operation has timed-out. The operation has timed-out. The operation has timed-out." The other wierd part is that from VS .net2003 when i open a Report wizard and i can create new shared data source OK (for example local- pubs using windows authentication), but then when i create the new report and select the same shared data source i get "A connection cannot be made to the database. Set and check the connection string.".. please help!!! thanx much -r Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26826
  - 12
    - Converting RS 2000 Project to RS 2005 I finally got a virtual machine setup with Server 2003, SQL 2005 Feb 2005 CTP, and VS 2005 Feb 2005 CTP. Backed up the database that I used in VS 2003 for my RS 2000 project and restored it in SQL 2005 (no issues with that). Then I opened up the RS 2000 project in VS 2005 and it brought up a wizard to convert the solution into VS 2005 format. Once that was complete the layout view for the report looked fine and all of the datasets were pulling back the proper data. Whenever I try to preview or build the solution the following error is displayed: Cannot call Invoke or BeginInvoke on a control until the window handle has been created. Not sure what this means or what I need to do to fix it. I have verified that RS 2005 is up and running correctly by running some of the AdventureWorks samples in the Report Manager. Hopefully this is not a sign on how difficult it will be to move RS 2000 projects over to RS 2005. Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26825
  - 13
    - Creating Rept Using View I need to create a rept using a view. No Views show up on the list when I clicked on the View tab on "Add Table" window. I have 4 views and none of them show up. Do I need to do anything else to have the views show up? Please help Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26824
  - 14
    - Jump to URL and pass parameter I would like to jump to a URL like UPS and pass in a value (tracking number). Is there a way to do this under the "action" of the field I would like to pass? "Jump to Report" allows parameters but "Jump to URL" does not resolve the actual field values. -- Thanks in advance, John Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26823
  - 15
    - Page Numbers Do you know how to reset the page count within a report? I know you can do it in access reports and reset the page number in a group. But I have not been able to find anything on how to do it in visual studio. I've searched Microsoft MSDN site and couldn't find anything. Anybody got any direction on this? Thanks! Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26822
  - 16
    - Error Generating PDF w/ SP1 Hi, We seem to be getting the following error when generating reports only if the sub report spans multiple pages. Reporting Services Error -------------------------------------------------------------------------------- Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Object reference not set to an instance of an object. I've checked the language version for the reprot in the RDL = en-US, so that doesn't seem to be the problem. Thanks in advance for your help. Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26818
  - 17
    - Bug in Report Designer - can anyone reproduce? I think I've discovered a serious bug with the Report Designer, which causes devenv.exe to take up 100% CPU and skyrocket in memory usage. Here's how I got to it: -Create a report with three parameters: The first two are dates (start date and end date for a date range) and the third is a String (employee name). -Create a query to auto-populate both date fields. -Create a query to fill the String parameter with values that are dependant on the first two date parameters (return employees that were active during the range of the two parameters, for instance). This works okay when deployed, but in Preview Mode in Visual Studio, after changing either of the Date parameters from their default value, VS seems to get stuck in an infinite loop when attempting to re-populate the third parameter with employee names. Can anyone reproduce this? Thanks, Matthew Brown Viecore Inc Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26814
  - 18
    - Report renderer as class library? For those of us who want to integrate reports in to an existing web application, it would be very convenient if one could render reports using a class library rather than via a web service. Does anyone know if there are any plans to enable this in future releases of Reporting Services? Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26811
  - 19
    - Bug in Report Designer - can anyone reproduce? I think I've discovered a serious bug with the Report Designer, which causes devenv.exe to take up 100% CPU and skyrocket in memory usage. Here's how I got to it: -Create a report with three parameters: The first two are dates (start date and end date for a date range) and the third is a String (employee name). -Create a query to auto-populate both date fields. -Create a query to fill the String parameter with values that are dependant on the first two date parameters (return employees that were active during the range of the two parameters, for instance). This works okay when deployed, but in Preview Mode in Visual Studio, after changing either of the Date parameters from their default value, VS seems to get stuck in an infinite loop when attempting to re-populate the third parameter with employee names. Can anyone reproduce this? Thanks, Matthew Brown Viecore Inc Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26809
  - 20
    - Subscriptions not running Hi! I have seen many different questions about problems with the subscriptions and we have tested the solutions and we are still having the problem. We can create subscriptions but they don't seem to actually run. We have checked the configuration and we have checked to make sure we are using the System account and we have checked to make sure the service is actually running. Any other ideas? Thank you for any help! -- Jenny Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26808
  - 21
    - date expression for param - start of current month I have a report that I want to run for the current month. I have two params, datestart and dateend and am looking for an expression to use that will calculate the start of the current month. I have been playing with datediff and dateadd but can't figure it out! Please help Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26807
  - 22
    - Visual Studio Undo Setting When I hit 'Undo', it doesn't undo one change at a time, but it seems to back out several changes at once, which is especially annoying when I'm trying to undo a typo. Has anyone else experienced this? Is there a VS setting that would allow me to change the Undo buffer? Thanks, Mike Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26805
  - 23
    - Reporting Services CAn you do a cross tab query in RS. I don't think you can. If not, I can do it in access. just thought I'd ask Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26801
  - 24
    - Incomplete Exports Hello, I hope that someone will be able to help us with a perplexing issue. When generating a reporting in either Excel or PDF every 5th report or so, we will get a corrupt / damaged file. The issue is repeatable but not reproducible. The same report will fail a random number of times in a row, but will then execute correctly. It appears that the corrupt file is really truncated. The reports are big, but we don't have any very long columns or many rows. However, they do contain quite a few charts. The final file size in excel is ~1.4 MBs. We have been unable to locate any errors in the logs. The web site behaves like it successfully created the report. I've watched the memory usage and it does not appear to be memory bound or disk bound. I'm hoping for any suggestions on avenues to try or finding someone with a similar problem. Thank You, --Chris Swinefurth MID Technologies, Inc. Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26800
  - 25
    - point labels on charts How can I get the point labes on a chart to appear inside the bar. Tag: Bug in Tutorial: Creating an Ad Hoc Report Application with Report Tag: 26799

The sample code for (MSDN)Tutorial: Creating an Ad Hoc Report Application
with Reporting Services published by Kathrine Lord in November 2004 will not
compile.
Have you tried it?
I think it has no declaration for the variable "conn" in the Public Class
RDLGenerator.

--
DDH

Top