Ihave a vb.net application using report services that has a big delay when I set the parameters with which to call the report. I create a new reporting.reportviewer. I set the ReportServerCredentials.NetworkCredentials, ReportServerUrl, ProcessingModem, ReportPathand everything is fine. When I call SetParameters with a very simple parameter set, I get a delay of between 0.5 and 2.5 seconds. That delay is very noticible to the users. Below is anextract of a sql profiler trace to a database showing the start time, end time, event class and data text of the sql. I've marked the area with the delay in red. I have no idea what is happening at that time, but Is there anything I can do to get rid of that delay? It seems that it could be the first time the my application has had to interface with reporting services. 21/07/2006 13:29:4836321/07/2006 13:29:4836310exec ReadChunkPortion @ChunkPointer=0xFDFF126D000000006804000001000400,@IsPermanentSnapshot=1,@DataIndex=4148,@Length=821/07/2006 13:29:4836321/07/2006 13:29:4836310exec ReadChunkPortion @ChunkPointer=0xFDFF126D000000006804000001000400,@IsPermanentSnapshot=1,@DataIndex=8,@Length=410021/07/2006 13:29:4836321/07/2006 13:29:4836310exec sp_reset_connection 21/07/2006 13:29:4836321/07/2006 13:29:4836310exec CreateSession @SessionID='5zz5gh2wgwfs2hf0qb0gh155',@ReportPath=N'/Symphony Reporting/report3',@Timeout=600,@AutoRefreshSeconds=0,@OwnerSid=0x010500000000000515000000F13F1E839A1DDABDC36D00302B060000,@OwnerName=N'MCR-SYSTEMS\rhutchinson',@AuthType=1,@DataSourceInfo=0x0001000000FFFFFFFF01000000000000000C020000006F4D6963726F736F66742E5265706F7274696E6753657276696365732E50726F63657373696E67436F72652C2056657273696F6E3D392E302E3234322E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D3839383435646364383038306363393105010000004A4D6963726F736F66742E5265706F7274696E6753657276696365732E44617461457874656E73696F6E732E52756E74696D6544617461536F75726365496E666F436F6C6C656374696F6E03000000106D5F636F6C6C656374696F6E42794944146D5F636F6C6C656374696F6E42795265706F7274146D5F636F6C6C656374696F6E427950726F6D70740303041C53797374656D2E436F6C6C656374696F6E732E486173687461626C651C53797374656D2E436F6C6C656374696F6E732E486173687461626C653D4D6963726F736F66742E5265706F7274696E6753657276696365732E44617461457874656E73696F6E732E436F6C6C656374696F6E427950726F6D7074020000000200000009030000000A0A04030000001C53797374656D2E436F6C6C656374696F6E732E486173687461626C65070000000A4C6F6164466163746F720756657273696F6E08436F6D70617265721048617368436F646550726F7669646572084861736853697A65044B6579730656616C756573000003030005050B081C53797374656D2E436F6C6C656374696F6E732E49436F6D70617265722453797374656D2E436F6C6C656374696F6E732E4948617368436F646550726F766964657208EC51383F010000000A0A0B000000090400000009050000001004000000010000000906000000100500000001000000090700000004060000000B53797374656D2E477569640B000000025F61025F62025F63025F64025F65025F66025F67025F68025F69025F6A025F6B0000000000000000000000080707020202020202020232D4E1DE4550ED4AB904FB9304E177480507000000394D6963726F736F66742E5265706F7274696E6753657276696365732E44617461457874656E73696F6E732E44617461536F75726365496E666F13000000046D5F6964066D5F6E616D650E6D5F6F726967696E616C4E616D650B6D5F657874656E73696F6E1B6D5F636F6E6E656374696F6E537472696E67456E63727970746564236D5F6F726967696E616C436F6E6E656374696F6E537472696E67456E63727970746564266D5F6F726967696E616C436F6E6E656374537472696E6745787072657373696F6E4261736564156D5F64617461536F757263655265666572656E6365086D5F6C696E6B49441D6D5F44617461536F757263655769746843726564656E7469616C734964096D5F73656344657363166D5F63726564656E7469616C7352657472696576616C086D5F70726F6D7074136D5F757365724E616D65456E63727970746564136D5F70617373776F7264456E63727970746564076D5F666C616773096D5F6D6F64656C4944136D5F6973456D626564646564496E4D6F64656C156D5F69734D6F64656C536563757269747955736564030101010707000103030704010707040300000B53797374656D2E477569640202010B53797374656D2E477569640B53797374656D2E4775696402544D6963726F736F66742E5265706F7274696E6753657276696365732E44617461457874656E73696F6E732E44617461536F75726365496E666F2B43726564656E7469616C7352657472696576616C4F7074696F6E020000000202494D6963726F736F66742E5265706F7274696E6753657276696365732E44617461457874656E73696F6E732E44617461536F75726365496E666F2B44617461536F75726365466C616773020000000B53797374656D2E4775696401010200000001F8FFFFFF0600000032D4E1DE4550ED4AB904FB9304E1774806090000000441525453060A0000000441525453060B0000000353514C090C0000000A00060D000000182F53796D70686F6E79205265706F7274696E672F4152545301F2FFFFFF06000000A814BB258EC9884888698BC39F85117601F1FFFFFF060000007C8BA03B04528840BACCDE1CC6E465BD091000000005EFFFFFFF544D6963726F736F66742E5265706F7274696E6753657276696365732E44617461457874656E73696F6E732E44617461536F75726365496E666F2B43726564656E7469616C7352657472696576616C4F7074696F6E010000000776616C75655F5F00080200000003000000061200000039456E74657220612075736572206E616D6520616E642070617373776F726420746F2061636365737320746865206461746120736F757263653A0A0A05EDFFFFFF494D6963726F736F66742E5265706F7274696E6753657276696365732E44617461457874656E73696F6E732E44617461536F75726365496E666F2B44617461536F75726365466C616773010000000776616C75655F5F0008020000000300000001ECFFFFFF060000000000000000000000000000000000000000000F0C00000098000000024E923E067F7AAB8735076784BE58B5E7FB39D61C8C5A39887A49C8F639783D2A0E4883F7901E6FE948DD535C1E2A84707D3071F31B5FDD7FCFC51278114BC810B48C8EC63D000F395FA8C28BFD18401221C78DDF7DB335425960CBB69E5823B62A418D46AE7120F1CCF3FCD3E3335E78DB72188BCF64457DB622592A9615775FC5C03758D12948BE507CCD16B2201C66A092A41F12B8D1D00F10000000190200000206050054000000020100048034000000440000000000000014000000020020000100000000041800FF00060001020000000000052000000020020000010200000000000520000000200200000102000000000005200000002002000054000000030100048034000000440000000000000014000000020020000100000000041800FFFF3F00010200000000000520000000200200000102000000000005200000002002000001020000000000052000000020020000540000000401000480340000004400000000000000140000000200200001000000000418001D000000010200000000000520000000200200000102000000000005200000002002000001020000000000052000000020020000540000000501000480340000004400000000000000140000000200200001000000000418001F000600010200000000000520000000200200000102000000000005200000002002000001020000000000052000000020020000540000000601000480340000004400000000000000140000000200200001000000000418001F00060001020000000000052000000020020000010200000000000520000000200200000102000000000005200000002002000054000000070100048034000000440000000000000014000000020020000100000000041800FF0106000102000000000005200000002002000001020000000000052000000020020000010200000000000520000000200200000B,@EffectiveParams=N'<Parameters> <Parameter> <Name>DataSource</Name> <Type>Integer</Type> <Nullable>False</Nullable> <AllowBlank>False</AllowBlank> <MultiValue>False</MultiValue> <UsedInQuery>False</UsedInQuery> <State>MissingValidValue</State> <Prompt /> <PromptUser>True</PromptUser> </Parameter> <Parameter> <Name>AuthLvl</Name> <Type>Integer</Type> <Nullable>False</Nullable> <AllowBlank>False</AllowBlank> <MultiValue>False</MultiValue> <UsedInQuery>False</UsedInQuery> <State>MissingValidValue</State> <Prompt /> <PromptUser>True</PromptUser> </Parameter> <Parameter> <Name>Home</Name> <Type>Integer</Type> <Nullable>False</Nullable> <AllowBlank>False</AllowBlank> <MultiValue>False</MultiValue> <UsedInQuery>False</UsedInQuery> <State>MissingValidValue</State> <Prompt /> <PromptUser>True</PromptUser> </Parameter> <Parameter> <Name>SiteFilter</Name> <Type>Integer</Type> <Nullable>False</Nullable> <AllowBlank>False</AllowBlank> <MultiValue>True</MultiValue> <UsedInQuery>False</UsedInQuery> <State>MissingValidValue</State> <Prompt>Select Required Site(s)</Prompt> <PromptUser>True</PromptUser> </Parameter> <Parameter> <Name>DateFilter</Name> <Type>DateTime</Type> <Nullable>False</Nullable> <AllowBlank>False</AllowBlank> <MultiValue>True</MultiValue> <UsedInQuery>False</UsedInQuery> <State>MissingValidValue</State> <Prompt>Select Required Date(s)</Prompt> <PromptUser>True</PromptUser> </Parameter></Parameters>'21/07/2006 13:29:4837721/07/2006 13:29:4837710exec sp_reset_connection 21/07/2006 13:29:4837721/07/2006 13:29:4837710exec ObjectExists @Path=N'/Symphony Reporting/report3',@AuthType=121/07/2006 13:29:4884721/07/2006 13:29:4884710exec sp_reset_connection 21/07/2006 13:29:4884721/07/2006 13:29:4884710exec GetSessionData @SessionID='5zz5gh2wgwfs2hf0qb0gh155',@OwnerSid=0x010500000000000515000000F13F1E839A1DDABDC36D00302B060000,@OwnerName=N'MCR-SYSTEMS\rhutchinson',@AuthType=1,@SnapshotTimeoutMinutes=144021/07/2006 13:29:4884721/07/2006 13:29:4884710exec sp_reset_connection

Did you ever get a response to this problem you were having? I have a report with a similar problem, however it is taking 14+ seconds to get to the next prompt. That is longer than it takes the whole report to run. Do you have any suggestions? Thanks!

any ideas guys? I have the same problem!ddd