Chart with custom values

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
    - Diffrent colours in same text box Is this possible to givee Diffrent colours in same text box in reporting services if yes I want to know that . thanks Shri Tag: Chart with custom values Tag: 55666
  - 2
    - Diffrent colours in same text box Is this possible to givee Diffrent colours in same text box in reporting services if yes I want to know that . thanks Shri Tag: Chart with custom values Tag: 55665
  - 3
    - execute 'view report' from javascript Hi, I have a report where i can drill through to account forms. when i change something on that form, i want to refresh the report when i save and close the account form. How can i execute the 'view report' button? A page reload resets my parameters and is thus not an option. I hope i made myself clear. Just ask me if you want more info. Thanx Tag: Chart with custom values Tag: 55664
  - 4
    - Migration from ComponentOne Reporting Service to SQL 2005 RS Hi, Is it possible to migrate from Component RS to SQL 2005 RS? Tag: Chart with custom values Tag: 55660
  - 5
    - install of sql 2005 RS on SQL 2000 machine Hi, This should be a quick for you. I am wanting to install SQL 2005 on the same W2003 Server as SQL 2000. Your newsgroups to date show that this is possible and that SQL 2005 should be set up as a Named Instance. My quesion relates to the install of RS2005. When SQL 2005 is setup and I now want to install RS2005 does it install as an Upgrade option for RS2000? I do not wish to keep RS2000 so an upgrade is preferable. Or is RS2000 left alone and must be unistalled separately. Any experiences would be appreciated. Thanks. -- Regards, Alan Tag: Chart with custom values Tag: 55656
  - 6
    - Summarize data in a dataset, draw pie from it Hi, I have a question on a summarizing data in a dataset at the RS2005 end, could someone shed some light on this? I have created a RS2005 dataset like below through which a bar chart with two series (PDF, RTF) is populated for EACH day for a given period. Date, DocType, Count ========== ======= ===== 01/01/2006, PDF, 10 01/01/2006, RTF, 20 02/01/2006, PDF, 11 02/01/2006, RTF, 23 03/01/2006, PDF, 09 03/01/2006, RTF, 07 ... ... 31/01/2006, RTF, 17 The bar chart works fine. I would also like to have a pie chart, that shows the total PDF and RTF doccuments for the WHOLE PERIOD, to be populated from this dataset. The problems is to group/summarize 'Count' by 'DocType', so the resulting pie chart has only two slices; one for PDF and another for RTF. Is there a way to do this? Thanks Sur Tag: Chart with custom values Tag: 55655
  - 7
    - Are the Parameters to the Reportviewer object visible? I'm using the ReportViewer object to pass parameters to the report. Dim aParameters(2) As ReportParameter aParameters(0) = New ReportParameter("x", "xxx") aParameters(1) = New ReportParameter("y", "yyy") oReportViewer.ServerReport.SetParameters(aParameters) Are these parameters visible through the URL or otherwise by the user? Thanks. Luis CambustÃ³n Tag: Chart with custom values Tag: 55654
  - 8
    - Fixed Column Position I have a very wide report that the user would like the first two columns to stay in view as you horizontally scroll off to the right. Any Ideas? Tag: Chart with custom values Tag: 55653
  - 9
    - Subscription for individual user I have a common request that I am supprised not to find a solution on MSDN or built-in with SSRS. We need to allow an individual user schedule a report to execute with their selected perameters. Then the user should have a link sent to them but a link that only that user can view. D Graham Tag: Chart with custom values Tag: 55652
  - 10
    - RS 2005 ReportExecutionService ToggleItem method problem This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C68F1E.7C5676F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable (Sorry, this is a re-post via fixed no-spam email alias with my = subscription) Hi,=20 We are building a custom report viewer for our web application for = rendering reports by calling reporting services web services (SOAP over = HTTP). The custom report viewer also perform text replacement to replace any = reference pointing to report server in the output from Render method so = we don't have to make the report server middle-tier public accessible = (As my understanding is built-in report viewer, = Microsoft.Reporting.WebForms.ReportViewer, still requires the report = server be accessible by clients for images, drilldown, drill-through = links) The problem we currently encounter is the = ReportExecutionService.ToggleItem method only toggle items after the = first Render Here is our scenario: Request 1: Build custom RDL Load RDL by calling ReportExecutionService.LoadReportDefinition( ... ) Save the execution ID for later requests Call Render method Perform text replacement to replace all the report server references = with our custom link, which will intercept the requests to report server = middle-tier return the result to client =20 Request 2 (user clicks on the drilldown link) : retrieve the execution ID from the first request get toggle item id from request call ReportExecutionService.ToggleItem( ... ), the method returns true, = which means the item is found Call Render method Perform text replacement to replace all the report server references = with our custom link, which will intercept the requests to report server = middle-tier return the result to client =20 (So far everything works fine) Request 3 (user clicks on another drilldown link) : retrieve the execution ID from the first request get toggle item id from request (different to the request 2) call ReportExecutionService.ToggleItem( ... ), the method returns true, = which means the item is found. Call Render method Perform text replacement to replace all the report server references = with our custom link, which will intercept the requests to report server = middle-tier return the result to client =20 (See same output as request 2 ( item id passed in request 3 is not = expanded)=20 I wrote a console application to demonstrate this behavior=20 (In this console application I used a modified version of = "/AdventureWorks Sample Reports/Company Sales" report by replacing the = shared data source with private data source, which is required when = using LoadReportDefinition source code of console application: using System; using System.Collections.Generic; using System.Text; using System.IO; using PlayRSSAPI.ReportService2005; using PlayRSSAPI.ReportExecution2005; using System.Xml; namespace PlayRSSAPI { class Program { static void Main(string[] args) { ReportingService2005 rs =3D new ReportingService2005(); rs.Credentials =3D = System.Net.CredentialCache.DefaultCredentials; rs.Url =3D = "http://rdserver/reportserver/reportservice2005.asmx"; Property pName =3D new Property(); pName.Name =3D "Name"; Property pDesc =3D new Property(); pDesc.Name=3D"Description"; Property[] properties =3D new Property[2]; properties[0] =3D pName; properties[1] =3D pDesc; // "Copy of Company Sales" is modified version of = "/AdventureWorks Sample Reports/Company Sales" // "Copy of Company Sales" used private datasource instead = of shared datasource so the=20 string reportName =3D "/AdventureWorks Sample Reports/Copy = of Company Sales"; //string reportName =3D "/AdventureWorks Sample = Reports/SalesOrderDetail"; try { byte[] b =3D rs.GetReportDefinition(reportName); MemoryStream strm =3D new MemoryStream(b); XmlDocument doc =3D new XmlDocument(); doc.Load(strm); // potentially we will add some columns into RDL here = ... MemoryStream strmOut =3D new MemoryStream(); doc.Save(strmOut); byte[] rdlOut =3D strmOut.ToArray(); ReportExecution2005.ReportExecutionService res =3D new = ReportExecutionService(); res.Url =3D = "http://rdserver/reportserver/ReportExecution2005.asmx"; res.Credentials =3D = System.Net.CredentialCache.DefaultCredentials; =20 =20 ReportExecution2005.Warning[] warning; ExecutionInfo ei =3D res.LoadReportDefinition(rdlOut, = out warning); string format =3D "HTML4.0"; // "HTML"; string historyID =3D null; string devInfo =3D = @"<DeviceInfo><Toolbar>True</Toolbar><Section>1</Section><HTMLFragment>Fa= lse</HTMLFragment></DeviceInfo>"; =20 string encoding; string mimeType; string extension; string[] streamIDs =3D null; ReportExecution2005.Warning[] warnings =3D null; byte[] rptOut =3D null; bool resToggle =3D false; FileStream stream =3D null; // first render call rptOut =3D res.Render(format, devInfo, out extension, = out encoding, out mimeType, out warnings, out streamIDs); stream =3D File.Create("C:\\Temp\\report.htm", = rptOut.Length); stream.Write(rptOut, 0, rptOut.Length); Console.WriteLine("Result written to the file."); stream.Close(); res =3D null; // we are creating a second ReportExecutionService to = mimic the page transition in web application ReportExecutionService res2 =3D new = ReportExecutionService(); res2.ExecutionHeaderValue =3D new ExecutionHeader(); res2.ExecutionHeaderValue.ExecutionID =3D = ei.ExecutionID; res2.Credentials =3D = System.Net.CredentialCache.DefaultCredentials; =20 resToggle =3D res2.ToggleItem("7"); // expand = "Components" block in the report Console.WriteLine(string.Format("Toggle Item 7 {0} ", = (resToggle?"OK":"Failed"))); resToggle =3D res2.ToggleItem("11"); // expand "2002" = block in the report Console.WriteLine(string.Format("Toggle Item 11 {0} ", = (resToggle?"OK":"Failed"))); =20 // Second Render with 2 items toggled rptOut =3D res2.Render(format, devInfo, out extension, = out encoding, out mimeType, out warnings, out streamIDs); =20 =20 stream =3D = File.Create("C:\\Temp\\report_toggle_7_11.htm", rptOut.Length); stream.Write(rptOut, 0, rptOut.Length); Console.WriteLine("Result written to the file."); stream.Close(); res2 =3D null; // we are creating third ReportExecutionService to mimic = the page transition in web application ReportExecutionService res3 =3D new = ReportExecutionService(); res3.ExecutionHeaderValue =3D new ExecutionHeader(); res3.ExecutionHeaderValue.ExecutionID =3D = ei.ExecutionID; res3.Credentials =3D = System.Net.CredentialCache.DefaultCredentials; resToggle =3D res3.ToggleItem("27"); // expand "2003" = block. Console.WriteLine(string.Format("Toggle Item 27 {0} ", = (resToggle?"OK":"Failed"))); // Third Render, this returns the same result as second = Render call rptOut =3D res3.Render(format, devInfo, out extension, = out encoding, out mimeType, out warnings, out streamIDs); stream =3D = File.Create("C:\\Temp\\report_toggle_7_11_21.htm", rptOut.Length); stream.Write(rptOut, 0, rptOut.Length); Console.WriteLine("Result written to the file."); stream.Close(); =20 } catch(Exception ex) { Console.WriteLine(ex.ToString()); } Console.Read(); } } } ------=_NextPart_000_0008_01C68F1E.7C5676F0 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.1830" name=3DGENERATOR> <STYLE></STYLE> </HEAD><FONT face=3DArial><FONT size=3D2> <BODY> <DIV><FONT face=3DTahoma size=3D2><FONT = size=3D2>(Sorry, this is=20 a re-post via fixed no-spam email alias with my=20 subscription)</FONT></FONT></DIV> <DIV><FONT face=3DTahoma size=3D2><FONT size=3D2>Hi, = </FONT></FONT></DIV> <DIV><FONT face=3DTahoma size=3D2><FONT size=3D2>We are building a = custom report=20 viewer for our web application for rendering reports by=20 calling reporting services web services (SOAP over = HTTP).</FONT></DIV> <DIV class=3Dmoz-text-html lang=3Dx-unicode> <DIV><FONT size=3D2>The custom report viewer also perform text = replacement to=20 replace any reference pointing to report server in the output from = Render method=20 so we don't have to make </FONT><FONT size=3D2>the report server = middle-tier=20 public accessible (As my understanding is built-in report viewer,=20 Microsoft.Reporting.WebForms.ReportViewer, still requires the report = server be=20 accessible by clients for images, drilldown, drill-through = links)</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>The problem we currently encounter is the=20 ReportExecutionService.ToggleItem method only toggle items after the = first=20 Render</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Here is our scenario:</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Request 1:</FONT></DIV> <DIV><FONT size=3D2>Build custom RDL</FONT></DIV> <DIV><FONT size=3D2>Load RDL by calling=20 ReportExecutionService.LoadReportDefinition( ... )</FONT></DIV> <DIV><FONT size=3D2>Save the execution ID for later = requests</FONT></DIV> <DIV><FONT size=3D2>Call Render method</FONT></DIV> <DIV><FONT size=3D2>Perform text replacement to replace all the report = server=20 references with our custom link, which will intercept the requests = to=20 report server middle-tier</FONT></DIV> <DIV><FONT size=3D2>return the result to client  </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Request 2 (user clicks on the drilldown link) = :</FONT></DIV> <DIV><FONT size=3D2>retrieve the execution ID from the first = request</FONT></DIV> <DIV><FONT size=3D2>get toggle item id from request</FONT></DIV> <DIV><FONT size=3D2>call ReportExecutionService.ToggleItem( ... ), the = method=20 returns true, which means the item is found</FONT></DIV> <DIV><FONT size=3D2> <DIV><FONT size=3D2>Call Render method</FONT></DIV> <DIV><FONT size=3D2>Perform text replacement to replace all the report = server=20 references with our custom link, which will intercept the requests = to=20 report server middle-tier</FONT></DIV> <DIV><FONT size=3D2>return the result to client  </FONT></DIV> <DIV>(So far everything works fine)</DIV> <DIV> </DIV> <DIV>Request 3 (user clicks on another drilldown link) :</DIV> <DIV> <DIV><FONT size=3D2>retrieve the execution ID from the first = request</FONT></DIV> <DIV><FONT size=3D2>get toggle item id from request (different to the = request=20 2)</FONT></DIV> <DIV><FONT size=3D2>call ReportExecutionService.ToggleItem( ... ), the = method=20 returns true, which means the item is found.</FONT></DIV> <DIV><FONT size=3D2> <DIV><FONT size=3D2>Call Render method</FONT></DIV> <DIV><FONT size=3D2>Perform text replacement to replace all the report = server=20 references with our custom link, which will intercept the requests = to=20 report server middle-tier</FONT></DIV> <DIV><FONT size=3D2>return the result to client  </FONT></DIV> <DIV>(See same output as request 2 ( item id passed in request 3 is not=20 expanded) </DIV> <DIV> </DIV> <DIV> </DIV> <DIV>I wrote a console application to demonstrate this behavior </DIV> <DIV>(In this console application I used a modified version of = "/AdventureWorks=20 Sample Reports/Company Sales" report by replacing the shared data source = with=20 private data source, which is required when using = LoadReportDefinition</DIV> <DIV> </DIV> <DIV>source code of console application:</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>using System;<BR>using System.Collections.Generic;<BR>using=20 System.Text;<BR>using System.IO;</DIV> <DIV> </DIV> <DIV>using PlayRSSAPI.ReportService2005;<BR>using=20 PlayRSSAPI.ReportExecution2005;<BR>using System.Xml;</DIV> <DIV> </DIV> <DIV>namespace PlayRSSAPI<BR>{<BR>    class=20 Program<BR>    = {<BR>       =20 static void Main(string[] = args)<BR>       =20 {<BR>           =20 ReportingService2005 rs =3D new=20 ReportingService2005();<BR>       &nbs= p;   =20 rs.Credentials =3D=20 System.Net.CredentialCache.DefaultCredentials;<BR>   &nbsp= ;       =20 rs.Url =3D "<A=20 href=3D"http://rdserver/reportserver/reportservice2005.asmx">http://rdser= ver/reportserver/reportservice2005.asmx</A>";</DIV> <DIV> </DIV> <DIV>            = Property=20 pName =3D new=20 Property();<BR>         &nbs= p; =20 pName.Name =3D "Name";</DIV> <DIV> </DIV> <DIV>            = Property=20 pDesc =3D new=20 Property();<BR>         &nbs= p; =20 pDesc.Name=3D"Description";</DIV> <DIV> </DIV> <DIV>           =20 Property[] properties =3D new=20 Property[2];<BR>         &nb= sp; =20 properties[0] =3D=20 pName;<BR>          &nb= sp;=20 properties[1] =3D pDesc;</DIV> <DIV> </DIV> <DIV>            = // "Copy=20 of Company Sales" is modified version of "/AdventureWorks Sample = Reports/Company=20 Sales"<BR>          &nb= sp; //=20 "Copy of Company Sales" used private datasource instead of shared = datasource so=20 the = <BR>           =20 string reportName =3D "/AdventureWorks Sample Reports/Copy of Company=20 Sales";<BR>          &n= bsp;=20 //string reportName =3D "/AdventureWorks Sample=20 Reports/SalesOrderDetail";<BR>       &= nbsp;   =20 try<BR>           = =20 {<BR>           &n= bsp;   =20 byte[] b =3D=20 rs.GetReportDefinition(reportName);<BR>     &nbs= p;         =20 MemoryStream strm =3D new=20 MemoryStream(b);<BR>        &nbsp= ;      =20 XmlDocument doc =3D new=20 XmlDocument();<BR>         &= nbsp;     =20 doc.Load(strm);</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 // potentially we will add some columns into RDL here=20 ...<BR>           =     =20 MemoryStream strmOut =3D new=20 MemoryStream();<BR>         =       =20 doc.Save(strmOut);</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 byte[] rdlOut =3D strmOut.ToArray();</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 ReportExecution2005.ReportExecutionService res =3D new=20 ReportExecutionService();<BR>       &n= bsp;       =20 res.Url =3D "<A=20 href=3D"http://rdserver/reportserver/ReportExecution2005.asmx">http://rds= erver/reportserver/ReportExecution2005.asmx</A>";<BR>   &n= bsp;           =20 res.Credentials =3D System.Net.CredentialCache.DefaultCredentials;</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 <BR>           &nb= sp;   =20 <BR>           &nb= sp;   =20 ReportExecution2005.Warning[]=20 warning;<BR>          &= nbsp;    =20 ExecutionInfo ei =3D res.LoadReportDefinition(rdlOut, out = warning);</DIV> <DIV> </DIV> <DIV><BR>          &nbs= p;    =20 string format =3D "HTML4.0"; //=20 "HTML";<BR>          &n= bsp;    =20 string historyID =3D=20 null;<BR>          &nbs= p;    =20 string devInfo =3D=20 @"<DeviceInfo><Toolbar>True</Toolbar><Section>1&l= t;/Section><HTMLFragment>False</HTMLFragment></DeviceIn= fo>";</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 <BR>           &nb= sp;   =20 string=20 encoding;<BR>          =      =20 string=20 mimeType;<BR>          =      =20 string=20 extension;<BR>         &nbsp= ;     =20 string[] streamIDs =3D=20 null;<BR>          &nbs= p;    =20 ReportExecution2005.Warning[] warnings =3D null;</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 byte[] rptOut =3D=20 null;<BR>          &nbs= p;    =20 bool resToggle =3D=20 false;<BR>          &nb= sp;    =20 FileStream stream =3D null;</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 // first render=20 call<BR>          &nbsp= ;    =20 rptOut =3D res.Render(format, devInfo, out extension, out encoding, out = mimeType,=20 out warnings, out=20 streamIDs);<BR>         &nbs= p;     =20 stream =3D File.Create("C:\\Temp\\report.htm",=20 rptOut.Length);<BR>         =       =20 stream.Write(rptOut, 0,=20 rptOut.Length);<BR>         =       =20 Console.WriteLine("Result written to the=20 file.");<BR>          &= nbsp;    =20 stream.Close();<BR>         =       =20 res =3D null;</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 // we are creating a second ReportExecutionService to mimic the page = transition=20 in web=20 application<BR>         &nbs= p;     =20 ReportExecutionService res2 =3D new=20 ReportExecutionService();<BR>       &n= bsp;       =20 res2.ExecutionHeaderValue =3D new=20 ExecutionHeader();<BR>        &nb= sp;      =20 res2.ExecutionHeaderValue.ExecutionID =3D=20 ei.ExecutionID;<BR>         =       =20 res2.Credentials =3D=20 System.Net.CredentialCache.DefaultCredentials;<BR>   &nbsp= ;           =20 <BR>           &nb= sp;   =20 resToggle =3D res2.ToggleItem("7");   // expand "Components" = block in=20 the=20 report<BR>          &nb= sp;    =20 Console.WriteLine(string.Format("Toggle Item 7 {0} ",=20 (resToggle?"OK":"Failed")));<BR>      &nbsp= ;        =20 resToggle =3D res2.ToggleItem("11");  // expand "2002" block in the = report<BR>          &nb= sp;    =20 Console.WriteLine(string.Format("Toggle Item 11 {0} ",=20 (resToggle?"OK":"Failed")));<BR>      &nbsp= ;        =20 <BR>           &nb= sp;   =20 // Second Render with 2 items=20 toggled<BR>          &n= bsp;    =20 rptOut =3D res2.Render(format, devInfo, out extension, out encoding, out = mimeType,=20 out warnings, out=20 streamIDs);<BR>         &nbs= p;     =20 <BR>           &nb= sp; =20 <BR>           &nb= sp;   =20 stream =3D File.Create("C:\\Temp\\report_toggle_7_11.htm",=20 rptOut.Length);<BR>         =       =20 stream.Write(rptOut, 0,=20 rptOut.Length);<BR>         =       =20 Console.WriteLine("Result written to the=20 file.");<BR>          &= nbsp;    =20 stream.Close();<BR>         =       =20 res2 =3D null;</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 // we are creating third ReportExecutionService to mimic the page = transition in=20 web=20 application<BR>         &nbs= p;     =20 ReportExecutionService res3 =3D new=20 ReportExecutionService();<BR>       &n= bsp;       =20 res3.ExecutionHeaderValue =3D new=20 ExecutionHeader();<BR>        &nb= sp;      =20 res3.ExecutionHeaderValue.ExecutionID =3D=20 ei.ExecutionID;<BR>         =       =20 res3.Credentials =3D = System.Net.CredentialCache.DefaultCredentials;</DIV> <DIV> </DIV> <DIV>           &n= bsp;   =20 resToggle =3D res3.ToggleItem("27");  // expand "2003"=20 block.<BR>          &nb= sp;    =20 Console.WriteLine(string.Format("Toggle Item 27 {0} ",=20 (resToggle?"OK":"Failed")));<BR>      &nbsp= ;        =20 // Third Render, this returns the same result as second Render=20 call<BR>          &nbsp= ;    =20 rptOut =3D res3.Render(format, devInfo, out extension, out encoding, out = mimeType,=20 out warnings, out streamIDs);</DIV> <DIV> </DIV> <DIV><BR>          &nbs= p;    =20 stream =3D File.Create("C:\\Temp\\report_toggle_7_11_21.htm",=20 rptOut.Length);<BR>         =       =20 stream.Write(rptOut, 0,=20 rptOut.Length);<BR>         =       =20 Console.WriteLine("Result written to the=20 file.");<BR>          &= nbsp;    =20 stream.Close();<BR>         =       =20 <BR>           =20 }<BR>           =20 catch(Exception=20 ex)<BR>           = =20 {<BR>           &n= bsp;   =20 Console.WriteLine(ex.ToString());<BR>      =      =20 }</DIV> <DIV> </DIV> <DIV>           =20 Console.Read();</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV>        }<BR>   =20 }<BR>}<BR></DIV> <DIV> </DIV></FONT></DIV></DIV></FONT></DIV></DIV></FONT> <DIV> </DIV></BODY></HTML></FONT></FONT> ------=_NextPart_000_0008_01C68F1E.7C5676F0-- Tag: Chart with custom values Tag: 55651
  - 11
    - Matrix and subtotal Hello, I have a matrix table and sub total in the matrix. what is hte option to set differen color for the subtotal. I know I can set differen color on " Total" but it's not set for the subtotal result Tag: Chart with custom values Tag: 55648
  - 12
    - hiding matrix subtotals I am looking for a way to hide the subtotal columns/rows in a matrix under certain conditions. It appears that this is an all or nothing and you don't get any options. The only information I've found so far of any help is this: http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/166a05fa4101481e/b4bcac538e10187c?q=matrix+subtotal&rnum=3#b4bcac538e10187c Does anyone know a better way of hiding the subtotals? Thanks! Curtis Tag: Chart with custom values Tag: 55646
  - 13
    - PROBLEM: Report column is spilling over to another page Hi all, I'm trying to resolve a problem with my report. I am using a Table element, and I'm using fixed width columns. When I preview the report in my development environment, I get a normal looking report... 4 pages with all the proper headers and columns in their correct locations. When I run the report through my ASP.NET application and stream the rendered PDF through my web application, the report rendering is wrong. On the 1st page, where the final column on the right should be visible on the first page, spills onto a 2nd page, where it's all by itself. The 3rd page of the report shows all of the columns, but no header, and then the 4th and 5th pages resemble the 1st and 2nd page, and the 6th and 7th pages render like the 1st and 2nd pages. I have tried to reasonably squish the columns, to no avail, and the only way I could have all the columns show on one page would be to squish the first column very small so it's unusable. My report is 8" wide, and I have 0.25" margins on the left and right hand sides. My main table is 8" wide, and when I make it smaller, there's no change... I still get the problem. I have tried everything I can think of to try to make this work, but I am now officially stumped. I am using SQL Server 2000 Reporting Services. Can anyone help? Any thoughts? Here's the code I use to render the report: Private Function GetReport(ByVal strReportPath As String, ByVal strReportFormat As String, ByVal parameters As ParameterValue()) Dim data As Byte() rs = New ReportingService rs.Credentials = System.Net.CredentialCache.DefaultCredentials rs.Url = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings.Item("payerdirectories.ReportingServicesWS.ReportingService")) ' create parameters Dim encoding As String Dim mimeType As String Dim parametersUsed As ParameterValue() Dim warnings As Warning() Dim streamIDs As String() data = rs.Render(strReportPath, strReportFormat, Nothing, Nothing, parameters, Nothing, Nothing, encoding, mimeType, parametersUsed, warnings, streamIDs) Return data End Function I can upload my report design XML if need be. Thanks in advance, Cory Koski Tag: Chart with custom values Tag: 55645
  - 14
    - Image from web Hello, I need to insert a image file from the web server URL. As I understand this image should have anonymouse access in the IIS server in order reporting services access this image. Is there other option so this image will not have anonymouse access and only user how run the report will have access to this image ? Tag: Chart with custom values Tag: 55644
  - 15
    - Renders with missing data Anyone seen a situation where a report displays fine using VS.net, but when you go to render via HTML -- the data shows up incomplete, it has blank cells in the table?? Any ideas? Confused as all heck -- Jim Tag: Chart with custom values Tag: 55643
  - 16
    - Required Security for Report Viewer on Windows 2003 SP1 Web Server When trying to run a local report using the RS Report Viewer for VS 2005 we get the below exception when the User Account for the Application Pool we are using is not in the Administrators Group of the web server. Does anybody have any suggestions as to what specific security is needed to use the Report Viewer? Could this be because we built the application as a "Web Project" instead of a "Web Site"? Microsoft.Reporting.WebForms.LocalProcessingException: An error occurred during local report processing. ---> Microsoft.Reporting.DefinitionInvalidException: The definition of the report 'Main Report' is invalid. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred while compiling expressions. Native compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb' could not be found'. --- End of inner exception stack trace --- at AMR.AdvertiserClientList.RefreshReport() in C:\Documents and Settings\god\My Documents\Visual Studio 2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 192 at AMR.AdvertiserClientList.RUNREPORT_Click(Object sender, EventArgs e) in C:\Documents and Settings\God\My Documents\Visual Studio 2005\Projects\AMR\AdvertiserClientList.aspx.vb:line 50 :: InnerException: Microsoft.Reporting.DefinitionInvalidException: The definition of the report 'Main Report' is invalid. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred while compiling expressions. Native compiler return value: '[BC2001] file 'C:\WINDOWS\TEMP\n_rkco4n.0.vb' could not be found'. Tag: Chart with custom values Tag: 55642
  - 17
    - header problem causing error? I have been able to duplicate this multiple times. I have a report (complex ... arent they all) where I could not export to excel w/out getting 4 errors one of which is "non-existing reportitem in the reportitems collection". I have the client name in the header which I am taking from a textbox from a matrix. When I run the report it runs fine and exports to pdf but when I try excel t fails. No idea what field was the problem so I started eliminating things. I changed the expression in the textbox in the header to display a parameter field instead of ReportItems!tbClient.value (which is the textbox with the client name in it) and it worked to export to excel. When I changed that textbox in the heading BACK to the ReportItems! expression ... it failed to export again. So why is that a problem? Tag: Chart with custom values Tag: 55641
  - 18
    - urgent Help:Cannot create Subscription When i click a subscription tape on my report, it show "There are no items to show in this view. Click Help for More information.". This report is me export default report to "rdl" file & change the "fn_getDataRange()" field, then i put it backto use. Tag: Chart with custom values Tag: 55640
  - 19
    - how call stored procedure when user click on report line? have a way to add ability to report, to do somthing, like delete record, by calling Stored procedure when user click on some line within the report? Tag: Chart with custom values Tag: 55638
  - 20
    - Automatic Refresh Stops I have a report that is displayed on an LCD screen 24/7 which functions as a "dashboard". I have the AutoRefresh property set to 30 seconds so the data gets updated. This worked well for a while, but recenlty the report will stop refreshing and just sit there. It happens about once a day. If I close the browser and open a new one, everything starts working again just fine. Does anyone know why a report would stop refreshing like this? Thanks in advance. David Tag: Chart with custom values Tag: 55637
  - 21
    - SSRS2005 on NLB cluster Hello, We installed SSRS2005 on NLB Web cluster. The installation seems to be competed successfully. However, when I'm trying to connect from management studio, I'm getting the following error: "No connection could be made because the target machine actively refused it (System)" I have to say, that Web based UI works with no problem. I assume something should be done within IIS configuration. thanks, Gary Tag: Chart with custom values Tag: 55634
  - 22
    - Error Handling in Reporting Services - NEED INPUTS Hi All, I am using a Report Viewer Control in my .net application (VS 2005). This is the code and the Report1 takes a data from the Analysis Services 2005 Cube. try { ReportViewer1.ReportPath= "Report1"; ReportViewer1.ServerUrl="http://localhost/reportserver"; ReportViewer1.SetParameter("param1",paramvalue1); ReportViewer1.SetParameter("param2",paramvalue2); } catch(Exception ex) { Response.Write(ex.Message); } But if there are any error when processing, for example if the dimension is not there is throws an error "An error has occured", in this case I need to redirect to an error page if any report processing error occurs...... How could i do it. THanks Balaji \ -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200606/1 Tag: Chart with custom values Tag: 55630
  - 23
    - Multi value parameter use in "IN" expression. Hi While writing my latest report i have been trying to use the result of a multi value parameter as the value for a "IN" expression in my SQL query, this does not seem to work, the multi value parameter shows that it has values in it but the "IN" expression wont use them to filter the SQL query. I have since found that the way i am using the Parameter in the SQL is correct but i am now unsure of how the parameter should be set up. Can anyone help? Steve D Tag: Chart with custom values Tag: 55626
  - 24
    - SQL Code Hi, Is there a way that the sql code of the standard reports for IIS (MS SQL Server Report Pack for IIS logs) can be viewed? Fré Tag: Chart with custom values Tag: 55625
  - 25
    - Reporting Service and SQL express 2005 Hello is there any differences between the reporting service in SQL S 2005 express and the Enteprise version (I know that the Enteprise version includes the ReportBuilder). Thanks Pascal Tag: Chart with custom values Tag: 55623
- Next
  - 1
    - Exporting to Excel: RS2000+SP2 Hi, I am using RS2000. My report has a matrix and pie chart which displays values of matrix in pie form. It repeats same for various countries (like paging) Both matrix and pie-chart are embedded in a rectangle. The report is seen properly in html and when exported to .pdf. However when exporting to to excel format, one matrix (Matrix1) and all pie charts (Chart1..ChartN) are displayed on one sheet while all other matrices are seen on other sheets. What is need is--> Matrix1 + Chart1 on sheet1 ........ MatrixN + ChartN on SheetN. I have deployed the reports on RS2000+SP2. Do I need to make any setting unique for excel migration? Or is it a limitation of RS2000..solved in RS2005? TIA, Tanmaya Tag: Chart with custom values Tag: 55621
  - 2
    - Problem installing setup support files Hi, trying to install Reporting Services Enterprise Ed. on a server machine with configuration: - Win 2003 Enterprise with SP1 - MS SQL 2000 Server with SP4 - IIS 6 with ASP.NET 1.1 Problem is that when I execute Setup.exe I receive an message: "Error!" after only 2-3 seconds and thats it! No more info on what the error is or so. Only option for me is to click Cancel and the installation ends. This happens when setup tries to install Microsoft SQL Server Reporting Services Setup Support Files which is the first to happen. Please, anyone have an idea what this can be or even how to track down the error? No errors are reported in Event Viewer. I have rerun aspnet_regiis just in case, witout any result. Thanks. Tag: Chart with custom values Tag: 55620
  - 3
    - Text direction in matrix columns does not work? I'm trying to display column names in a matrix vertically by setting the writingmode property of the matrix textbox to tb-rl, but the box becomes empty when the report is generated. Although this column-textbox has been resized to accomodate the value! This works fine in normal tables and textboxes. I'm using local reports (SQL2000) in a VS2005 environment. Can anyone help me out? Tag: Chart with custom values Tag: 55618
  - 4
    - Changing the FROM in the email on a subscription I need to change the email address that appears as the FROM email on reports that are being delivered via RS2000. I have change the REPLY email and that is working correctly but I can't seem to find where the FROM email is stored. Thanks... Tag: Chart with custom values Tag: 55614
  - 5
    - Microsoft.ReportingServices.ReportRendering.ReportRenderingExcepti I get the following error when attempting to export a large report to PDF. Yet i am able to export the same report data to excel and other formats? Does anyone have any suggestions? Reporting Services Erro -------------------------------------------------------------------------------- Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Invalid parameter used. Thanks in advance... Tag: Chart with custom values Tag: 55613
  - 6
    - ReportServer Windows Service Stops Running Hi All, It seems that for some reason the ReportServer Windows Service stops running. I've been troubleshooting an issue where our reports are not being sent as they should based on the subscriptions configured. I tested the SMTP server, its configuration, and even tested email using TELNET so I know the SMTP is working. Today I noticed that the ReportServer Windows Service was not running. Does anyone know what would cause this service to stop without me stopping it manually? Does configuring/editing subscriptions, editing report datasources, etc. cause this service to stop running? Thanks in advance! Kind regards - Fred Tag: Chart with custom values Tag: 55610
  - 7
    - Using Value/Label in Data-Driven Subscription I use the .Value and .Label for a parameter in my report. I'd like to schedule this report in a data-driven subscription and was wondering if this was possible. How do I pass both (.Value and .Label) values to the subscription? Tag: Chart with custom values Tag: 55609
  - 8
    - Scheduling vs Subscription My client has a common request for a feature built in many other competitive tools yet I am confused as to how I would accomplish this in SSRS: The client works with very sensitive data and therefore will never mail out PDFs or other data without the user interactively asking for a download after authentication of the website. For these reason all reports will be viewed through a secure website and the ReportViewer Control. They would like to allow users to subscribe to have a report with their parameter setting executed at a pre-determined time and day. Then the report could be viewed later only by the person that requested its execution. From what I find neither â??Subscriptionsâ?? nor â??Schedulesâ?? meets these criteria. See the chart below: (* Please not the consideration that the end users will not have access to â??Report Manager.â??) Scheduling collects the data and the user must go through SSRS Security, which is preferred; but, everybody that has permission to the original report can see this snapshot. Subscription has a nice GUI but when the data is collected the only rendering method involve rendering to a file then, SSRS is not involved security is via Exchange or the file system. Surly someone has brought this up before; I am open to suggestions. Tag: Chart with custom values Tag: 55608
  - 9
    - SQL Reporting Services seem to hang on Default values from Query I have a fiarly simple problem with not potentially not so simple a solutions. I have an applicaiton that has a ton of advanced searching capabilities. So instead of adding the parameter search functonality we have built a web front end that will easily handle the searching requirements. The results of this are passed to the viewer control that comes with SRS 2000 samples. This is an IFrame of the Reporting services report viewer. Here is the problem. The results of our search can exceed 2000 characters. In fact it can exceed 8000 characters. Since this is an iFrame integration the parameters are passed via a URL. This means that once you get past 2083 (max url length) the rest of the string is ignored and my reports do not render. To get around this I tried writing the list of project ids to a database table. Inside the report I defined a dataset that has the id of the row where i have the ids stored. I then set the default value for the row to the data set. the dataset can only return one row becuase it based on the row id for the project id list (as varchar field of comma delimited project ids). This works fine when there is only one data set populating the results of one parameter. However now keep in mind that I mentioned that the number of project ids that I am dealing with can be quite lengthy they may not be able to be all returned in one row of datasets. this means that I have to chunk the results set up into two lists of project ids. So now I need to populate to parameters using two datasets that are used to set the default value of the paramteters. ( I know that this sounds crazy and I know that this is not a problem with SQL 2005). Here is the problem. When I enter the row id for the first projects id list I get the comma delimeted list of project ids. When I enter the second row id and then tab out of the field the designer freaks out. It seems that it is caught in some sort of lengthy loop (almost infnite) until VS designer eventually comes back with a big red X in the report viewer. All of the parameters in the parameter list are gone except for the first one. The only way to recover is either to use task manager to kill visual studio or to wait till VS recovers and then you have to close the report and then reopen. So here is the question, I have to be able to support parameters that cannot exceed the limtiation of the SQL 2000 page size. So thus my project ids can not be returned in a single data set. Is there a way to use one dataset with more than one row of data and set the default based on the dataset row? Or is there a way to make the default query method I am using work. finally I have had another set of eyes on the datasets and the parameters to ensure that I am not mixing things up causing some sort of accidental loop. Tag: Chart with custom values Tag: 55607
  - 10
    - reportviewer Hi I'm trying to make a local report ( VS 2005 ) that will be shown by the ReportViewer control. For a data source I'm using my bussines object. I have bound it to the report, and everything works fine, but the problem is with one property of that object that is of List<SubObject> type. I can't manage to bind that list to the table in the report (i know how to bind nested object, but that doesn't work for the list object). For example, if I have this object class SubObject{ public int Id; public string Name; } class BObject{ public int var1; public List<SubObject> subObjects; } what expression must be used to bind subObjects to Table in the report? I've tried to use "=First(Field!subReports.Value.Name)" for one column of that Table, but that doesn't work. Tag: Chart with custom values Tag: 55606
  - 11
    - Report access to external users I need to probive access to users outside the network. Can someone tell me what is the easiest way to do that? This is for SQL Server 2000 reporting services and SQL Server installed on separate servers. The front-end is in the DMZ and the back-end is on the inside network. I want them to be able to access the same reports as the internal users through URL's. Appreciate your ideas. Tag: Chart with custom values Tag: 55605
  - 12
    - Impersonation Account Permissions I'm attempting to call the Reporting Services Web Service from within my application. I've set up anonymous access and set identity impersonate="true" and supplied username and password attributes. If I set the identity to the local administrator, I can call the web services and render reports. If I set the identity to my least-privileged account created for this purpose, the application fails with the following error. Could not load file or assembly 'Microsoft.ReportingServices.Interfaces' or one of its dependencies. Access is denied. === Pre-bind state information === LOG: User = Unknown LOG: DisplayName = Microsoft.ReportingServices.Interfaces (Partial) LOG: Appbase = file:///C:/Projects/ReportPipe/ReportPipe/ LOG: Initial PrivatePath = C:\Projects\ReportPipe\ReportPipe\bin Calling assembly : (Unknown). === LOG: This bind starts in default load context. LOG: Using application configuration file: C:\Projects\ReportPipe\ReportPipe\web.config LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config. LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind). LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportpipe/ec668eaa/7af1073c/Microsoft.ReportingServices.Interfaces.DLL. LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportpipe/ec668eaa/7af1073c/Microsoft.ReportingServices.Interfaces/Microsoft.ReportingServices.Interfaces.DLL. LOG: Attempting download of new URL file:///C:/Projects/ReportPipe/ReportPipe/bin/Microsoft.ReportingServices.Interfaces.DLL. LOG: Using application configuration file: C:\Projects\ReportPipe\ReportPipe\web.config LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config. LOG: Post-policy reference: Microsoft.ReportingServices.Interfaces, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated. I've tried to diagnose the problem using the security event log and FileMon, but I've had no luck. What permissions do I need to assign to my least-privileged account to make the connection? Tag: Chart with custom values Tag: 55604
  - 13
    - Top N Filter on ties I want to show the top 5, but if there's a tie in the value, it will 5+. Is there anyway in the filter to show just 5 and randomly cut it off, because sometimes i will get 20-30 values for my data. Tag: Chart with custom values Tag: 55601
  - 14
    - Forms authentication error in RS 2005 Hi I am implementing forms authentication based on the MSDN article.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp i got steps working for register the user,logging successful,when redirecting the url.i am getting this error. The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help i pasted part of the log file.can anyone suggest where i am going in a wrong way Configuration file. aspnet_wp!library!9!6/12/2006-08:33:14:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. aspnet_wp!library!9!6/12/2006-08:33:14:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. aspnet_wp!library!9!6/12/2006-08:33:14:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. aspnet_wp!library!9!6/12/2006-08:33:14:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. aspnet_wp!resourceutilities!9!6/12/2006-08:33:14:: i INFO: Reporting Services starting SKU: Developer aspnet_wp!resourceutilities!9!6/12/2006-08:33:14:: i INFO: Evaluation copy: 0 days left aspnet_wp!runningjobs!9!6/12/2006-08:33:15:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds aspnet_wp!runningjobs!9!6/12/2006-08:33:15:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds aspnet_wp!runningjobs!9!6/12/2006-08:33:15:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds aspnet_wp!runningjobs!9!6/12/2006-08:33:15:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds aspnet_wp!library!7!6/12/2006-08:34:15:: i INFO: Catalog SQL Server Edition = Developer aspnet_wp!library!a!06/12/2006-08:36:15:: i INFO: Call to GetPermissions:/Unschedules aspnet_wp!library!a!06/12/2006-08:36:15:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., Report server extension Forms does not implement IExtension interface.; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. aspnet_wp!extensionfactory!a!06/12/2006-08:36:17:: e ERROR: Exception caught instantiating Forms report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateAndInitializeExtensionInstance(Extension extConfig). aspnet_wp!library!a!06/12/2006-08:36:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., Could not load Authorization extension; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. Thanks Tag: Chart with custom values Tag: 55598
  - 15
    - Report Server Install - I Need Help... Baby steps I guess... I did a synchiwam and can now get to the IIS report server page but with the following error, any thoughts? [ExternalException (0x5): Cannot execute a program. The command being executed was "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig @"c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline".] The full error follows my sig... Thanks Travis Server Error in '/ReportServer' Application. -------------------------------------------------------------------------------- Cannot execute a program. The command being executed was "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig @"c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline". Description: An unhandled exception occurred during compilation using the CodeDomProvider 'Microsoft.CSharp.CSharpCodeProvider'. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.ExternalException: Cannot execute a program. The command being executed was "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig @"c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline". 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: [ExternalException (0x5): Cannot execute a program. The command being executed was "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig @"c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET Files\reportserver\94eb9a55\49df36c9\6ylzogtc.cmdline".] System.CodeDom.Compiler.Executor.ExecWaitWithCaptureUnimpersonated(IntPtr userToken, String cmd, String currentDir, TempFileCollection tempFiles, String& outputName, String& errorName, String trueCmdLine) +2050 System.CodeDom.Compiler.Executor.ExecWaitWithCapture(IntPtr userToken, String cmd, String currentDir, TempFileCollection tempFiles, String& outputName, String& errorName, String trueCmdLine) +260 System.CodeDom.Compiler.CodeCompiler.Compile(CompilerParameters options, String compilerDirectory, String compilerExe, String arguments, String& outputFile, Int32& nativeReturnValue, String trueArgs) +383 System.CodeDom.Compiler.CodeCompiler.FromFileBatch(CompilerParameters options, String[] fileNames) +548 System.CodeDom.Compiler.CodeCompiler.FromDomBatch(CompilerParameters options, CodeCompileUnit[] ea) +428 System.CodeDom.Compiler.CodeCompiler.FromDom(CompilerParameters options, CodeCompileUnit e) +90 System.CodeDom.Compiler.CodeCompiler.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromDom(CompilerParameters options, CodeCompileUnit e) +37 System.Web.Compilation.BaseCompiler.GetCompiledType() +227 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 Tag: Chart with custom values Tag: 55597
  - 16
    - Date Conversion I need to convert a UTC date to DATETIME format. The date field in question comes from an Active Directory object, which stores dates as "the number of 100 nanosecond intervals since January 1, 1601 (UTC)" in an 8-byte field (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adschema/adschema/a_accountexpires.asp). Is there any way to do this using, for example, a SQL function? I know that might seem like something best done outside of SQL Server, but I need this answer anyway. Thanks! Tag: Chart with custom values Tag: 55595
  - 17
    - How to migrate ReportServer database from RS2000 to RS2005 Hi, BOL 2005 topic "Migrating report services" says that it is possible to restore old, RS2000 ReportServer database to new RS2005. When I try to Upgrade old ReportServer database by RS Configuration Manager, I get error "There was a problem applying the database upgrade script". What is wrong with Upgrade? Thanks in advance Nikola Milic Tag: Chart with custom values Tag: 55582
  - 18
    - Color of graphs Hi, Is it possible to change the colors of the graphs? Specially the series? Fré Tag: Chart with custom values Tag: 55578
  - 19
    - Reports with fixed position elements Hi, I am having a problem with my report. I would like to display this way -------------------------------------------------------------------------------------------------- <Main Report> Employee Name: XXX Employee Address: xxxx --------------------------------------------------------------------------------------------- <Subreport consisting of 2 tables> Code / Description / Amount ! Code / Description / Amount XXX XXXXXXX xxxxxx ! XXX XXXXXXXX xxxxxx XXX XXXXXXX xxxxxx ! XXX XXXXXXXX xxxxxx ----------------------------------------------------------------------------------------------- Total xxxx xxxx However, since the data region for the subreport are tables, they almost always do not have the same height. I would like to set a maximum height for the table rows where the rows that will not fit will continue on the next page. Is this possible? In other words, I need to have the table totals exactly on the 6 inch mark of the report. How can I do this? Also, I need to be able to print to a pre-printed form, if I have to (hence the exact positioning) Thanks for your help. Regards Tag: Chart with custom values Tag: 55575
  - 20
    - Reporting Services in Multi Domain Enviorment IÂ´m having problems with my RS. It was installed in a domain, we can call it DOMAIN1 and it was working flawless, because of a company merge we had to start migrating users from DOMAIN1 to a new domain, we will call it DOMAIN2. Because i have users in DOMAIN1 and DOMAIN2, iÂ´m having problems with the security, all users defined in se security as DOMAIN2\XXXX will not be visible has a authorized RS user even if the permissions in RS are set in DOMAIN2\XXXX mode... is any way to validate users from other domains other than the one of the native instalation? Thanks Tag: Chart with custom values Tag: 55574
  - 21
    - MS SQL Server Report Pack for IIS logs Hi, I want to use the MS SQL Server Report Pack for IIS logs, but when i want to load the database with my own IIS log data it gives an error. I do what is told on the readme and go to logparser and type: LogParser "SELECT date, time, strcat(strcat(strcat(TO_STRING(TO_TIMESTAMP(date, time), 'hh'),':00-'), TO_STRING(TO_TIMESTAMP(date, time), 'hh')),':59') AS Hour, TO_Int(TO_String(date,'MM')) as Month, TO_Int(TO_String(date,'yyyy')) as year,c-ip, cs-username, s-sitename, s-computername, s-ip, s-port, cs-method, cs-uri-stem, cs-uri-query, sc-status, sc-substatus, sc-win32-status, sc-bytes, cs-bytes, time-taken, cs-version, cs-host, cs(User-Agent), cs(Cookie), cs(Referer) FROM C:\WINDOWS\system32\LogFiles\W3SVC\ex060612.log TO GlobalIISLog" -i:IISW3C -o:SQL -server:(local) -database:IISLog -createtable:ON It gives the following error: Task aborted. Error connecting to ODBC Server SQL State: 08001 Native Error: 17 Error Message: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. Statistics: ----------- Elements processed: 0 Elements output: 0 Execution time: 16.53 seconds what can I do?? Fré Tag: Chart with custom values Tag: 55573
  - 22
    - Cannot connect to the reporting services Hih , On a SQL2005 SP1 machine, I get the following error code whnever I try to connect to the reporting services. TITEL: Verbindung mit Server herstellen ------------------------------ Es kann keine Verbindung mit 'mastermind' hergestellt werden. ------------------------------ ZUSÄTZLICHE INFORMATIONEN: Die zugrunde liegende Verbindung wurde geschlossen: Für den geschützten SSL/TLS-Kanal konnte keine Vertrauensstellung hergestellt werden.. (System.Web.Services) ------------------------------ Das Remotezertifikat ist laut Validierungsverfahren ungültig. (System) ------------------------------ SCHALTFLÄCHEN: OK ------------------------------ I try to trnaslate the message text .... ... the connection with 'mastermind' could not be established. [..] for the secure SSL/TLS-channnel .... The remote certificate is invalid according to validity-technique Can someone help me ? Greetings Nico Tag: Chart with custom values Tag: 55570
  - 23
    - Not creating report when no data is present I have a subscription that is set up to run each night. The report creates a list of updated information during the day. If there is no updated information during the day I still get the report header but the report is blank. I would like to not create any report (or at least have it not email the report) when there is no data returned from the query. Is that possible? Thanks... Tag: Chart with custom values Tag: 55565
  - 24
    - RSClientPrint1.Print Hi All, I need to set the printer name for automatic printing to the RSClientPrint1.Print(...) . I need to print automatically with out the popup. How can I do it ? Shachar. Tag: Chart with custom values Tag: 55559
  - 25
    - Where is the Fields Window??? I'm using SQL Server 2005 Business Intelligence Developer (which identifies itself as vs2005) and I cannot find or bring up the "Fields Window" or as it's sometimes referred to as the "Fields List." My book says it's on the left near the toolbox but it's not there. I'm in Layout mode. There is no "Fields List" on the view menu either. How can I make this visible? Thanks, T Tag: Chart with custom values Tag: 55555

Hi,

I'm using RS for SQL 2005 and I want a pie chart that only show's
certain defined values. For example:

Source query results

one | two | three | four
14 | 23 | 345 | 44
23 | 34 | 243 | 32
78 | 78 | 46 | 23
56 | 56 | 56 | 11
................................
........

Values to show in the pie chart:

Label: A Value: SUM(Fields!one.Value)
Label: B Value: SUM(Fields!two.Value)
Label: C Value: SUM(Fields!three.Value)
Label: D Value: SUM(Fields!four.Value)

That's it, I just want a pie chart that show the percentage of
these values refering to the total. Can anyone tell me how to put the
Values, Categories, Series to achieve this?. Every thing I have tried
seems to take a value for every row and not for the SUM().

Thanks a lot.

Top