Mar 9, 2011

Configuring SSRS

Hi to all friends,

Well, due to a special request from a special friend I felt to put SSRS stuff over here.

What this Post contains
While integrating SSRS Report, the report.rdl file is loaded inside ReportViewer Control but, An issue occurs, that the report asks for Credentials Every Time.
This post contains C# code which can set Credentials dynamically from Web.config which may resolve the issue.


Prior Knowledge Required
To go through this Post, a programmer requires a prior knowledge of SSRS Reports Developing and Deploying.
[Its consider in prior that A Programmer is aware about 1),2),3),4) & 5) Points]

1). MIS.rdl File is uploaded over SSRS.

2). form_Report_Stock.aspx & form_Report_Stock.aspx.cs Both Page are well coded including ReportViewer Control.

3). form_Report_Stock.aspx.cs
using Microsoft.Reporting.WebForms;

4). form_Report_Stock.aspx
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>


5). form_Report_Stock.aspx.cs
Inside Page Load event of write following code:

if (!IsPostBack && !IsCallback)
{
List parameters = new List();
parameters.Add(new ReportParameter("P01Name","P01Value"));
parameters.Add(new ReportParameter("P02Name","P02Value"));
parameters.Add(new ReportParameter("P03Name","P03Value"));
parameters.Add(new ReportParameter("Connection_String",str_Cn)); //P04Name may Contain Connection String
ReportServiceUtilities.PrepareReport(rvControl,"Report_Name", parameters);
}

You need to download the ReportServiceUtilities.cs Class.

Also, Note to confirm following settings over SSRS:

1


2


3


4


Conclusion:
You will be able to set the SSRS Report Credentials Dynamically.

For any doubts please Leave comments,
I will try to revert ASAP for any issue.


Thanks!!

Mar 2, 2011

Tata Power may commission first unit of Mundra project by Sept
BS Reporter / Mumbai December 18, 2010, 0:35 IST

Tata Power is all set to commission the first 800-Mw unit of India’s first ultra mega power project at Mundra in Gujarat by September 2011.

Coastal Gujarat Power Ltd, the special purpose vehicle implementing the 4,000-Mw (5x800-Mw) project, had completed 65 per cent of the work, the country’s largest private sector power utility said in a recent analyst presentation. About 11,000 people are working on the site to meet the deadlines.

Erection of boiler pressure parts for the final three units and work on chimneys and 400-Kv switch yard are proceeding as per schedule. Structural fabrication of external coal handling system is 85 per cent complete, but requires diversion of a village road to complete the remaining work. Coal jetty with ship unloading facilities is expected to be ready this month.

Distributed control system switch on and boiler hydro testing of the second unit were successfully completed in September. Work is in progress on the 400-Kv power evacuation lines and efforts are on to obtain the required right of way in time for one of the sections of the line.

Tight project timelines for transmission and generation commissioning and smooth coordination across multiple vendors on site will be crucial to the project progress, said Tata Power.

After the commissioning of the first unit in September, the company hoped to commission the remaining four units at an interval of every four months, said Tata Power.

Out of the total project cost of Rs 17,000 crore, Tata Power had invested Rs 5,816 crore as debt and Rs 2,937 crore as equity investment till the second quarter of 2010-11. The project is funded on a 75:25 debt-to-equity ratio by a consortium of banks, including State Bank of India, International Finance Corporation, Asian Development Bank, KEIC and K-Exim.

The imported coal-based project requires 11-12 million tonnes per annum (mtpa) coal and Tata Power has off-take agreements for about 10.11 mtpa with KPC and Arutmin mines of Bumi resources, in which the company had picked up stakes a few years ago. The company is also scouting for additional mines in Australia, Mozambique and South Africa.

Tata Power has also floated a shipping subsidiary, Trust Energy Resources, with base in Singapore for owning ships to meet shipping requirements and trading in fuels. Another subsidiary, Energy Eastern, was also floated for chartering of ships. It is estimated that the Mundra project will require eight vessels to ship coal. The company has purchased two Korean-build vessels scheduled for delivery by 2011 and has already chartered three vessels to import coal from Indonesia.

Android 2.2 Froyo Web Browser Issue Resolved

Hi, Friends,
This is for Android 2.2 Froyo OS Users
Especially for,
LG Optimus One (Android 2.2) Mobile Users
TATA DOCOMO Sim Card

I have both Wi-fi Internet & GPRS (2G) Internet facility on my cell (Above mentioned).
Once I have by mistake kept both Net Using functionality on.
From that day, there was an issue inside the Web Browser, which was not able to connect to Internet using GPRS(2G), Although it was working fine with Wi-Fi connection. I was looking for its solution since few weeks but in vain.

Many fake stuff found were:
Browser Setting Issues, Tata Sim Card Net usage Finished, Some Network Coverage Issue,
Need to Reset mobile, Change factory Settings.


Finally I got the Solution
From Combine efforts of Mine & One good fellow (Dharmeshbhai, Nokia Priority, Poddar Arcrade), I got the solution as: Inside Settings->Wireless & Network Settings->Mobile Networks->Access Point Names->Reset to default
took 30 seconds of process and then Done as and when I started my Web Browser of LG Optimus One.

Hope this might be helpfull for other Android(2.2) Froyo LG Optimus One Web Browser Users.

Regards,
Viral Rathod
(Mo. 09725116400)