Showing posts with label figure. Show all posts
Showing posts with label figure. Show all posts

Monday, March 26, 2012

Intermitten Paging Error

Hello all,

I am having an intermitten paging problem and can't figure out why. It doesn't happen each time but quite often. I am using the default allow paging text box filing the data set with a simple query. And when you start at 1 and work your way up through the pages, it will throw this error page on the screen and will not go further. Usually happens in the mid 20'2 to 30's page. Any Ideas?

The resource cannot be found.

Description:HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL:/CustomError.aspx

Once this happens you can go backward page numbers but you can not go forwrad any more.

This is the code to populate the dataset

<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" PageSize="5" AutoGenerateColumns="False"> <Columns> <asp:TemplateField> <ItemTemplate> <asp:Image ID="Image1" runat="server" Imageurl='<%# "~/photos/" & Eval("[MLS Number]") & "_0.jpg" %>' AlternateText="Main Photo" CssClass="photo-float-left photo-border" Height="125px" Width="125px" /> <asp:Label ID="Label1" runat="server" Text='<%# Eval("[MLS Number]") %>'></asp:Label>          <asp:Label ID="Label2" runat="server" Text='<%# Eval("[Street Number]") %>'></asp:Label> <asp:Label ID="Label3" runat="server" Text='<%# Eval("Direction") %>' Width="16px"></asp:Label> <asp:Label ID="Label4" runat="server" Text='<%# Eval("Address") %>'></asp:Label>       <asp:Label ID="Label5" runat="server" Text='<%# Eval("[List Price]", "{0:C}") %>'></asp:Label> <li>BR: <asp:Label ID="Label6" runat="server" Text='<%# Eval("Bedrooms") %>'></asp:Label> / Full Baths:  <asp:Label ID="Label7" runat="server" Text='<%# Eval("[Full Baths]") %>'></asp:Label> / Half Bath:   <asp:Label ID="Label8" runat="server" Text='<%# Eval("[Half Baths]") %>'></asp:Label></li> <asp:TextBox ID="TextBox1" runat="server" Height="80px" Text='<%# Bind("[Public Remarks]") %>' Width="344px" Rows="3" TextMode="MultiLine" Font-Size="X-Small"></asp:TextBox> <hr /> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>

Thanks,

Tony

Hi tchager,

In my opinion, I don't think this is a problem to your app. I think there might be may people accessing this server and the server might fail because of the concurrency issue, since this is a 404 error.

You can try to check the IIS settings for optimization.

Monday, March 19, 2012

InterActive Sorting Help (Brian Welcker Video)

I saw a demo of a report using interactive sorting about a week ago. I can
not figure out though how to get this feature in my report. I believe the
video was of Brian Welcker' Does anyone have any advice on how todo this?
I am running a W2K3 Server and RS with all the latest SP's.
Thanks for any helpYou will need SQL Server 2005 CTP June for using the built-in interactive
sort. It is not available on RS 2000.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Jones" <ajones@.rheemac.com> wrote in message
news:%23LRBAu3eFHA.2732@.TK2MSFTNGP14.phx.gbl...
>I saw a demo of a report using interactive sorting about a week ago. I can
>not figure out though how to get this feature in my report. I believe the
>video was of Brian Welcker' Does anyone have any advice on how todo this?
>I am running a W2K3 Server and RS with all the latest SP's.
> Thanks for any help
>|||Thank You for the help. So now I have a dumb question. What does CTP stand
for?
Thanks again!
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:ey92kc4eFHA.3040@.TK2MSFTNGP14.phx.gbl...
> You will need SQL Server 2005 CTP June for using the built-in interactive
> sort. It is not available on RS 2000.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Andy Jones" <ajones@.rheemac.com> wrote in message
> news:%23LRBAu3eFHA.2732@.TK2MSFTNGP14.phx.gbl...
>>I saw a demo of a report using interactive sorting about a week ago. I can
>>not figure out though how to get this feature in my report. I believe the
>>video was of Brian Welcker' Does anyone have any advice on how todo
>>this? I am running a W2K3 Server and RS with all the latest SP's.
>> Thanks for any help
>|||CTP = Community Technology Preview.
See also: http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Jones" <ajones@.rheemac.com> wrote in message
news:OzcfckFfFHA.3912@.tk2msftngp13.phx.gbl...
> Thank You for the help. So now I have a dumb question. What does CTP
> stand for?
> Thanks again!
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:ey92kc4eFHA.3040@.TK2MSFTNGP14.phx.gbl...
>> You will need SQL Server 2005 CTP June for using the built-in interactive
>> sort. It is not available on RS 2000.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Andy Jones" <ajones@.rheemac.com> wrote in message
>> news:%23LRBAu3eFHA.2732@.TK2MSFTNGP14.phx.gbl...
>>I saw a demo of a report using interactive sorting about a week ago. I
>>can not figure out though how to get this feature in my report. I believe
>>the video was of Brian Welcker' Does anyone have any advice on how todo
>>this? I am running a W2K3 Server and RS with all the latest SP's.
>> Thanks for any help
>>
>

Sunday, February 19, 2012

Integrating asp.net application and reporting services

Hi,
I have just started using Reporting Services and found it pretty simpleto use. I, however, could not figure out how i can achieve thefollowing and will appreciate suggestions on this. I intend to generatethe reports on the fly depending upon the parameters the userenters.The reports are generated through a link on ASP.NET applicationpage. The user fills in the input and accordingly different reports aregenerated. So I want to ask how I can integrate the asp.net applicationand the reporting services.
Thanks
Ankur
You can use the renderbyurl method of Reporting Services. Check out books on line for RS about the various rendering extensions.|||

What should the approach for the problem described herehttp://forums.asp.net/973015/ShowPost.aspx...
try login in as testuser (pwd: dnntest) at this URLhttp://ser.senape.gov.bo/Testing/tabid/61/Default.aspx
Any help is appreciated.

|||I was never able to successfully use the URL approach without using the extensions only available in the expensive Enterprise edition. I used the SOAP approach instead as described quite thoroughly in Teo lachev's book "Microsoft Reporting Services In Action".|||Hi, thanks for your reply. I am using the render method to call thereport server through my application. But i am still facing one problemwhen I call the render method. I am not able to figure out what shouldbe the path of my report that I want to run, since the report is on aremote machine. what should my reportpath variable contain? Can yousuggest how i shld go about it?
thanks
Ankur
|||U have to create an rdl file (using XMLWriter Class) and then upload this file to the report server through code. And then u can view the reports. But a new report gets generated each time.|||reportPath is the folder path to the report (e.g. /My Reports/My Test Report). No URL information is included since that is derived from your web.config file when you instantiate your ReportServer.ReportingService Web method. Check the web.confg file and set the correct URL to the ReportingService key. Make sure that your application has the "URL Behavior" property set to "Dynamic" as well.|||Hi,
Thanks a lot for ur reply. It was a big help.
Ankur