I have an RDLC report which sums totals for each group in VB.Net. It is working fine but what I want to do is to add a figure outside the group to only a particular group based on users selection.
Assuming there are three groups: Food Dept, Security Dept and Sales Dept. I want a figure 2000 to be added to only the Food Dept without affecting the Sales and Security Dept. Any help?
yashuaking
Last Activity: Dec 8 '16, 02:40 PM
Joined: Sep 2 '13
Location:
-
How to add a figure to only a particular group in vb.net RDLC report
-
Get other users online
I have a VB.Net Application that runs on MYSQL Server. It is almost done but want to add an extra feature to enable users to view other users online. I have created form called USERSONLINE with a Datagridview which has columns Full name and Ip Address. I also have a main form called MAINFORM which displays current user's full name and department. What I want to do is that on load of the USERSONLINE form, All the other computers on the local area... -
Wow! I have not tried it yet but I can see it would work. This is the best work around. This is just what I needed! Thank you Luk3r. I have been looking for a way to escape the @ symbol and this is it. -
The error has to do with the @sql you know Vb.Net the @ symbol is used for parameterized queries. So there should be a way to by pass it. The Error is occurs at this line:If (da.Fill(ds3, "searchdata 3")) Then DataGrid2.DataS ource = ds3.Tables(0)
The error is : "Fatal error encountered during command execution." It is a mysql error.
Vb.net does not even send the command to MYSQL to be processed because of...Leave a comment:
-
Trouble executing MYSQL prepared statement in VB.NET
I have a MYSQL dynamic Pivoting prepared statement that works perfectly in MYSQL commandline and Workbench but when I run the code in VB.NET it gives Fatal Error.
This is my code:
...Code:SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT('max(case when activeexamrecords.subjectid = ''', activeexamrecords.subjectid,''' then totalscore end) AS `', subjectname, '`'))INTO @sql FROM activeexamrecords JOIN Subjectlist -
This is the full code am using now
...Code:On Error GoTo Err_handler DoCmd.SetWarnings False Dim x Dim varReturn As Variant Dim intCtr As Long Dim StrWhere As String Dim strMsg As String Dim StrReport As String StrReport = "Form1Term1SR" If Me.Dirty Then Me.Dirty = False End If 'Initialize the Progress Meter, set Maximum Value = 100 x = DoEventsLeave a comment:
-
Ok thanks very much. It is working. Let me post the code here for clarification. I really appreciate you efforts to help me solve this problem.Leave a comment:
-
But thank you very much for the answerLeave a comment:
-
how do I dim X? Because I know that you have to dim X as somethingLeave a comment:
-
Thank you very much Twinnyfo
Actually the query the runs before the report opens is an Append Query. It only appends data to a table then the Report takes data from the table. So they are actually two separate events. I designed it this way because the Query is not able to append Pictures. I rather append a users ID to a table then the table is linked to another table by a primary key to get the picture. So you understand my situation now...Leave a comment:
-
I just saw this and saw your sample too. It works perfectly but I have a different case all together. Mine has to deal with the opening of a report. I have a form which opens based on the operation of queries. The report takes about a minute or two to open.I want the progress bar to stay on from the time command is click to open the report till the report is opened. Any help?Leave a comment:
-
yashuaking started a topic How to import data from MS Excel to MS Access QUERIES or FORMS instead of tablesin AccessHow to import data from MS Excel to MS Access QUERIES or FORMS instead of tables
I have school database with a table which contain the list of all subjects, Scores and grades. Because each teacher assess only one subject, I have created a query to separate the various subjects for the teachers so that each teacher would see only his subject in the form based on the query.
To make thing easier I want them to be able to upload an excel file for each subject.
Instead of importing into the main table, I want... -
Thank you all for the help I used another work around to achieve the results by looking at the link you provided. Thank you very very much. It has really solved my problemLeave a comment:
-
Thanks for the link that you have sent. I am checking it out.Leave a comment:
-
Thanks very much. I am giving it a try.Leave a comment:
-
Enter Data into a Subform with another Form instead of an Input box
I once posted an issue on this platform concerning entering data into a subform with an input box and was advised to rather use another form to enter data into the subform instead of an input box. I am writing a database program and I have seen the relevance of this advise. I realize that using another opened form to enter data into the subform is the best but am stuck. How do I reference the subform on this opened form which is totally separate... -
The Sub-Form is not based on query neither did I set the Data property on the sub form by filling in the Order By Property. I would do this to get the Result. Thank you very much. You have saved my day.Leave a comment:
-
How to stop disarrangement of records in ms access subforms.
I have a form with a sub-form in Ms Access 2010
The sub-form is in tabular view which shows records and their dates on entry including Payment Cycle.
The issue is sometimes when data is entered in the sub-form and the form is closed and opened again or refreshed, the records are disarranged.
So for example if data is entered in this manner
Payment CycleDate1 ... -
But is there a way to use a path similar to this one:I tried using it as the destination but I received an error. Am thinking I have to modify this code to fall into the split folder instead of fileCode:strSource = Split(Split(CurrentDb.TableDefs("AssessmentT").Connect, "Database=")(1), ";")(0)Leave a comment:
-
Ok I'll try it. Thanks very muchLeave a comment:
No activity results to display
Leave a comment: