Search:
Type: Posts; User: Carmell
Search:
Search took 0.02 seconds; generated 55 minute(s) ago.
-
I create a formula to my crystalreport and added to my details how ever it only produce one line of details which is the end date of the loan
local numbervar i ;
local stringvar output;
for...
-
I am actually trying to create a report that shows the Amortization Schedule using Crystal Report. I am curious if its possible to do this with this kind of format.
I have an input coming from...
-
Thank you guys for your help.
I solved the problem using Lavolpe solution.
:)
-
160495
I'm getting this error when generating report.
The error falls in this line.
.SelectionFormula = "{View_MasterInfo.EmployeeType} <> 'RANK & FILE' and...
-
The value of my dates in my database is ="MMDDYYYY"
I insert it using this code:
replace(convert(varchar(10), date, 101), '/', '')
it returns like this output
06072018
-
How can I group by transactions like this
'0:01AM -1:00 AM' and it will interpret as 01
'1:01AM-2:00 AM' as 02
'10:01 PM-11:00 PM' as 23 and so on..
because I need to create a txtfile with...
-
This is my problem for a year now hehe
-
I dunno if it its possible to generate a table that find the difference of one row to another.
Just like this:
157461
it is group by by ID and sorted by date..
Let's assume that the...
-
What do you think is wrong in my code?
I have this error, see the pic below.
157457
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
strsql = "SELECT * FROM...
-
Hi I am starting to learn VB.NET and I am little bit confused right now.
I want to create a connection string dynamically at run time.
I made a module for it and I want to call it everytime I...
-
WHY IT RETURNS 0 WHEN I CREATE A FORMULA FIELD IN CRYSTAL REPORT?
CODE:
if {Consumption_Branch;1.CLASSIFICATION}="CHILLED" then
if {Consumption_Branch;1.Vatable}=True then
global numbervar...
-
I'm actually looking for an idea of how to do that. The table is located at SQL SERVER 2005 and I'm working with VB6. I want to create a button that allow to insert those data in one table including...
-
Hi I want to create a stock ledger from my given tables.
tbl_ItemInventory
CODE
DESCRIPTION
BEGINNING QTY
UOM
DATE
-
If stogrid.Row >= 1 And stogrid.Col = 4 And stogrid.TextMatrix(stogrid.Row, 4) <> "" Then
For i = 1 To stogrid.Rows - 1
If Trim(checkinventory(stogrid, issuedby)) <> Empty Then
itm...
-
actually i dont know what WINE is hehhehe
-
Hi , the database stored in a local computer only.
-
Oh I'm sorry ,
here's the code for that function
Function SearchUOM(strS As String, UOMStr As String, Row As Long)
Call con
If rs.State = 1 Then rs.Close
rs.CursorLocation = adUseClient
-
I made a program that the user can enter an item per row, however if the row is already 15 rows above the system is already hanging/lagging/freezing the user needs to wait a minute to process the...
-
Can someone please help me how to generate a text file from sql table?
The text file will save into a certain location?
I will have an export button that will trigger the generation.
I am...
-
Thanks to all of you for enlightening me.
here's my final working code now, based to your suggestions.
Do Until rs.EOF = True
If Not rs.Fields(6).Value = 0 Then
rrgrid.AddItem "" & vbTab...
-
Please help me.
I'm having trouble using loops.
This is my current code:
While rs.EOF = False
rrgrid.AddItem "" & vbTab & rs.Fields(0).Value & vbTab & _
rs.Fields(1).Value & vbTab & _...
-
thank you for your help :)
-
Hi I need help,
Is it possible to combine tables using temporary table?
For example I have 2 tables.
tbl_NewHire
Name
Birthday
DateHired
-
-
Hi.
I've got a report which has a group footer.
The footer sometimes appears by itself on a page. The previous page is full and so the footer (just some totals) appears on the following page.
...
-
Good Day!
I need your help guys, I'm having a problem calling my report using parameters.
I got this error.
148129
I'm trying to print a report that filters the date selected by the user.
-
if I'm going to recreate my reports same thing happened. the error still occurs.
-
it's alter because I click the modify option to view the codes for stored proc
by the way i tried to recreate the report however the error still there
-
Everytime I print the report. There is always a pop-up error of "The database file <file name> has changed. Proceeding to fix up the report!" then click OK.
This is so annoying. I understand that...
-
142449
i encounter that error only on my computer, i tried to install it on other computer but it works fine...
help pls...:confused:
-
Hi, I need your idea guys regarding on my problem. I have a table for example name fruits, the data on it is already fixed. The problem is it consist of 900000+ rows so it takes time for the data to...
-
it triggers also the same error..
on first attempt it works,
on second not..
on debug mode the .selrow is equal to -1?
-
I'm very very very confused I didn't make any alteration, but it works sometime but very seldom .. :confused:
-
sometime it works, sometime not :confused:141199
it works after many tries then it will not work again and encounters error
-
141197
i have a grid what i want is ,every time i clicked the cell in column 1 in any row the value will show in textbox.
I already try it and here is my existing code (not working):
Private...
-
it disapper when I click anything in menu..
-
Me, myself confused also :confused:
I need someone who can guide me or correct me.
It can be FTP as long as it can transfer files.
But I don't know how to do it, or where to start.
The thing that...
-
Hi, I'm wondering how can I create a simple file transfer application (online based). For example : I will send a .txt file and can receive also? Is that possible? I still dont have idea :cry:
...
-
-
Thanks Westconn1 and Arnoutdv :wave:
|
Click Here to Expand Forum to Full Width
|