Chart with custom values
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. Tag: have a way to call ReportingService.Render within sqlserver SP? Tag: 55667
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55666
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55665
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55664
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55656
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55655
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55654
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55653
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55652
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><!--StartFragment --><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>  =
; =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>  =
; =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>  =
; =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>  =
; =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>  =
; =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>  =
; =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>  =
; =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>  =
; =20
// Third Render, this returns the same result as second Render=20
call<BR>  =
; =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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55651
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55648
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55646
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55645
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55644
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55643
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55642
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55641
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55640
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55638
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55637
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55634
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55630
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55626
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55625
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55623
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55621
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55620
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55618
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55614
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55613
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55610
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55609
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55608
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55607
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55606
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55605
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55604
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55601
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55598
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55597
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55595
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55582
Color of graphs
Hi,
Is it possible to change the colors of the graphs? Specially the series?
Fré Tag: have a way to call ReportingService.Render within sqlserver SP? Tag: 55578
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55575
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55574
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55573
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55570
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55565
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: have a way to call ReportingService.Render within sqlserver SP? Tag: 55559
Have a way to call render report within sqlserver from Stored procedure
or like?