borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (Excel Toolbar..!)Next Topic (Making Crystal gather data from an RDO Resultset?) New Topic New Poll Post Reply
AndreaVB Forum : Reporting tools : how to manage a report from 2 textbox
Poster Message
practrainee
Level: Sage

Registered: 26-01-2005
Posts: 68

icon how to manage a report from 2 textbox

i've done this coding

Private Sub Command12_Click()
DataEnvironment2.Command1_Grouping Text1, Text2
DataReport1.Show
End Sub

at datareport1;
there are 2 parameters, Text1 and Text2 for this query

SELECT BSC_ADMIN.* FROM BSC_ADMIN WHERE BSC_MONTH=? AND BSC_YEAR=?

the error is "Report Section Do not match data source"
data source has been set to dataenvironment2 and the datamember=command1_grouping coz i'm using grouping at this report..
someone please help me..tq

23-02-2005 at 10:17 AM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
practrainee
Level: Sage

Registered: 26-01-2005
Posts: 68
icon Re: how to manage a report from 2 textbox

its ok nobody wan to help me..however i got de solution last night..heheh

other problem juz to group by category all details according to the month and year above..maybe its somethin related with child command..

i've try with add all the field except month n year (coz its in command1_grouping)and GROUP BY CATEGORY

SELECT P,O,I GROUP BY CATEGORY

but still no output in the report..it juz display month n year label..not even the passing parameter

24-02-2005 at 07:29 AM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
Goran
Level: Moderator

Registered: 16-05-2002
Posts: 1681
icon Re: how to manage a report from 2 textbox

It is not the issue here that nobody wants to help, it is just thay probably most of us dpnt use data report, but more proffesonal 3d party objects, like crystal reports, for instance..

____________________________
If you find the answer helpful, please mark this topic as solved.

24-02-2005 at 11:10 AM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : Reporting tools : how to manage a report from 2 textbox
Previous Topic (Excel Toolbar..!)Next Topic (Making Crystal gather data from an RDO Resultset?) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder