C# :: How To Display Monthly Attendance Report
Jun 9, 2014
I have a table in sql called empattendancetable the fields are
eid empname designation logindatetime status
emp001 abc manager 30-05-201412;00PM present
likewise i want to display the month wise attendance details of all the employees
the logindatetime field value from datetimepicker i am not getting how to write the query to get the month wise detailsusing c# i am creating a windows application to maintain the details of employees
View 11 Replies
ADVERTISEMENT
Dec 5, 2012
I need to write a function that displays the days of a specified month. I have been looking for sample code but haven't had much luck. Here are the guidelines for the function:
Write a void function named displayCalendarDays. This function is passed two input parameters. The first parameter is an int that represents the start day. Start days are numbered from 0 to 6 with 0 representing Sunday and 6 representing Saturday. The second parameter is an int that represents the number of days in the month. If the start day is not in the range 0 to 6 or if the number of days is not in the range 1 to 31, the program should display useful error message instead of displaying a calendar. If the parameters are OK, the program should display a calendar similar to the following:
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
After the last day of the calendar is displayed, the function should advance the cursor to the next line.
Note that for the display above, the start day is 3 and the numbers of days is 31.
View 1 Replies
View Related
Feb 18, 2013
how to display date reange in crysta report , i have table contains :
id score date name
1 30 2-10-2012 x
2 40 3-10-2013 y
3 40 3-7-2009 z
1 45 5-10-2013 x
1 50 4-10-2009 x
ouput report:
id:1 name :x
2009-10| 2012-2013
50 30
40
View 2 Replies
View Related
Nov 19, 2014
Basically, I need to "write a program to simulate tracking monthly expenses" using an integer array into which the user can enter an expense. After that, it needs to loop back and ask them if they want to display their expenses or add another, which is the main thing I'm not sure how to make happen.
namespace Assignment2 {
class Program {
static void Main(string[] args) {
// display welcome message and ask if user wants to update or display monthly expenses
Console.WriteLine("Hello, this is a program to track your monthly expenses.");
[code]....
View 6 Replies
View Related
Oct 5, 2012
The point of this is to calculate the total of the monthly costs of these 6 expenses and then to show the annual cost. However, there's just a couple of things that's giving me problems and it's the calcMonCost in my code. The error says that it is more than one instance of overload function and also that an unresolved external symbol. Everything else is fine. What does this mean?
Code:
#include <iostream>
#include <iomanip>
using namespace std;
void calcMonCost (double, double, double, double, double, double &);
void calcAnnCost (double, double, double, double, double, double &);
void getData(double &lnPymnt, double &insure, double &gas, double &oil, double &tires, double &maint);
[Code] .....
View 1 Replies
View Related
Dec 6, 2014
i have project (person ID cared) and fortunately i could finish it in programming,,,,, but the thing that i don't know what to do about it is how to print this data? can i use reportviewer ?
View 4 Replies
View Related
Aug 28, 2013
For a school homework i had to make a c++ program to generate a report card so i made this program
#include<iostream.h>
#include<conio.h>
void main()
{
[Code].....
The problem is that it does not take any values ps I have been learning C++ for 3 months so we don't have any arrays,at max we have iterations
View 5 Replies
View Related
Sep 27, 2014
I'm trying to write a table (2D array) with a string of random chars in one row for the student names, six other rows for the project numbers and random numbers for the grades.Then calculate the averages of grades per student and per project, add them as the last row and the last column. And write a menu of 4 options:
1- sort per student names (alphabetical order)
2- sort per student grades (in increasing order)
3- sort per project grades ( in increasing order)
4- exit
The program must continue execution after displaying any report, need to use an infinite loop, it exits only if the chosen 'exit'.
Here's what I have:
#include <ctime>
#include <string>
#include <iomanip>
#include <iostream>
using namespace std;
ints=12,p=6;
stringnames[20];
[Code] ....
And then, I need to show interactively the same report with all types of sorting:
sort table by any row, (user enters the row number)
sort table by any column. (user enters the col number)
sort table sorted by student names as well.
View 12 Replies
View Related
Oct 12, 2014
#include <iostream>
#include <cmath>
using namespace std;
void summary();
const float below100 = 0.10;
const float after100 = 0.05;
[Code] .....
It cannot loop back to the top coding, cause what i want is the code can loop back to the 1st cout question, and it will asking over and over again, and how to declare a function for the summary report?
View 2 Replies
View Related
Apr 7, 2014
I use rdlc report in C# . I have a Table Item in the form to show all record but it show all record except first record .
View 4 Replies
View Related
Jun 30, 2014
#include <iostream>
#include <iomanip>
#include <fstream>
using namespace std;
// Function prototype
void getScore(int &);
void calcAverage(int, int, int, int, int);
[Code] ....
this is what I have so far but I a stuck. The name of the file is grades.txt.I am trying to get the program to read 5 grades from a file and report back lowest grade that will be dropped and average of 4 left. It runs but is not reading the file.
View 3 Replies
View Related
Mar 10, 2013
I'm having trouble with how to find the count and sum of all numbers.
The file, called question1.txt, contains numbers:
1
2
3
4
5
0
0
0
-2
-2
Here's my code:
Code:
#include <stdio.h>
#include <stdlib.h>
int main (void)
{
FILE* spIn;
FILE* spOut; //for output file
int numIn;
[Code]...
View 1 Replies
View Related
Apr 2, 2014
i have 2 tables with primary and foreign key
Customer Details
EID - Primary Key
PurchaseDetails
PNo-Primary Key
PDate,
EID- Foreigh Key
NetAmount
Report Query written in c#
SELECT DISTINCT P.PNo, P.PDate, P.PM, P.DisAmt, P.LT, P.NT, P.EID, P.PTime, C.EName FROM PurchaseDetails AS P INNER JOIN CustomerDetails AS C ON P.EID = C.EID
In Report Automattically linked based key.
but report data not showing
View 1 Replies
View Related
Jan 31, 2015
I created a dataset that contains an empty dataTable that has several columns , and then I created a new report that is linked to this datatable using the report wizard. In my form there is a button when clicked should fill the datatable mentioned above ( I checked if it is being filled by displaying its content in a dataGridView and by firing a messagebox that is triggered when 'datatable.rows.count > 0' ).
The reason that the datatable is initially empty is that it depends on some conditions that may alter the query used to fill it.
But finally when I load the form that has the report viewer it only has the names of the columns of the datatable and no contents. What's wrong ?
View 5 Replies
View Related
Feb 21, 2014
Below is my Code Code snippet wher I am facing problem.
every time "pNMHDR->idFrom" is returning 0.
I even put "EnableToolTips(TRUE);" in the oninitdialog method of dialog class.
BEGIN_MESSAGE_MAP(CMyListCtrl, ListCtrl)
.
.
.
ON_NOTIFY_EX(TTN_NEEDTEXTW, 0, OnToolTipText)
ON_NOTIFY_EX(TTN_NEEDTEXTA, 0, OnToolTipText)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
[Code] .....
I am not able to get the text of a listctrl cell.
View 3 Replies
View Related
May 3, 2013
I'm writing a program that writes to a report in a text file. It uses a struct but with no array. How can I write this so that the report comes out as it should because as of now after i removed the brackets from record which is the variable of the struct my report isn't printing right.
View 8 Replies
View Related
Nov 5, 2014
Here is the assignment... Write a program to generate a report based on input received from a text file. Suppose the input text file student_status.txt contains the student’s name (lastName, firstName middleName), id, number of credits earned as follows :
Doe, John K.
3460 25
Andrews, Susan S.
3987 72
Monroe, Marylin
2298 87
Gaston, Arthur C.
2894 110
Generate the output in the following format :
John K. Doe 3460 25 Freshman
Susan S. Andrews 3987 40 Sophomore
Marylin Monroe 2298 87 Junior
Arthur C. Gaston 2894 110 Senior
The program must be written to use the enum class_level :
enum class_level {FRESHMAN, SOPHOMORE, JUNIOR, SENIOR } ;
and define two namespace globalTypes (tys and fys) for the function :
class_level deriveClassLevel(int num_of_credits) ;
The function deriveClassLevel should derive the class_level of the student based on the number of credits earned.
The first namespace globalType tys should derive the class level based on a two year school policy. And the second namespace globalType fys should derive the class level based on a four year school policy.
Four Year School Policy:
Freshman 0-29 creditsSophomore 30-59 credits
Junior 60-89 creditsSenior 90 or more credits
Two Year School Policy:
Freshman 0-29 creditsSophomore 30 or more credits
and this is the code I have so far...
#include <cstdlib>
#include <iostream>
#include <cctype>
#include <fstream>
using namespace std;
enum class_level {FRESHMAN, SOPHOMORE,JUNIOR,SENIOR};
class_level classLevel;
[Code] .....
My main question is did I use the namespaces and enum correctly? And my second question is whats the best way to input the data from the text file? This is really where I get stuck.
View 3 Replies
View Related
Nov 7, 2014
Write a program to generate a report based on input received from a text file. Suppose the input text file student_status.txt contains the student’s name (lastName, firstName middleName), id, number of credits earned as follows :
Doe, John K.
3460 25
Andrews, Susan S.
3987 72
Monroe, Marylin
2298 87
Gaston, Arthur C.
2894 110
Generate the output in the following format :
John K. Doe 3460 25 Freshman
Susan S. Andrews 3987 40 Sophomore
Marylin Monroe 2298 87 Junior
Arthur C. Gaston 2894 110 Senior
The program must be written to use the enum class_level :
enum class_level {FRESHMAN, SOPHOMORE, JUNIOR, SENIOR } ;
and define two namespace globalTypes (tys and fys) for the function :
class_level deriveClassLevel(int num_of_credits) ;
The function deriveClassLevel should derive the class_level of the student based on the number of credits earned.
The first namespace globalType tys should derive the class level based on a two year school policy.
The second namespace globalType fys should derive the class level based on a four year school policy.
So I basically did it in parts and got everything working and then had to make the namespace so I had this:
#include <iostream>
#include <fstream>
#include <string>
using namespace std;
enum class_level { FRESHMAN, SOPHOMORE, JUNIOR, SENIOR };
[Code] ......
I know I have to clean it up and change it but it ran like it was suppose to. Then I tried adding the global namespaces and I this:
#include <iostream>
#include <fstream>
#include <string>
using namespace std;
enum class_level { FRESHMAN, SOPHOMORE, JUNIOR, SENIOR };
class_level classLevel;
[Code] ....
with this i keep getting an error saying tys::deriveClassLevel: must return a value and tys::fys::deriveClassLevel: must return a value. I have been messing around with this part and struggling I thought I used the namespace to run the if statements with the criteria for the years of school. Basically I have been stuck for awhile and trying to change things around but I cant seem to get it to work.
View 2 Replies
View Related
Sep 20, 2014
I want to print a report half sheet in A4 size..
I tried to change paper size in coding and in properties also but no use..so what is the correct code to change as custom size of report.
View 1 Replies
View Related
Nov 11, 2014
Write a program to generate a report based on input received from a text file. Suppose the input text file student_status.txt contains the student’s name (lastName, firstName middleName), id, number of credits earned as follows :
Doe, John K.
3460 25
Andrews, Susan S.
3987 72
Monroe, Marylin
2298 87
Gaston, Arthur C.
2894 110
Generate the output in the following format :
John K. Doe 3460 25 Freshman
Susan S. Andrews 3987 40 Sophomore
Marylin Monroe 2298 87 Junior
Arthur C. Gaston 2894 110 Senior
The program must be written to use the enum class_level :
enum class_level {FRESHMAN, SOPHOMORE, JUNIOR, SENIOR } ;
and define two namespace globalTypes (tys and fys) for the function :
class_level deriveClassLevel(int num_of_credits) ;
The function deriveClassLevel should derive the class_level of the student based on the number of credits earned.
The first namespace globalType tys should derive the class level based on a two year school policy.
and the second namespace globalType fys should derive the class level based on a four year school policy.
Four Year School Policy:
Freshman 0-29 creditsSophomore 30-59 credits
Junior 60-89 creditsSenior 90 or more credits
Two Year School Policy:
Freshman 0-29 creditsSophomore 30 or more credits
NOTE : use ignore() function with ifstream objects whenever you want to ignore the newline character.
For example :
ifstream transferSchoolFile ;
transferSchoolFile.open("student_status.txt", ios::in);
while( !transferSchoolFile.eof()) {
getline(transferSchoolFile,name) ;
transferSchoolFile >> id >> credits;
transferSchoolFile.ignore(); //Used here to ignore the newline character.
….
}
I did this in parts so I got it working with a four year criteria without the user defined name spaces.
include <iostream>
#include <fstream>
#include <string>
using namespace std;
enum class_level { FRESHMAN, SOPHOMORE, JUNIOR, SENIOR };
[Code] ....
So that worked fine then I tried with name spaces -
#include <iostream>
#include <fstream>
#include <string>
using namespace std;
enum class_level { FRESHMAN, SOPHOMORE, JUNIOR, SENIOR };
class_level classLevel;
[Code] ....
I know I have some stuff to mess around with but I am currently stuck with two errors, first -
Error1error LNK2019: unresolved external symbol _main referenced in function ___tmainCRTStartupC:UsersstephenDocumentsVisual Studio 2013ProjectsinputConsoleApplication1MSVCRTD.lib(crtexe.obj)ConsoleApplication1
then -
Error2error LNK1120: 1 unresolved externalsC:UsersstephenDocumentsVisual Studio 2013ProjectsinputDebugConsoleApplication1.exeConsoleApplication1
View 1 Replies
View Related
Nov 11, 2014
Program Description: Write a program to generate a report based on input received from a text file. Suppose the input text file student_status.txt contains the student's name (lastName, firstName middleName), id, number of credits earned as follows :
Doe, John K.
3460 25
Andrews, Susan S.
3987 72
Monroe, Marylin
2298 87
Gaston, Arthur C.
2894 110
Generate the output in the following format :
John K. Doe 3460 25 Freshman
Susan S. Andrews 3987 40 Sophomore
Marylin Monroe 2298 87 Junior
Arthur C. Gaston 2894 110 Senior
The program must be written to use the enum class_level :
enum class_level {FRESHMAN, SOPHOMORE, JUNIOR, SENIOR } ;
and define two namespace globalTypes (tys and fys) for the function :
class_level deriveClassLevel(int num_of_credits) ;
The function deriveClassLevel should derive the class_level of the student based on the number of credits earned.
The first namespace globalType tys should derive the class level based on a two year school policy.
and the second namespace globalType fys should derive the class level based on a four year school policy.
Four Year School Policy:
Freshman 0-29 creditsSophomore 30-59 credits
Junior 60-89 creditsSenior 90 or more credits
Two Year School Policy:
Freshman 0-29 creditsSophomore 30 or more credits
NOTE : use ignore() function with ifstream objects whenever you want to ignore the newline character. For example :
ifstream transferSchoolFile ;
transferSchoolFile.open("student_status.txt", ios::in);
while( !transferSchoolFile.eof()) {
getline(transferSchoolFile,name) ;
transferSchoolFile >> id >> credits;
[Code] ....
I know I have some stuff to mess around with but I am currently stuck with two errors, first -
Error1error LNK2019: unresolved external symbol _main referenced in function ___tmainCRTStartupC:UsersstephenDocumentsVisual Studio 2013ProjectsinputConsoleApplication1MSVCRTD.lib(crtexe.obj)ConsoleApplication1
then -
Error2error LNK1120: 1 unresolved externalsC:UsersstephenDocumentsVisual Studio 2013ProjectsinputDebugConsoleApplication1.exeConsoleApplication1
View 2 Replies
View Related
Apr 19, 2014
I created class called students which suppose to store students names of in array but when I call the display function it display only the first name. but I want it to display names depending on the array size.
#include <iostream>
#include <sstream>
using namespace std;
const int SIZE=5;
[Code]....
View 3 Replies
View Related
Dec 6, 2013
I know this is more simple than I am making it out to be. I have a solar panel hooked up to an 8-Bit ADC and linked into my Microprocessor. I am trying to take the Binary readout from the ADC and convert it to a decimal number to be displayed on the boards LCD display. I am wiring the ADC to PORTA on my Motorola Freescale Board. This is for a final project for my electronic systems class due on Monday...
View 3 Replies
View Related
Mar 26, 2014
#include <iostream>
#include <windows.h>
#include <conio.h>
#include <ctype.h>
[Code]....
When I press the up key it will not display anything.
View 2 Replies
View Related
Oct 6, 2013
My code is:
#include <iostream>
#include <string>
#include <cstdlib>
[Code]....
The problem is that the images don't display and the window doesn't respond.
View 5 Replies
View Related
Jan 30, 2015
I am stuck on my program right now, what i am trying to do is get the sum of the amount from a access database table and than display it on a label, however i cant seem to get this to happen. This is what I have so far:
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Church.accdb";
conn.Open();
Form1 frm1 = new Form1();
//frm1.Show();
//string tableName = frm1.tableName;
//string time = "4/5/1991";
string fullName = memberscmb.Text;
[code]....
View 14 Replies
View Related
