|
Make sure the Path property contains a valid path.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Hi,
Thanks for that, I didnt have a clue before why it would'nt work!
Thanks,
Lloyd J. Atkinson
|
|
|
|
|
You're welcome.
The only thing I did was rephrase the error message...
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Hi everyone,
I am working on billing project.
I want to print calculated amount in words for Reports.
Reports are generated in Crystal Report 8.0
e.g.
Amount = 6,45,840/- Rs.
In Words “Six Lakhs Forty Five Thousand Eight Hundred Forty Only.”
Currently I am using to “towords()” function to convert numeric value to string.
Current I am having two problems.
1) Numeric values are not displaying properly
values like 6,45,000 are displaying as 645,000. I am not able set thousand separate for values in Lakhs.
2) Words are not correct for values like 100,000 i.e. One Lakh and so on.
e.g.
If the Amount = 6,45,840/- Rs.
It is printing Words as “Six Hundred forty-five thousand eight hundred forty only”
Instead of “Six Lakhs Forty Five Thousand Eight Hundred Forty Only.”
Please tell me how to solve this problem.
I am using Crystal Report 8.0 as Reporting tool and Visual Basic 6.0
Kiran Sajanikar
Software Engineer
CleverBIT softwares.
Pune.
|
|
|
|
|
|
<br />
<br />
SqlStr = "SELECT partno, itemdetails FROM tblpurchaseitem WHERE partno in (select partno from StockMaster where stockgroup='" & Combo1.Text & "') and number in (select number from tblpurchase where pur_date>=#" & Format(mskdate, "mm/dd/yyyy") & "# and pur_date <=#" & Format(mekdate, "mm/dd/yyyy") & "# and purchase_form='Purchase') and purchase_form='Purchase' group by partno,itemdetails"<br />
<br />
hello friends i want the Sum(quantity) feild also on the reports the query works fine but someone tell me how the that feild could added to Crystal report
with regards
yogesh
|
|
|
|
|
You can calculate the sum of quantity in the Crystal Reports by just adding a formula field into the crystal reports, in the formula editor right the following code:
Sum ({TableName.ColumnName})
e.g.
Sum ({Sales.quantity})
Then just place the created formula field into your report.
Hope it helps !
AliAmjad(MCP)
|
|
|
|
|
I tried the same but it will display the th error
that is
"Error Detected by database Dll"
plz sugges the another option
regards
yogesh agarwal
|
|
|
|
|
Did you add the Table into your crystal reports document viewer under Database fields before calculating the Sum and successfully be able to connect to the database?
AliAmjad(MCP)
|
|
|
|
|
<br />
With CrystalReport1<br />
.SQLQuery = SqlStr<br />
.ReportFileName = App.Path & "\Reports\rep_ItemEnqSPG.rpt"<br />
.Formulas(0) = "startdate= '" & mskdate.Text & "'"<br />
.Formulas(1) = "enddate= '" & mekdate.Text & "'"<br />
.Formulas(2) = "name= '" & Rs!Name & "'"<br />
Wend<br />
.Action = 1<br />
End With<br />
<br />
<br />
I am not using the Viewer my code is mention above
all the feilds works fine only aggrigate function feild not working
regards
yogesh
|
|
|
|
|
Open your report rep_ItemEnqSPG.rpt and establish a connection with your database then add the table which has the quantity field then try to use the formula field.
AliAmjad(MCP)
|
|
|
|
|
I Have comleted our login form and when user input valid user name and password then he/she move to the MDI Form but I Want to close login form after enter valid username and password
from samarjeet singh
Kanpur(UP) india
samarjeet singh
(Software Engineer)
|
|
|
|
|
if you use VB then use unload function
|
|
|
|
|
well if your login form is startup form, and you are using VS2005 then just use
closing_button_click()
me.close()
if using VS2003 then hide the form by
<br />
me.hide()
for closing the complete application , you can use
application.exit()
|
|
|
|
|
You cannot set the Startup object to be the login form. Closing the startup form will close your entire application because the app's message pump is attached to it.
Your startup form should be your applications main form. In that form's code, you check to see if the user is logged in, if not, then you put up the login form to get authenticated. There should be a button in the login form to Cancel the login. Your main form's code should take that to mean it should quit.
|
|
|
|
|
But you can set it as the startup form and just tell it to hide (vs2005) without problems.
|
|
|
|
|
Not a good desgin, but it works.
|
|
|
|
|
I'm creating an application that launches a splash page when it is started. I want the splash to remain on the screen for 5 seconds and than it would disappear and the main form would appear. I have been playing around using the timer component but cannot seem to get it to work. Anybody know of a good tutorial for this or have advice on what to do as I'm a newbie?
Thanks
|
|
|
|
|
If you are working under Visual Studio 2005 then you can display the Splash screen just by going to the Project properties and on Application Tab just check the box 'Enable Application Framework' and choose your Splash Screen from the Splash Screen drop down and select the startup form from the
"Startup Object" drop down. No need to use timers here. But if you are not then just add a timer control to the form set its Enabled property to 'True' change the interval to '5000' for five seconds then in the Timer's Tick event just enter the following code:
Me.Timer1.Enabled = False
Me.Hide()
Dim frm_main as new MainForm()
frm_main.Show()
Hope it helps !
AliAmjad(MCP)
|
|
|
|
|
AliAmjad,
Thanks for the tips. I'm using a splash page but I still cannot get it close after 5 seconds. Any advice on how to do that which is what I was going to use the timer for as I was trying to get it wait for the timer to countdown and than close the form.
THanks again
|
|
|
|
|
I am writng an editable grid in my vb.net2005 project. The code is working fine but text box is not well positioned in the grid cell, for me to see what im entering in teh text box
im using something like this in teh FG_Keypress event
textbox.setbound(fg.left+fgcell.left,fg.top+fgcell.top,fgcell.width,fgcell.height)
any help will be appreciated.
t.aransiola
|
|
|
|
|
Why are you using the old FlexGrid?? What are you doing that will not let you use .NET 2.0's DataGridView??
|
|
|
|
|
i need an editable grid like Flexgrid in vb6.0. There is AXMSFlexgrid in .net 2005 that works like vb6.0 flexgrid just that the properties and methods arent teh same
See my code below, if there is any help u can render
thanks
positioning a textbox control in the grid cell
I am using this control in my vb.net2005 project
im using something like this in teh FG_Keypress event
Private Sub Fg_KeyPressEvent(ByVal sender As Object, ByVal e As AxMSFlexGridLib.DMSFlexGridEvents_KeyPressEvent) Handles Fg.KeyPressEvent
Select Case e.keyAscii
Case 13
e.keyAscii = 0
Fg.Focus()
Exit Sub
End Select
With Fg
' block the qty remaining column not to accept any entry
Select Case .Col
Case 0
EditBox.Enabled = False
Exit Sub
Case 1
'to upcase col1 cell entry
e.keyAscii = Asc(UCase(Chr(e.keyAscii)))
EditBox.Enabled = True
End Select
EditBox.Text = Chr(e.keyAscii)
EditBox.SelectionStart = 1
EditBox.Visible = True
'
'note: the problem is here,
'
EditBox.SetBounds(.Left + .CellLeft, .Top + .CellTop, .CellWidth, .CellHeight)
EditBox.Focus()
End With
btnSave.Enabled = True
End Sub
the code works fine but the EditBox wasnot well positioned as expected. I just converted this portion that is working in vb6 to vsb.net 2005. While typing i wouldnt see the text box, but once the fg gotfocused, the content displays on teh grid
t.aransiola
|
|
|
|
|
aransiola wrote: There is AXMSFlexgrid in .net 2005 that works like vb6.0 flexgrid
That's becuase it IS the VB6 FlexGrid. The "Ax" prefix give away the fact that it's an ActiveX control wrapped by a .NET interop class.
If all you're doing is putting up textboxs so you can edit fields, you don't need the FlexGrid. You just need to use the DataGridView instead and the default textbox columns, among others, are supplied automatically.
|
|
|
|
|
hi
You are right. We can use the datagridview control. But it is not working exactly as mshflxgrd works in vb 6.0.
I tried to use Datagridview
The main problem i faced is that I am not able to position the focus to the cell (that is to set other cell as the current cell when the data entry of one cell is completed and enter key is pressed) which i wanted at run time.
If you can help out this issue then hopefully we can use datagridview instaed of mshflxgrd.
If fact i am also in the process of converting my vb 6.0 application to vb.net
I am now stuck up with this issue. If you can help it out my time could be saved
thanks in advance.
|
|
|
|