in footer,i wrote suppress formula and also i checked supprss blank space.but a space is there
T
Thanusree Duth
@Thanusree Duth
Posts
-
remove blank space in page footer in crystal report -
put logo in crystal reportsHow to put logo(jpeg image) in crystal reports in vb .net?Hope ur help. :)
-
sen mail in asp .net 2.0Code that given by u is worked..Thanks a lot.But the mail go to Spam only,not in inbox.How to send mail in inbox? :)
-
sen mail in asp .net 2.0How to send email from local system to internet using asp .net 2,0?how to configure smtp?I googled a lot.But that code is not worked in asp .net 2.0..Help me
-
get data in financial year in sqlHow to get data in financial year(april -march) in stored procedure in sql server 2005?I googled a lot.But didnt find suit answer.Hope you help. :)
-
month numbers in sqlwe can get month names by using select datename(mm,getdate()).How to select the month numbers(eg:1,2,3...12) using select statement in sql server?Please suggest the format to select month numbers.
-
all languages in applicationIn my asp .net web application,I have to use all languages.How it will be done..Help me..
-
AutoComplete Extender in VS 2008Hi, AutoComplete Extender (using ajax autocompleteextender) is not working fine in VS2008 asp.net web application project.Database I used is MS Access 2007 Here is my code: using System; using System.Collections; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data; using System.Data.OleDb; /// <summary> /// Summary description for MyWebService /// </summary> [WebService(Namespace = "http://microsoft.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. //[System.Web.Script.Services.ScriptMethod] [System.Web.Script.Services.ScriptService] public class MyWebService : System.Web.Services.WebService { public MyWebService () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] [System.Web.Script.Services.ScriptMethod] public string[] GetCountryInfo(string prefixText) { int count = 10; string sql = "Select * from Country Where Country_Name like @prefixText"; OleDbDataAdapter da = new OleDbDataAdapter(sql, "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Documents and Settings/Leeds_Desk2/My Documents/trials.accdb"); da.SelectCommand.Parameters.Add("@prefixText", OleDbType.VarChar, 50).Value = prefixText + "%"; DataTable dt = new DataTable(); da.Fill(dt); string[] items = new string[dt.Rows.Count]; int i = 0; foreach (DataRow dr in dt.Rows) { items.SetValue(dr["Country_Name"].ToString(), i); i++; } return items; } } ASPX File ------------- <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:TextBox ID="TextBox1" runat="server" ></asp:TextBox> <asp:Button ID="Button1" runat="server" Tex
-
Number of query srtings and destination values are not matched"I am using MS Access 2007 and asp .net 2.0.When my application runs,an error occurs."Number of query srtings and destination values are not matched".I googled a lot.But didnt find any solution.when the data are inserted to the table,this error occured.I didnt use any primary key in table.
-
Panel ControlI m using asp .net 2.0.How to maximise the panel contol when the page is loaded in web application?Plese help..
-
ajaxHow autocomplete extender used in asp .net?For eg:in a textbox,when we type 'A' then the items start with 'A' will come in textbox from database?How it will appear?
-
sql function for day of weekI am in great confusion.:confused:I wrote a sql function to find the day of week.My query is shown below: ALTER FUNCTION dbo.udf_DayOfWeek (@dtDate datetime) RETURNS VARCHAR(10) AS BEGIN DECLARE @rtDayofWeek VARCHAR(10) SELECT @rtDayofWeek = CASE DATEPART(weekday,@dtDate) WHEN 1 THEN 'Sunday' WHEN 2 THEN 'Monday' WHEN 3 THEN 'Tuesday' WHEN 4 THEN 'Wednesday' WHEN 5 THEN 'Thursday' WHEN 6 THEN 'Friday' WHEN 7 THEN 'Saturday' END RETURN (@rtDayofWeek) END GO Call this function like this: SELECT dbo.udf_DayOfWeek('8/27/2010') AS DayOfWeek But I have to get output when fromdate and todate is given.ie:When fromdate='8/25/2010' and todate='8/27/2010',then the output is wednesday,Thursday,Friday..How to wrie sql function for this.Please modify the above code..Hope u will understand my problem Thanks in advance
-
sql functionI have created sql stored procedure to calculate work hours of employees in a week.EmployeeID,FromDate,ToDate,Department,Designation are the parameters passed.My output is: Day EmpID EmpName FirstTimeIn LastTimeOut WorkHours Break ------------------------------------------------------------------------- Wednesday 2855747 AlexanderMathew 9:01:09 AM 6:15:14PM 8:59:05 Thursday 2855747 AlexanderMathew 9:45:09 AM 6:45:09 PM 8:00:00 Friday 2855747 AlexanderMathew 9:08:09 AM 7:20:09 PM 9:00:00 Saturday 2855747 AlexanderMathew 9:30:09 AM 6:30:09 PM 8:00:00 Sunday 2855747 AlexanderMathew 9:32:09 AM 6:28:09 PM 8:00:00 Monday 2855747 AlexanderMathew 9:20:09 AM 6:25:09 PM 8:05:00 Tuesday 2855747 AlexanderMathew 9:02:09 AM 6:02:09 PM 8:30:00 But the problem is that,in my output 'day' is shown as row.But is there any way to display day as columns.ie: eg: EmpName Friday Saturday Sunday Monday Tuesday Wednesday WorkHours ------------------------------------------------------------------------- Alexander 07:11:18 Saturday Sunday 06:20:41 08:06:28 03:23:27 25:01:54 This stored procedure is for reporting.Hope you will help me to overcome this problem.. Thanks in advance
-
sum of work hours in rdlcIt is easy to calculate the SUM of Integers or Float values using Aggregate function 'SUM' in RDLC Report Viewer. But I am unable to calculate the SUM of Total Hrs Worked for an employee.Datatype of Total Hrs is varchar.That creates error.Is there any way out for this?Please suggest a wy to calculate sum in rdlc. :rolleyes:
-
rdlc page breakFirst I apologize u for my mistake..I will tell clearly my problem.i want to see output of my rdlc report page by page.What can I do for this?The report has enough records to display that do not fit on one page.Please help me..So I want to see output page by page.. :rolleyes:
-
page break of rdlc reportI am creating a report using rdlc files. I want page break at the end of a group , but not at the end of last one.I googled a lot.After 2 hrs of googling i dint found any correct solution.... In my example ,there is a lot of records.After 20 records,it will have to throw balance records to next page.I hav already put the condition for page break.It showed only 20 records.Please help me..Please reply fast..
-
sql functionI have created sql function and stored procedure to calculate work hours of an employee. timein,timeout,workingHours are the fields. eg: TimeIn TimeOut WorkingHours 9:20:00 AM 11:59:59 PM 14:39:59 00:01:00 AM 3:56:40 AM 3:55:40 I calculated workHours using datediff.I have to calculate the sum of WorkingHours also.What can I do for this??Really I m confused..:confused:
-
reportviewer in webI have created rdlc reports in web.Please suggest a sample code for using one report viewer for all reports.All reports will be in one report viewer.Reports will be shown according to radiobuttons..Please help me..Give me a sample code.:confused:
-
reportviewerI have created rdlc reports in web.Please suggest a sample code for using one report viewer for all reports.All reports will be in one report viewer.Reports will be shown according to radiobuttons..Please help me..Give me a sample code. :omg:
-
rdlcHoew grouping is done in rdlc using subreports in web application?