Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fassi
Starting Member
7 Posts |
 Posted - 2011-11-10 : 17:53:59
|
| Hi Guys,I have report generator application for Sql database, first of all when I opened the application it asked for Login Name and password, after login it have two options (command buttons)1.Daily Report & 2.Date Range Report when I click on DAILY REPORT it gives following error:Invalid name 'dayclose'.......and option of OK,when I press OK it gives another message like this:there is no day close or no record is found........and option of OKand when i click on DATE RANGE REPORT, a new window is opened which have option of data selection form Start Date and End Date....after selecting start date and end date it gives following message:the sum or average aggregate operation can not take a varchar data type as an argument.please help**fassi** |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-11 : 03:29:53
|
| whats the application you're using? From what I understand , there some problem in way parameters are set up in report which are causing these error. Are you using sql reporting services?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
fassi
Starting Member
7 Posts |
Posted - 2011-11-11 : 04:58:07
|
| i m using SQL database which is related to Point of sale. and this application generates Day Close report**fassi** |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-11 : 05:05:00
|
quote:
Originally posted by fassi
i m using SQL database which is related to Point of sale. and this application generates Day Close report**fassi**
I'm asking about reporting application.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
fassi
Starting Member
7 Posts |
Posted - 2011-11-11 : 12:53:30
|
| this application named as Reports.exe and the application which runs my POS database is also an .exe application, I think these applications are build in visual C# but when these applications were provided to me for use were in exe formats.and second that POS.exe application which I m using have also Close Day & Close Month options but these option did not work properly. I think any table or command in database is missed which count bills generated on table, take away, paid through credit card, total sale and cash.Database have tbl_Orders, tbl_OrderDetail,etc etcall orders are saved in database in specific table but I don't know how can I get Close Day or Month Close reports.**fassi** |
|
|
|
|
|
|
|
|
invalid column name 'dayclose'