Dear All,
May I request your help for my bottleneck.
I am building RDLC report in my project that I developed in Visual Studio 2010.
I would like to get like this in my report
(Total In Amount - Total Out Amount).
Report Layout is as below.
In Grouping (Group By In)
#1.------------- In Amount1
#2.------------- In Amount2
...
mikewin86
Last Activity: Nov 18 '11, 06:17 AM
Joined: Mar 15 '10
Location:
-
RDLC Report Grouping at VB.Net 2010
-
Dear Joseph,
Thanks for your suggestion.
I have already talked to SQL Admin for it but they do not agree and do not want to modify back end.
So I have got headache to solve it from my program.
Mike -
Identity Insert
Dear All,
May I ask you a question.
I have got bottle neck in my application.
My vb.net program read Product info from one database and insert to another database.
I wanna to be same ProductID for all databases.
So I used Identity Insert statement in my code and it run properly with sa (system admin role) but it cannot work with other user who is not in system admin role.... -
Time Out Expire
Dear All,
May I ask a question to you all.
I have vb.net project that generate sales report from SQL Server Database.
I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.
May I request suggestion how... -
Error on insert: Invalid input parameter values..
Dear All,
May I request all of you to help me out.
I have a VBA project currently working with SQL Server 2000.
Now I changed back end to SQL Server 2005 and program give error as below when I insert new record.
Invalid input parameter values. Check the status values for detail.
I think that error is related with identity column.
May be failed... -
Packing unit Calculation
Dear All,
I would like to ask a question.
I can't query for product packing calculation.
Some Customer order includes loose units.
For e.g Customer want to get 1.5 carton Vitamin tablet.
(1 carton = 10 card)
So at bill, I need to show 1 carton and 5 pcs.
How can I query for above case?
Please help me for this problem.
... -
Thanks NeoPa.
It work well with my query.
Thanks all for your suggestions.Leave a comment:
-
Date Format in SQL Statement
Hello,
I would like to ask a question.
How can I format the Date Value in SQL Statement like this?
SELECT Format(OrderDat e,"MMM-yyyy") etc
In vb.net we can format Date Value like this.
Format(OrderDat e,"MMM-yyyy")
Thanks in advance
Mike -
Change text on messagebox button
Hello,
I would like to know how to change the text on the messagebox buttons.
For example, Yes and No buttons to Do and Don't etc.
Thanks in advance
Mike -
Hello Mr.Steven,
Thanks for your reply.
I have tried according to your suggestion.
But whatever changes I do at dataset, SqlClient codes change back to OLEDB codes.
So may I know how I can do it.
Thanks in advance.Leave a comment:
-
Change datasource for Dataset
Hello,
May I ask a question.
I have a vb.net window application project that connect to Access database.
I use dataset for all Forms and Reports.
Now I would like to change back end from Access database to SQL Server 2000 database.
I change the connection string(Data source, Data Provider etc)to connect to SQL Server 2000.
But it is not convenience bcos... -
Dataset is not refresh
Hello
I am a vb.net programmer. I use Visual Studio 2005. Now I am facing a problem.
I am developing a database application and I use dataset for data binding to SQL Server database. I added a table adapter to dataset and use that data table on the form as data grid view.Then I debug the project and I can't see any column and any data on data grid view. I rebuilt the dataset but nothing come out. So please help me how to solve... -
Yes friend. PurchaseID is numeric field and there are multiple records with same PurchaseID. I would like to get largest PurchaseID for each ProductID.Leave a comment:
-
I am sorry friend. I need in such a hurry. So I forgot to tell u what I really want. In fact I need all products(i.e. all products with last PurchaseID) from table. The one I show you is an example for product ID 20 and I have got about 100 product IDs.
Thanks for your patience.Leave a comment:
-
Thanks yarbrough. But it return only one row and include one product.Leave a comment:
-
Purchase Deatails Table includes the following fields.
PurchaseDetails ID
PurchaseID
ProductID
BatchNo
Quantity
Price
Amount
here sample data
200 100 20 100 A10000
201 101 20 120 B10001
202 ...Leave a comment:
-
Products with Last PurchaseID
Hello ,
I would like to ask a question concerned with SQL Server 2000 query.
I've got a table PurchaseDetails and I would like to query from it.
I want all product records with last purchase ID. The following is my query statements.
SELECT MAX(PurchaseID) AS LastID, ProductID, BatchNo
FROM PurchaseDetails
GROUP BY ProductID, BatchNo
When I run this query statements , I got...
No activity results to display
Leave a comment: