Visual Basic

Error on summary feild in crystal report

27-Oct-07 5:08

Convert Currency to Words (Indian Format) in Crystal Reports[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

yogesh_kumar_agarwal27-Oct-07 2:12

27-Oct-07 2:12

 <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

AliAmjad27-Oct-07 2:45

27-Oct-07 2:45

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)

yogesh_kumar_agarwal27-Oct-07 2:49

27-Oct-07 2:49

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

AliAmjad27-Oct-07 2:55

27-Oct-07 2:55

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)

yogesh_kumar_agarwal27-Oct-07 3:02

27-Oct-07 3:02

<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

AliAmjad27-Oct-07 3:13

How to close a form when move one to another form

27-Oct-07 3:13

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)

samarjeet sing27-Oct-07 2:10

samarjeet sing

27-Oct-07 2:10

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)

Re: How to close a form when move one to another form

yogesh_kumar_agarwal27-Oct-07 2:15

Re: How to close a form when move one to another form

27-Oct-07 2:15

if you use VB then use unload function

manni_n27-Oct-07 3:42

manni_n

27-Oct-07 3:42

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()

Re: How to close a form when move one to another form

Dave Kreskowiak27-Oct-07 3:51

Re: How to close a form when move one to another form

27-Oct-07 3:51

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

The ANZAC27-Oct-07 13:38

The ANZAC

27-Oct-07 13:38

But you can set it as the startup form and just tell it to hide (vs2005) without problems.

Please check out my articles:
The ANZAC's articles

Re: How to close a form when move one to another form

Dave Kreskowiak28-Oct-07 3:49

28-Oct-07 3:49

Not a good desgin, but it works.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Timer Control Help

SilentCodingOne27-Oct-07 1:53

SilentCodingOne

27-Oct-07 1:53

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

Re: Timer Control Help

AliAmjad27-Oct-07 2:12

positioning a textbox in the AXMSFlexgrid cell

27-Oct-07 2:12

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)

Re: Timer Control Help

SilentCodingOne27-Oct-07 10:47

SilentCodingOne

27-Oct-07 10:47

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

aransiola27-Oct-07 0:47

aransiola

27-Oct-07 0:47

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

Dave Kreskowiak27-Oct-07 3:48

27-Oct-07 3:48

Why are you using the old FlexGrid?? What are you doing that will not let you use .NET 2.0's DataGridView??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

aransiola27-Oct-07 9:28

aransiola

27-Oct-07 9:28

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

Dave Kreskowiak28-Oct-07 3:47

28-Oct-07 3:47

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007