reporting services 2000 rendering

I am using SQL Server 2000 sp3 and reporting services sp2, and I cannot
get the render method to work for my reports
(http://help.maximumasp.com/SmarterT...cle.aspx?articl
eid=847).
I get serveral errors such as :
1) The best overloaded match has some invalid arguments
2) Argument '8': cannot convert from '<null>' to 'out string'
3) Argument '9': cannot convert from '<null>' to 'out string'
4) Argument '10': cannot convert from '<null>' to 'out
lovelyjubbly.net.discountasp.rs.ParameterValue[]'
5) Argument '11': cannot convert from '<null>' to 'out
lovelyjubbly.net.discountasp.rs.Warning[]'
6) Argument '12': cannot convert from 'string[]' to 'out string[]'
Can anybody help?
Cheers,
Mike
*** Sent via Developersdex http://www.examnotes.net ***You'll get these errors if you don't pass the arguments properly to the
Render method. Make sure you specify the 'out' keyword for output
parameters and pass strongly-typed parameters instead of 'null' when
required.
If you still have problems, post your code.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:eMxayzaVGHA.4764@.TK2MSFTNGP10.phx.gbl...
>I am using SQL Server 2000 sp3 and reporting services sp2, and I cannot
> get the render method to work for my reports
> (http://help.maximumasp.com/SmarterT...cle.aspx?articl
> eid=847).
> I get serveral errors such as :
> 1) The best overloaded match has some invalid arguments
> 2) Argument '8': cannot convert from '<null>' to 'out string'
> 3) Argument '9': cannot convert from '<null>' to 'out string'
> 4) Argument '10': cannot convert from '<null>' to 'out
> lovelyjubbly.net.discountasp.rs.ParameterValue[]'
> 5) Argument '11': cannot convert from '<null>' to 'out
> lovelyjubbly.net.discountasp.rs.Warning[]'
> 6) Argument '12': cannot convert from 'string[]' to 'out string[]'
> Can anybody help?
>
> Cheers,
> Mike
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Hi Dan,
Here is my first attempt :
// ReportingService rs = new ReportingService();
//
// rs.Credentials = new System.Net.NetworkCredential("rs_*****",
"*****", "");
//
// Byte[] results, image;
// string[] streamids;
// string streamid;
//
// //render the report to HTML 4.0
// results = rs.Render("/lovelyjubbl/reports/QBRatings", "HTML4.0",
null,
"<DeviceInfo><StreamRoot>/lovelyjubbly/</StreamRoot></DeviceInfo>",
null, null, null, null, null, null, null, streamids);
// Response.BinaryWrite(results);
And here's my second :
ReportingService rs = new ReportingService();
rs.Credentials = new System.Net.NetworkCredential("rs_*****", "*****",
"");
// Render arguments
byte[] result = null;
string reportPath = "/lovelyjubbl/reports/QBRatings";
string format = "MHTML";
string historyID = null;
string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
// Prepare report parameter.
// ParameterValue[] parameters = new ParameterValue[3];
// parameters[0] = new ParameterValue();
// parameters[0].Name = "EmpID";
// parameters[0].Value = "38";
// parameters[1] = new ParameterValue();
// parameters[1].Name = "ReportMonth";
// parameters[1].Value = "6"; // June
// parameters[2] = new ParameterValue();
// parameters[2].Name = "ReportYear";
// parameters[2].Value = "2004";
DataSourceCredentials[] credentials = null;
string showHideToggle = null;
string encoding;
string mimeType;
Warning[] warnings = null;
ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
SessionHeader sh = new SessionHeader();
rs.SessionHeaderValue = sh;
try
{
result = rs.Render(reportPath, format, historyID, devInfo, null,
credentials,
showHideToggle, out encoding, out mimeType, out
reportHistoryParameters, out warnings,
out streamIDs);
}
catch (SoapException e)
{
//Console.WriteLine(e.Detail.OuterXml);
}
// Write the contents of the report to an MHTML file.
try
{
FileStream stream = File.Create( "report.mhtml", result.Length );
Console.WriteLine( "File created." );
stream.Write( result, 0, result.Length );
Console.WriteLine( "Result written to the file." );
stream.Close();
}
catch ( Exception e )
{
//Console.WriteLine( e.Message );
}
Neither of which work, and both give errors as mentioned in my first
post.
Thanks,
Mike
*** Sent via Developersdex http://www.examnotes.net ***|||> Neither of which work, and both give errors as mentioned in my first
> post.
The first version will generate the errors mentioned in your initial post.
However, your second attempt looks syntactically correct. I copy/pasted
that code and successfully compiled it so you shouldn't get any errors as
long as you've added the RS web service reference to your project.
Did you completely remove the first version from your project?
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:ON09ocbVGHA.5288@.TK2MSFTNGP14.phx.gbl...
> Hi Dan,
> Here is my first attempt :
> // ReportingService rs = new ReportingService();
> //
> // rs.Credentials = new System.Net.NetworkCredential("rs_*****",
> "*****", "");
> //
> // Byte[] results, image;
> // string[] streamids;
> // string streamid;
> //
> // //render the report to HTML 4.0
> // results = rs.Render("/lovelyjubbl/reports/QBRatings", "HTML4.0",
> null,
> "<DeviceInfo><StreamRoot>/lovelyjubbly/</StreamRoot></DeviceInfo>",
> null, null, null, null, null, null, null, streamids);
> // Response.BinaryWrite(results);
>
> And here's my second :
> ReportingService rs = new ReportingService();
> rs.Credentials = new System.Net.NetworkCredential("rs_*****", "*****",
> "");
> // Render arguments
> byte[] result = null;
> string reportPath = "/lovelyjubbl/reports/QBRatings";
> string format = "MHTML";
> string historyID = null;
> string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
> // Prepare report parameter.
> // ParameterValue[] parameters = new ParameterValue[3];
> // parameters[0] = new ParameterValue();
> // parameters[0].Name = "EmpID";
> // parameters[0].Value = "38";
> // parameters[1] = new ParameterValue();
> // parameters[1].Name = "ReportMonth";
> // parameters[1].Value = "6"; // June
> // parameters[2] = new ParameterValue();
> // parameters[2].Name = "ReportYear";
> // parameters[2].Value = "2004";
> DataSourceCredentials[] credentials = null;
> string showHideToggle = null;
> string encoding;
> string mimeType;
> Warning[] warnings = null;
> ParameterValue[] reportHistoryParameters = null;
> string[] streamIDs = null;
> SessionHeader sh = new SessionHeader();
> rs.SessionHeaderValue = sh;
> try
> {
> result = rs.Render(reportPath, format, historyID, devInfo, null,
> credentials,
> showHideToggle, out encoding, out mimeType, out
> reportHistoryParameters, out warnings,
> out streamIDs);
> }
> catch (SoapException e)
> {
> //Console.WriteLine(e.Detail.OuterXml);
> }
> // Write the contents of the report to an MHTML file.
> try
> {
> FileStream stream = File.Create( "report.mhtml", result.Length );
> Console.WriteLine( "File created." );
> stream.Write( result, 0, result.Length );
> Console.WriteLine( "Result written to the file." );
> stream.Close();
> }
> catch ( Exception e )
> {
> //Console.WriteLine( e.Message );
> }
>
> Neither of which work, and both give errors as mentioned in my first
> post.
>
> Thanks,
> Mike
> *** Sent via Developersdex http://www.examnotes.net ***|||I'm now using the second version of my code. I no longer get build
errors, but when I run the code I just get an unviewable image (a blank
image with a red cross). The strange thing is that my code works for
PDF, but not HTML4.0.
ReportingService rs = new ReportingService();
rs.Credentials = new System.Net.NetworkCredential("****", "****",
"");
// Render arguments
byte[] result = null;
string reportPath = "/lovelyjubbl/reports/QBRatings";
string format = "HTML4.0";
string historyID = null;
string devInfo =
@."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
DataSourceCredentials[] credentials = null;
string showHideToggle = null;
string encoding;
string mimeType;
Warning[] warnings = null;
ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
SessionHeader sh = new SessionHeader();
rs.SessionHeaderValue = sh;
try
{
result = rs.Render(reportPath, format, historyID, devInfo, null,
credentials,
showHideToggle, out encoding, out mimeType, out
reportHistoryParameters, out warnings,
out streamIDs);
}
*** Sent via Developersdex http://www.examnotes.net ***|||Try setting devInfo to null per http://support.microsoft.com/kb/842854/.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:%23eq76ymVGHA.1688@.TK2MSFTNGP11.phx.gbl...
> I'm now using the second version of my code. I no longer get build
> errors, but when I run the code I just get an unviewable image (a blank
> image with a red cross). The strange thing is that my code works for
> PDF, but not HTML4.0.
> ReportingService rs = new ReportingService();
> rs.Credentials = new System.Net.NetworkCredential("****", "****",
> "");
> // Render arguments
> byte[] result = null;
> string reportPath = "/lovelyjubbl/reports/QBRatings";
> string format = "HTML4.0";
> string historyID = null;
> string devInfo =
> @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
> DataSourceCredentials[] credentials = null;
> string showHideToggle = null;
> string encoding;
> string mimeType;
> Warning[] warnings = null;
> ParameterValue[] reportHistoryParameters = null;
> string[] streamIDs = null;
> SessionHeader sh = new SessionHeader();
> rs.SessionHeaderValue = sh;
> try
> {
> result = rs.Render(reportPath, format, historyID, devInfo, null,
> credentials,
> showHideToggle, out encoding, out mimeType, out
> reportHistoryParameters, out warnings,
> out streamIDs);
> }
>
> *** Sent via Developersdex http://www.examnotes.net ***|||This just gives me a blank page on rendering.
*** Sent via Developersdex http://www.examnotes.net ***|||> This just gives me a blank page on rendering.
I'm not sure what you mean by a blank page since your last code snippet
writes the report to a file rather than a browser window. If your code is
part of an ASP.NET application, you could change the format to "HTML4.0" and
render it with the code below.
Response.ClearContent();
Response.BinaryWrite(result);
Response.Flush();
Response.Close();
My RS expertise is limited. You might try posting rendering issues to a
Reporting Services forum.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:OLZEjbnVGHA.4384@.tk2msftngp13.phx.gbl...
> This just gives me a blank page on rendering.
>
> *** Sent via Developersdex http://www.examnotes.net ***

Reporting Services 2000 - Printing Hangs

I am running SQL 2000 SP4 with Reporting Services 2000 SP2. Reporting services hangs when I try to print reports. The reports render okay, and when I click on the print icon, I get the appropriate dialog box. Once I click "OK", I get the "Printing..." dialog that says "Printing Now...", but it never prints, and the window eventually stops responding. As far as I am aware, no changes have been made to the server, and it was working fine approximately 10 days ago. Below is the contents of my RS Client Print Log (%Temp%\LOG56.tmp):

CRSClientPrint::Print - Starting Function.
reportServerUrl = http://reportsrv/ReportServer
reportPath = %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active
reportName = Contract_Project_By_State
CResourceManager::SetLocaleInfo - Starting Function.
SetUICulture - Starting Function.
Attempted UI LCID = 9
Using UI LCID = 1033
SetUICulture - Ending Function.
CResourceManager::LoadResourceDLL - Starting Function.
CResourceManager::LoadResourceDLL - Ending Function: 0x00000000.
CResourceManager::CanUseCurrentLocale - Starting Function.
CResourceManager::CanUseCurrentLocale - Ending Function.
CResourceManager::LoadGDIPlus - Starting Function.
CResourceManager::LoadGDIPlus - Ending Function: 0x00000000.
Attempted culture = 1033
Using culture = 1033
Culture name = English_United States.1252
CResourceManager::SetLocaleInfo - Ending Function: 0x00000000.
CPrintDlg::Print - Starting Function.
CPrintDlg::InitializePrintDlg - Starting Function.
CPrintDlg::GetDefaultPrinterName - Starting Function.
CPrintDlg::GetDefaultPrinterName - Ending Function: 0x00000000.
CPrintDlg::SetPrinterPaperSize - Starting Function.
CPrintDlg::SetPrinterPaperSize - Ending Function: 0x00000000.
CPrintDlg::InitializePrintDlg - Ending Function: 0x00000000.
CReport::SetReportName - Starting Function.
CReport::SetReportName - Ending Function: 0x00000000.
CPrintDlg::PrintReportPages - Starting Function.
CCancelDlg::StartDialog - Starting Function.
CCancelDlg::StartDialog - Ending Function: 0x00000000.
CReport::Fetch - Starting Function.
CReport::ComparePrintInfo - Starting Function.
Value of diff = 2
CReport::ComparePrintInfo - Ending Function.
CReport::ClearPages - Starting Function.
CReport::ClearFetchedPages - Starting Function.
CReport::ClearFetchedPages - Ending Function.
CReport::ClearPages - Ending Function.
CReport::ResetNextFetch - Starting Function.
Next Fetch set to 1
CReport::ResetNextFetch - Ending Function.
CReport::StartFetchThread - Starting Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport::StartFetchThread - Ending Function: 0x00000000.
CReport::Fetch - Ending Function: 0x00000000.
CReport::GetPage - Starting Function.
Page = 1
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x00000000
CReport::GetPageWrapper - Ending Function.
CReport::FetchThreadMain - Starting Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport::FetchAllPages - Starting Function.
CReport::PerformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 8500, Width = 11000 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager::SetInvariantCulture - Starting Function.
CResourceManager::SetInvariantCulture - Ending Function: 0x00000000.
CResourceManager::ResetCulture - Starting Function.
CResourceManager::ResetCulture - Ending Function: 0x00000000.
Url = http://reportsrv/ReportServer?%2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True

Can anyone give me any ideas as to how to troubleshoot this issue?

Hi Patrick,

If that is all that is in the log, it looks like the service might be having an issue with rendering the Url. Paste the Url from the print log file into Internet Explorer and see if it renderers an emf image.

Also, you can check the Report Server log files for any exceptions from the rendering. You can find the log directory, Logfiles next to the Report Server installation binaries directory.

Did you change any settings on your server to use Cookieless Sessions? I notice that the SessionID is not stored in the URL.

|||

I have not changed any cookie settings. When I paste the URL into the browser, I get a prompt for credentials, and then an HTTP 401 (Unauthorized) error. I am an Administrator, so my credentials should be valid. The ReportServer log showed the following:

w3wp!webserver!1df0!01/08/2007-12:34:55:: i INFO: Processed folder '/'
w3wp!webserver!1df0!01/08/2007-12:34:56:: i INFO: Processed folder '/Engineering'
w3wp!webserver!1df0!01/08/2007-12:34:58:: i INFO: Processed folder '/Engineering/Ramz - Development'
w3wp!webserver!1df0!01/08/2007-12:34:59:: i INFO: Processed folder '/Engineering/Ramz - Development/DEV_Reports'
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing ResponseBufferSizeKb to default value of '64' KB because it was not specified in Server system properties.
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing UseSessionCookies to 'True' as specified in Server system properties.
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Initializing EnableClientPrinting to default value of 'True' because it was not specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Call to RenderFirst( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!library!1e4c!01/08/2007-12:35:07:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for temporary files.
w3wp!library!1e4c!01/08/2007-12:35:08:: i INFO: Initializing EnableExecutionLogging to 'False' as specified in Server system properties.
w3wp!library!1e2c!1/8/2007-12:35:08:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
w3wp!webserver!1e4c!01/08/2007-12:35:08:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!library!1e2c!1/8/2007-12:35:08:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:08:: i INFO: Initializing SessionAccessTimeout to default value of '600' seconds because it was not specified in Server system properties.
w3wp!webserver!1e4c!01/08/2007-12:35:08:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream='d60bcf42-3d04-4642-8772-8296be509a7b'
w3wp!library!1e2c!01/08/2007-12:35:39:: i INFO: Call to RenderNext( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!cache!1e2c!01/08/2007-12:35:39:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!chunks!1e2c!01/08/2007-12:35:39:: i INFO: ### GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found! this=25ac3238-2ba1-4406-befb-f46907e5d068
w3wp!webserver!1df0!01/08/2007-12:35:41:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!1e2c!01/08/2007-12:36:17:: i INFO: Session live: /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!library!83c!01/08/2007-12:36:17:: i INFO: Call to RenderNext( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!cache!83c!01/08/2007-12:36:17:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!chunks!83c!01/08/2007-12:36:17:: i INFO: ### GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found! this=25ac3238-2ba1-4406-befb-f46907e5d068
w3wp!webserver!1df0!01/08/2007-12:36:18:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!83c!01/08/2007-12:36:55:: i INFO: Session live: /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!library!1e4c!01/08/2007-12:37:57:: i INFO: Call to RenderFirst( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!webserver!1df0!01/08/2007-12:37:58:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State

|||

I get the following in the IIS log when I try to render the report:

2007-01-09 15:42:12 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:43:25 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:43:25 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:44:00 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:44:00 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:47:09 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:47:14 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:47:14 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401

It appears that SSRS is not passing my credentials all of the time, only sometimes. It also appears that multiple requests are made for the same report. Any ideas as to why this might be?

Reporting Services & IIS6 problem

Hi,
We are having a problem with reports containing images (charts, etc). Our
application uses the web service to render our reports, which on development
machines works great(IIS5, win xp). However, I have just deployed the app for
testing to and Win2k3 server running iis6 and all of the charts appear as
broken links. The web service is saving out the files as expected to the
correct location, and the properties of the images show the correct URL.
Is there an option in IIS6 that stops it serving up files without an
extension, the files created by RS are usually in the format similar to
C_46_S without an extension. If i manually rename these and add a .jpg to the
end, the file is served up fine(although not from within the reports as
reference the files without extension).
If anyone can help it would be much appreciated.
Cheers
Ben LeeAdd your reportserver site to the trusted sites on your browser and this
will solve your problem. RS is unable to set a cookie and this is when such
a behaviour is exhibited. See the privacy icon on your browser when this
issue happens. Double-click the icon and accept all cookies from this site.
DC
"agt_cooper" <agt_cooper@.discussions.microsoft.com> wrote in message
news:A36B0F89-D209-4FCC-93C2-7D495321CC4B@.microsoft.com...
> Hi,
> We are having a problem with reports containing images (charts, etc). Our
> application uses the web service to render our reports, which on
development
> machines works great(IIS5, win xp). However, I have just deployed the app
for
> testing to and Win2k3 server running iis6 and all of the charts appear as
> broken links. The web service is saving out the files as expected to the
> correct location, and the properties of the images show the correct URL.
> Is there an option in IIS6 that stops it serving up files without an
> extension, the files created by RS are usually in the format similar to
> C_46_S without an extension. If i manually rename these and add a .jpg to
the
> end, the file is served up fine(although not from within the reports as
> reference the files without extension).
> If anyone can help it would be much appreciated.
> Cheers
> Ben Lee

Reporting Service: Render order of operations.

Just curious, but I am looking for some sort of definitive outline on
the steps reporting services goes through to render a report.
Example:
Header/Footer first.
Second starting from the top of the body of the report render the
first object.
If that object's a grid process the grid's header/footer first, then
go to each successive group until the details.
If a new page is pulled up, this happens here.
And so on..
It would help immensely creating reports, and also I have something I
can show to management who have a beef with a report and cannot grasp
why reporting service processes certain things in "illogical order".
Regards,
- jOn Nov 5, 3:38 pm, modi321 <modi...@.gmail.com> wrote:
> Just curious, but I am looking for some sort of definitive outline on
> the steps reporting services goes through to render a report.
> Example:
> Header/Footer first.
> Second starting from the top of the body of the report render the
> first object.
> If that object's a grid process the grid's header/footer first, then
> go to each successive group until the details.
> If a new page is pulled up, this happens here.
> And so on..
> It would help immensely creating reports, and also I have something I
> can show to management who have a beef with a report and cannot grasp
> why reporting service processes certain things in "illogical order".
> Regards,
> - j
Was this unclear or is there no visual work flow of how MS reporting
services renders a report?|||>From my experience, processing renders as
1. Table Header
2. Table Footer
(3. Group 1 Header)
(4. Group 1 Footer)
(5. Group 2 Header)
(6. Group 2 Footer)
...
x. Details
Order of execution appears to be top left-to-right, to bottom. Custom
Functions populated conditionally in the Details rows that store
values into (Static) global variables will render as 0 in the headers
and footers, because the data items are populated last.
Microsoft is extremely non-committal when it comes to order of
rendering.
-- Scott