data report!

[rothj0hn]

is this possible in data report...

-----layout 1

Female student...
[display list of all females]

Male Student
[display list of all males]

----layout 2

Female Students: Male Students:
[list of females] [list of males]
________
Star Craft Replays (http://screplays.com/)

[MartinLiss]

Moved.

[dee-u]

I believe that is possible, the DataReport has groupings that you could try using.

[rothj0hn]

is there any toturial on how to use this?
________
Roasting Food (http://www.cooking-chef.com/roasting/)

[dee-u]

None that I am aware of. You could try searching here, perhaps there has been discussions on it.

[rothj0hn]

hmm... how does this grouping works? will it handle to different queries?
such as select studentname from student where gender = 'Female' for one group then select studentname from student where gender = 'Male' for the other one? this is my idea on how to generate that report. please corrent me if im wrong.. @dee-u are u a filipino?

[dee-u]

I believe you have to use the GROUP BY clause. Yes, I am a countrymate of Pacquiao. =)

[rothj0hn]

just using the group by clause? ok ill try it and post the result.. thanks for the help.. kababayan! ^^
________
Second-Generation Camaro (http://www.chevy-wiki.com/wiki/Second-generation_Chevrolet_Camaro)

[wes4dbt]

How are you setting the report datasource? If your using a DataEnvironment then there is a grouping tab in the command properties window. If your creating an ADO recordset then you have to use a DataShape.

[rothj0hn]

whew! its quite complicated than i thought.. do u have some examples? using dataenvironment and ado.. ive used this two but in simple reporting and querying only..
________
Bmw V (http://www.bmw-tech.org/wiki/BMW_V)

[wes4dbt]

If your using a Dataenvironment then use the properties to set your grouping.

This is a DataShape example

Dim rsData As New ADODB.Recordset, cFinalCond$
Dim conReport As New ADODB.Connection

cFinalCond = "SHAPE {SELECT tags.*,us.*,iif(trim(tags.status)='I','Invoiced','Not Invoiced') as invstatus from tags inner join users us on us.userid=tags.userid" } AS Tag " & _
"APPEND ((SHAPE {SELECT * From tagsdetail order by line} As Command1) " & _
"RELATE tagnumber To tagnumber)"

'Open a DATA Shape Connection For Reports
With conReport
.Mode = adModeShareDenyNone
.Provider = "MSDataShape" 'Microsoft Provider for Data Shaping
.ConnectionString = "Data Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = c:\somefolder\yourdatabase"
.Open
End With

If (conReport.State And adStateOpen) > 0 Then
With rsData
.ActiveConnection = conReport
.LockType = adLockReadOnly
.CursorType = adOpenStatic
.Open cFinalCond
End With
End If
'Set the new Data source of Report
Set rptDataReport.DataSource = rsData

[rothj0hn]

im not familliar with the shape in sql.. how to create a query using shape that will group female and male?

Report Sample
Female: Male:
Female1 Male1
Female2 Male2
Female3 Male3
Femalen Malen
________
Alaska Medical Marijuana Dispensary (http://alaska.dispensaries.org/)

[dee-u]

Here's a quick and (very) dirty sample. Hope this could serve as a guide. Just put the database in your c:\ drive.

[rothj0hn]

thanks
________
Pc800 (http://www.cyclechaos.com/wiki/Honda_PC800)

[dee-u]

Have you got it?

[rothj0hn]

yup... i have another question bout it.. how i can put label.. such as list of female student..
________
Buy Vapor Genie (http://vaporizers.net/vapor-genie)

[dee-u]

You could just try experimenting with it.

[rothj0hn]

ok thanks
________
MFLB (http://www.vaporshop.com/mflb-vaporizer.html)

[Encoder]

Yun...it's good to know that I'll be asking this to a kababayan. Is it possible that I can create a transaction receipt just by using data report? From the example that I've seen it seems that the report displays a list. I just need one row from the database (I'm using MS Access and SQL) containing the Payment No, Payment and payment type to create the receipt. Is it also possible that one report can use two different sets of table.

[dee-u]

Hey Encoder, it would be better if you start another thread for your concern so they are not mixed in this thread. Maligayang pasko!

[dee-u]

Just want to share this (http://msdn.microsoft.com/en-us/library/aa733655.aspx) MSDN Article on DataReport.