Sunday, December 29, 2013

load report failed in iis7

You have to give permission to temp folder in server pc Click Start-->Run-->Type Explorer--> go to C:/ Windows temp Right click on Temp folder Properties give the user to full/write control

Trusted Connection failed for IIS7 in localhost

Create a new user of your PC (if you alreasy have do not to create) One of our websites use Impersonation and a specific user account with special permissions to access certain system resources. The first step in enabling impersonation is, setting up the correct attributes in the web.config file write By using the attribute impersonate="true", you are telling IIS that this website will be impersonating the configured user account.
  • 1. Open IIS Manager
  • 2. Expand computer name
  • 3. Expand websites
  • 4. Click on the specific website for which you want to use impersonation
  • 5. On the right panel, under the heading "IIS", double click "Authenticaion".
  • 6. Right click on "ASP.NET Impersonation" and select "Edit"
  • 7. Choose "Specific User".
  • 8. Click the SET button to provide the specific user name and password.
Press OK at the popup dialog to complete this step on enabling impersonation for website in IIS 7.0. How to choose process identity for Application Pool in IIS 7.0 To set the correct user identity for the application pool, follow the steps below:
  • 1. Open IIS Manager
  • 2. Click on "Application Pools" under the computer name
  • 3. On the right panel, right click on the application pool name
  • 4. Select "Advanced properties"
  • 5. Select "Identity" under "Process Model".
  • 6. Click on the button to set the user account.
  • 7. Select "Custom account"
  • 8. Click on the button to specify the user account and password.
  • 9. Press "OK".

Thursday, December 26, 2013

Row wise sum to the next row

whileprintingrecords; numbervar subtotal; subtotal := subtotal + ({@TotAmt})