Answers

Advanced rdlc report design

Neven Draskovic

13y

Hey

I made an application that generates reports about the work that my clients employees do. The application does everything that is requested, but my client additionally requested that the data shown in reports should be grouped by the employee who performed it (each employee and the work he's done is represented by a database entry). Let me clarify this request:

A report about a single employee contains a header with his name, last name, serial number and then the report data contains time he got to/off work and some other informations. Now that is done just fine, but how can I make the general report (for all employees) that would display all the data in the database but divided into sections (it should look like all the individual reports got pasted on the same report) so that when the general report is viewed, the viewer can still see who did what. I used the VS 2010 to create my application, if that is of any relevance.
I have no idea how to do this, so please advise. If I failed to provide some informations that you need, please tell me.

Thanks

Answers (2)

with this one you people can get ur expected output, Simply paste this code into ur aspx & aspx.cs pages u will get output

ckeckboxes.aspx
=============

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

function ChangeCheckBoxState(id, checkState)

{

var cb = document.getElementById(id);

if (cb != null)

cb.checked = checkState;

}

function HeaderCheckbox(chkHeader)

{

var cb = document.getElementById(chkHeader);

if(cb != null)

{

if(cb.checked)

{

checkAll('1');

}

else

checkAll('0');

}

function checkAll(checkStates)

{

var checkState = false;

if(checkStates == 1)

checkState = true;

if (AllCheckBoxs != null)

{

for (var i = 0; i < AllCheckBoxs.length; i++)

ChangeCheckBoxState(AllCheckBoxs[i], checkState);

}

function popups()

{

window.open("..\Admin\ViewDatagridDetails.aspx","mywindow","menubar=0,resizable=0,width=350,height=250,scrollbars=yes,resizable=yes");

}

</script>

</head>

<body>

<div>

 <%-- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LITHostingConnectionString %>"

SelectCommand="SELECT * FROM [tblEnquiry]"></asp:SqlDataSource>--%>

<asp:Button ID="btnSubmit" runat="server" OnClick="btnSubmit_Click" Style="z-index: 100;

left: 24px; position: absolute; top: 116px" Text="View Enquiry Details" />

<asp:Panel ID="Laxmi" runat="server" BackColor="#E0E0E0" Font-Bold="True" Font-Italic="True"

Font-Size="X-Large" ForeColor="Red" Height="82px" Style="z-index: 101; left: 0px;

position: absolute; top: 0px" Width="200%">

                  <br />

   Laxmi Hosting Administrator Panel</asp:Panel>

<asp:Label ID="lblTotalRows" runat="server" Style="z-index: 102; left: 37px; position: absolute;

top: 86px"></asp:Label>

<asp:GridView ID="gvDetails" runat="server" BackColor="#DEBA84" BorderColor="#DEBA84"

BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" Style="z-index: 103;

left: 15px; position: absolute; top: 157px" AutoGenerateColumns="False">

<asp:TemplateField >

<asp:CheckBox ID="chkHeader" runat="server" />

</HeaderTemplate>

<asp:CheckBox ID="chkCheck" runat="server" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "EnquiryID">

<asp:Label ID="lblEnquiryId" runat="server" Text='<%# GetData(Eval("EnquiryID")) %>' />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Name" >

<asp:Label ID="lblName" runat="server" Text='<%# GetData(Eval("Name")) %>' Visible="true" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Email ID" >

<asp:Label ID="lblEmail" runat="server" Text='<%# GetData(Eval("Email")) %>' Visible="true" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Mobile No." >

<asp:Label ID="lblMobile" runat="server" Text='<%# GetData(Eval("Mobile")) %>' Visible="true" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "URL" >

<asp:Label ID="lblURL" runat="server" Text='<%# GetData(Eval("URL")) %>' Visible="true" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Landline" Visible="False" >

<asp:Label ID="lblLandline" runat="server" Text='<%# GetData(Eval("Landline")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Country" Visible="False" >

<asp:Label ID="lblCountry" runat="server" Text='<%# GetData(Eval("Country")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Address" Visible="False" >

<asp:Label ID="lblAddress" runat="server" Text='<%# GetData(Eval("Address")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Platform" Visible="False" >

<asp:Label ID="lblPlatform" runat="server" Text='<%# GetData(Eval("Platform")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "HostingPlan" Visible="False" >

<asp:Label ID="lblHostingPlan" runat="server" Text='<%# GetData(Eval("HostingPlan")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "No. of Years" Visible="False" >

<asp:Label ID="lblYears" runat="server" Text='<%# GetData(Eval("Years")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "WebsiteSize" Visible="False" >

<asp:Label ID="lblWebsiteSize" runat="server" Text='<%# GetData(Eval("WebsiteSize")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "RegistrationType" Visible="False" >

<asp:Label ID="lblRegistrationType" runat="server" Text='<%# GetData(Eval("RegistrationType")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "ServiceType" Visible="False" >

<asp:Label ID="lblServiceType" runat="server" Text='<%# GetData(Eval("ServiceType")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Description" Visible="False" >

<asp:Label ID="lblDescription" runat="server" Text='<%# GetData(Eval("Description")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "LITKnowsBy" Visible="False" >

<asp:Label ID="lblLITKnowsBy" runat="server" Text='<%# GetData(Eval("LITKnowsBy")) %>' Visible="false" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="View Profile">

<asp:HyperLink ID="hplViewEmpleyerProfile" runat="server" Text="View" NavigateUrl='<%# NavigateToViewPostedJob(Eval("EnquiryID")) %>'>

</asp:HyperLink>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LITHostingConnectionString %>"

SelectCommand="SELECT [EnquiryID], [Name] FROM [tblEnquiry]"></asp:SqlDataSource>

<asp:Button ID="btnReplyMail" runat="server" Style="z-index: 104; left: 295px; position: absolute;

top: 114px" Text="Reply For Selected One" />

<asp:Button ID="btnSendMail" runat="server" Style="z-index: 105; left: 518px; position: absolute;

top: 118px" Text="Send Mail To Selected People" />

<asp:Button ID="btnTest" runat="server" OnClick="btnTest_Click" Style="z-index: 106;

left: 814px; position: absolute; top: 118px" Text="Test" />

<asp:Label ID="lblStatus" runat="server" Style="z-index: 107; left: 22px; position: absolute;

top: 368px"></asp:Label>

<asp:Label ID="lblStoreName" runat="server" Style="z-index: 108; left: 87px; position: absolute;

top: 409px"></asp:Label>

</div>

</form>

</body>

</html>

ckeckboxes.aspx.cs
===============

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Configuration;

using System.Data.SqlClient;

using System.Text;

public partial class Admin_Datagridtest : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

string constring = ConfigurationSettings.AppSettings["constring"];

SqlConnection con = new SqlConnection(constring);

con.Open();

SqlCommand cmd = new SqlCommand("select * from tblEnquiry", con);

SqlDataReader dr;

dr = cmd.ExecuteReader();

if (dr.Read())

{

gvDetails.DataSource = dr;

gvDetails.DataBind();

//foreach (GridViewRow gvRow in gvDetails.Rows)

//{

// CheckBox cb = (CheckBox)gvRow.FindControl("chkCheck");

// ClientScript.RegisterArrayDeclaration("AllCheckBoxes", "'" + cb.ClientID + "'");

//}

dr.Close();

}

string sql = "select count(*) from tblEnquiry";

SqlCommand cmd1 = new SqlCommand(sql, con);

lblTotalRows.Text = "Total No. of Records in Enquiry form is :" + cmd1.ExecuteScalar();

con.Close();

}

public string GetData(object o)

{

string str = Convert.ToString(o);

if ((str == null) || (str == string.Empty) || (str == "-1.00"))

return "-";

else

return str.Trim();

}

public string NavigateToViewPostedJob(object o)

{

string str = o.ToString();

//Session["Employer"] = str;

//Label lblEnquiryIdVal = (Label)myCbSelected.FindControl("lblEnquiryId");

//Label lblNameVal = (Label)myCbSelected.FindControl("lblName");

//Label lblEmailVal = (Label)myCbSelected.FindControl("lblEmail");

//Label lblMobileVal = (Label)myCbSelected.FindControl("lblMobile");

//Label lblLandlineVal = (Label)myCbSelected.FindControl("lblLandline");

//Label lblCountryVal = (Label)myCbSelected.FindControl("lblCountry");

//Label lblAddressVal = (Label)myCbSelected.FindControl("lblAddress");

//Label lblPlatformVal = (Label)myCbSelected.FindControl("lblPlatform");

//Label lblHostingPlanVal = (Label)myCbSelected.FindControl("lblHostingPlan");

//Label lblYearsVal = (Label)myCbSelected.FindControl("lblYears");

//Label lblURLVal = (Label)myCbSelected.FindControl("lblURL");

//Label lblWebsiteSizeVal = (Label)myCbSelected.FindControl("lblWebsiteSize");

//Label lblRegistrationTypeVal = (Label)myCbSelected.FindControl("lblRegistrationType");

//Label lblServiceTypeVal = (Label)myCbSelected.FindControl("lblServiceType");

//Label lblDescriptionVal = (Label)myCbSelected.FindControl("lblDescription");

//Label lblLITKnowsByVal = (Label)myCbSelected.FindControl("lblLITKnowsBy");

//lblStoreName.Text += "<html>" + " You Have Selected :" +

// "<body>" +

// "<table border=\"1\" bordercolor=\"red\" align=\"center\" cellpadding=\"2\" cellspacing=\"2\" width=\"100%\">" +

// "<tr>" +

// "<td>" +

// "<table border=\"0\" align=\"center\" cellpadding=\"2\" cellspacing=\"2\" width=\"100%\bgcolor=\"green\">" +

// "<tr>" +

// "<td><p> Enquiry ID</p> </td>" +

// "<td width=\"35\"><div align=\"center\"> :</div></td>" +

// "<td >" + lblEnquiryIdVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p> Name </p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblNameVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p> Email ID</p> </td>" +

// "<td width=\"35\"><div align=\"center\"> :</div></td>" +

// "<td >" + lblEmailVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p> Mobile No</p> </td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblMobileVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Landline</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblLandlineVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Country</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblCountryVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Address</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblAddressVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Platform</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblPlatformVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Hosting Plan</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblHostingPlanVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Years </p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblYearsVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Domain Name</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblURLVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Site Size</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblWebsiteSizeVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Registration Type </p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblRegistrationTypeVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Type Of Services Requesting</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblServiceTypeVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Description</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblDescriptionVal.Text + "</td>" +

// "</tr>" +

// "<tr>" +

// "<td><p>Laxmi Hosting Knows By</p></td>" +

// "<td width=\"35\"><div align=\"center\">:</div></td>" +

// "<td >" + lblLITKnowsByVal.Text + "</td>" +

// "</tr>" +

// "</table>" +

// "</td>" +

// "</tr>" +

// "</table>" +

// "</body>" +

// "</html>";

Session["rec"] = lblStoreName.Text;

return "ViewDatagridDetails.aspx?RecordID=" + str.Trim();

}

protected void btnTest_Click(object sender, EventArgs e)

{

lblStatus.Text = "";

lblStoreName.Text = "";

lblStatus.Text = "<br>You selected the Following items:<br><br>";

StringBuilder EnquiryIds = new StringBuilder();

foreach (GridViewRow myCbSelected in gvDetails.Rows)

{

CheckBox chkSelected = (CheckBox)myCbSelected.FindControl("chkCheck");

if (chkSelected.Checked == true)

{

Label lblEnquiryIdVal = (Label)myCbSelected.FindControl("lblEnquiryId");

Label lblNameVal = (Label)myCbSelected.FindControl("lblName");

Label lblEmailVal = (Label)myCbSelected.FindControl("lblEmail");

Label lblMobileVal = (Label)myCbSelected.FindControl("lblMobile");

Label lblLandlineVal = (Label)myCbSelected.FindControl("lblLandline");

Label lblCountryVal = (Label)myCbSelected.FindControl("lblCountry");

Label lblAddressVal = (Label)myCbSelected.FindControl("lblAddress");

Label lblPlatformVal = (Label)myCbSelected.FindControl("lblPlatform");

Label lblHostingPlanVal = (Label)myCbSelected.FindControl("lblHostingPlan");

Label lblYearsVal = (Label)myCbSelected.FindControl("lblYears");

Label lblURLVal = (Label)myCbSelected.FindControl("lblURL");

Label lblWebsiteSizeVal = (Label)myCbSelected.FindControl("lblWebsiteSize");

Label lblRegistrationTypeVal = (Label)myCbSelected.FindControl("lblRegistrationType");

Label lblServiceTypeVal = (Label)myCbSelected.FindControl("lblServiceType");

Label lblDescriptionVal = (Label)myCbSelected.FindControl("lblDescription");

Label lblLITKnowsByVal = (Label)myCbSelected.FindControl("lblLITKnowsBy");

lblStoreName.Text += "<html>" + " You Have Selected :" +

"<body>" +

"<table border=\"1\" bordercolor=\"red\" align=\"center\" cellpadding=\"2\" cellspacing=\"2\" width=\"100%\">" +

"<tr>" +

"<td>" +

"<table border=\"0\" align=\"center\" cellpadding=\"2\" cellspacing=\"2\" width=\"100%\bgcolor=\"green\">" +

"<tr>" +

"<td><p> Enquiry ID</p> </td>" +

"<td width=\"35\"><div align=\"center\"> :</div></td>" +

"<td >" + lblEnquiryIdVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p> Name </p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblNameVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p> Email ID</p> </td>" +

"<td width=\"35\"><div align=\"center\"> :</div></td>" +

"<td >" + lblEmailVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p> Mobile No</p> </td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblMobileVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Landline</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblLandlineVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Country</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblCountryVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Address</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblAddressVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Platform</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblPlatformVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Hosting Plan</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblHostingPlanVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Years </p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblYearsVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Domain Name</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblURLVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Site Size</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblWebsiteSizeVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Registration Type </p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblRegistrationTypeVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Type Of Services Requesting</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblServiceTypeVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Description</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblDescriptionVal.Text + "</td>" +

"</tr>" +

"<tr>" +

"<td><p>Laxmi Hosting Knows By</p></td>" +

"<td width=\"35\"><div align=\"center\">:</div></td>" +

"<td >" + lblLITKnowsByVal.Text + "</td>" +

"</tr>" +

"</table>" +

"</td>" +

"</tr>" +

"</table>" +

"</body>" +

"</html>";

//lblStoreName.Text += lblEnquiryIdVal.Text + "," + lblNameVal.Text + "," + lblMobileVal.Text + "," + lblURLVal.Text + "<br>";

//string s=Convert.ToString(lblStoreName.Text);

//Response.Write(s);

Session["rec"] = lblStoreName.Text;

}

protected void gvDetails_DataBound(object sender, EventArgs e)

{

CheckBox cb = (CheckBox)gvDetails.HeaderRow.FindControl("chkHeader");

cb.Attributes.Add("onclick", "HeaderCheckbox('" + cb.ClientID + "')");

}

Hello,

You might just need to cast Value as a boolean in this case so it becomes something like this...

if (Convert.ToBoolean(dataGridViewEMail.Rows[i].Cells["Delete"].Value) == true)
or
if (((bool)(dataGridViewEMail.Rows[i].Cells["Delete"].Value) == true)

and by the way, in this case you're comparing with "true" so you can just remove the == true from the if statement since either case will already return true or false.

Simon

Next Recommended Forum

how to avoid the prompt dialoque in crystal report during loading

Taking long time in SSRS

Forum Statistics

Please welcome our newest member Sunil k.
2,381,240 users have contributed to 122,524 threads and 389,030
In the past 24 hours, we have 0 new threads, 0 new posts, and 1 new users.
In last week, the most popular thread is 'What is p0.dev'.

Upcoming Events

View all