1
Answer

How to add parameter in rdlc report?

Hello, in my RDLC report I need to show the SUM at the end of one column. For example

NAME  |  AGE  |  SALARY
 
 
 
............................................
                           @Sum_Salary

For this I go to "Report Data" -> Parameter -> Add new parameter
 
Here I did not know how to write query and where I write. I am using Visual Studi 2013.
 
Please help. 
Answers (1)
1
Vignesh Mani

Vignesh Mani

NA 13.4k 937.6k 9y
DateTime startTime = varValue  DateTime endTime = varTime  TimeSpan span = endTime.Subtract ( startTime ); Console.WriteLine( "Time Difference (seconds): " + span.Seconds ); Console.WriteLine( "Time Difference (minutes): " + span.Minutes ); Console.WriteLine( "Time Difference (hours): " + span.Hours ); Console.WriteLine( "Time Difference (days): " + span.Days );
0
Rajeev Punhani

Rajeev Punhani

NA 4.7k 402.4k 9y
 
DateTime start_time = Convert.ToDateTime("2014-12-04 08:10:32");
DateTime end_time = Convert.ToDateTime("2014-12-04 12:34:45");
TimeSpan t = end_time - start_time;
//Here t will be the time difference in format HH:MM:ss .So output will be 04:24:13
Response.Write(t);
//For getting in format what you expected just format timespan
var res = String.Format("{0}.{1}",t.Hours,t.Minutes);
Response.Write("<br/>"+ res);
0
Upendra Pratap Shahi

Upendra Pratap Shahi

NA 13.3k 861.3k 9y
TimeSpan time1 = TimeSpan.Parse(textBox1.Text);
TimeSpan time2 = TimeSpan.Parse(textBox2.Text);
TimeSpan difference = time1 - time2;
int hours = difference.Hours;
int minutes = difference.Minutes;
or
var first = new DateTime(2012, 05, 08, 10, 30, 00);
var second = new DateTime(2012, 05, 08, 11, 49, 13);
var diff = first - second;
var hours = diff.Hours;
var mins = diff.Minutes;
0
Vignesh Mani

Vignesh Mani

NA 13.4k 937.6k 9y

string sDateFrom = "11:56:00";
string sDateTo = "12:12:00";
if (DateTime.TryParse(sDateFrom, out dFrom) && DateTime.TryParse(sDateTo, out dTo))
{
TimeSpan TS = dTo - dFrom;
int hour = TS.Hours;
int mins = TS.Minutes;
int secs = TS.Seconds;
string timeDiff = hour.ToString("00") + ":" + mins.ToString("00") + ":" + secs.ToString("00");
Response.Write(timeDiff); //output 16 mins in format 00:16:00
}