Comments by Pratika05 (Top 29 by date)

is my solution right

it shows error

i have tried
ValidationExpression="^(((0[1-9]|[12]\d|3[01])\/(0[13578]|1[02])\/((1[6-9]|[2-9]\d)\d{2}))|((0[1-9]|[12]\d|30)\/(0[13456789]|1[012])\/((1[6-9]|[2-9]\d)\d{2}))|((0[1-9]|1\d|2[0-8])\/02\/((1[6-9]|[2-9]\d)\d{2}))|(29\/02\/((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))))$"

for validating date but i also want to validate age in same expression

thanks it helps

i have started it but not included that line here but again exception is not printed in label

using javascript

at design page

thks it workss

pls expalin it more

incorrect syntax

select
(IsNull(House_Name_No,'') +','+IsNull(City,'')+','+IsNull(State,'')
from emptable

this is my query if a record has no values for these i got ,,, but i want a space not ,,,

thanks yupiii i got it

if all fields are blank i need a space or nothng but not this ,,,

no this does not solve my problem i am getting ,,, if fields are blank

no i want comma in between each part house no,city,state

At line viewer.LocalReport.SetParameters(Param); it gives error if i rempve it everything works fine.

My code is:

private void CreatePDF(string id, string pid)
{
string issalaried = "";
DataSet DsRep = getemplyeebasicdetail(id, pid);
DataSet dssalaryDetails = getemplyeesalarydetail(id, pid);
DataSet dsEmployeeCount = GetEmplyoeeCount(id, pid);
int rowcount = dssalaryDetails.Tables[0].Rows.Count;
if (rowcount == 0)
{
DataRow dr = dssalaryDetails.Tables[0].NewRow();
dssalaryDetails.Tables[0].Rows.Add(dr);
}
else
{
Boolean salaried = false;
foreach (DataRow dr in dssalaryDetails.Tables[0].Rows)
{
if (dr["issalaried"].ToString() == "Y")
{
salaried = true;
}
}
if (salaried == false)
{
issalaried = "N";
}
else
{
issalaried = "Y";
}

}
ReportDataSource datasource = new ReportDataSource("DS1", DsRep.Tables[0]);
ReportDataSource datasourcefamily = new ReportDataSource("DS2", dssalaryDetails.Tables[0]);
ReportDataSource datasourcecount = new ReportDataSource("DS3", dsEmployeeCount.Tables[0]);
ReportParameter[] Param = new ReportParameter[1];
Param[0] = new ReportParameter("Param_IsSalaried", issalaried);

Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
// Setup the report viewer object and get the array of bytes
ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = ProcessingMode.Local;
viewer.LocalReport.ReportPath = Server.MapPath("~\\Employee.rdlc");
//Datasource
viewer.LocalReport.DataSources.Add(datasource);
viewer.LocalReport.SetParameters(Param);
viewer.LocalReport.EnableExternalImages = true;
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);



// Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=" + "Employee" + "." + extension);
Response.BinaryWrite(bytes); // create the file
Response.Flush(); // send it to the client to download

//Page settings for PDF File.


}

thanks....good code

SELECT * FROM Table1
But My table has only 5 records but I want to show 10 out of which 5 rows are blank

Select * from tblemp
it returns 5 rows as there are 5 records in table but i want to show 10 blank rows also in rdlc reports

thanx i got but does this way ever give me error oor wrong output

But I need result in tabular Format Like I have query Select count(*)as greater12 from tbl_emp where age>12 Select count(*)as less12 from tbl_emp where age<12 Now I want this Type of result greater12 less12 34 2

You can use menu control
<asp:Menu ID="Menu1" runat="server" Orientation="Horizontal" CssClass="menu">


and bind it dynamicaly

But I need result in tabular Format Like I have query
Select count(*)as greater12 from tbl_emp where age>12
Select count(*)as less12 from tbl_emp where age<12
Now I want this Type of result
greater12 less12
34 2