VB Crystal Report, Datasets and Crystal Reports

1. uniqueidentifier in Datasets for crystal reports

Hi,

i have a databasesystem where all tables have a uniqueidentifier as
keyfield. i created a dataset in .net, based on one of those tables. when i
use the dataset to fill a grid, everything works fine.
but when i use this dataset in crystal report, the uniqueidentifier-field is
not printed. i can't create a group-report with different tables, connected
over a uniqueidentifier, because cr doesn't work with it.

in the dataset, the uniqueidentifier-field is defines as key-field , element
(E) and the type is string.

when i create a report, based on the table itself, everything works well.

can anyone help me please?

Bernd

2. Multiple Datasets in Crystal Report - VB Crystal Report

3. Reporting with Datasets, Crystal Reports in VB.net 2003

Hi,

I am trying reporting off in VB.net using Datasets (from code view),
Crystal Report 10 using ADO.net (OLE DB).

Reports are designed in CR 10 using Design Time features like
connection to database and fetching of data etc.

Now I am trying to pass dataset to this report using SetDataSource()
method of ReportDocument. Some code example is...

'############################

        Dim ds As New DataSet
        Dim cReport As New ReportDocument
        Dim crtableLogoninfos As New TableLogOnInfos
        Dim crtableLogoninfo As New TableLogOnInfo
        Dim crConnectionInfo As New ConnectionInfo
        Dim CrTables As Tables
        Dim CrTable As Table
        Dim TableCounter

        query = "SELECT * FROM Addresses where companyid=3"

  '# Code for connecting to DB using OLEDB, and Filling DS here #'


        ' Loading Crystal Report
        cReport.Load(rptpath)

        With crConnectionInfo
            .ServerName = strDbpath
            '.DatabaseName = strDbpath
            .UserID = "admin"
            .Password = ""
        End With

        CrTables = cReport.Database.Tables

        For Each CrTable In CrTables
            crtableLogoninfo = CrTable.LogOnInfo
            crtableLogoninfo.ConnectionInfo = crConnectionInfo
            CrTable.ApplyLogOnInfo(crtableLogoninfo)
        Next

        cReport.Database.Tables(0).SetDataSource(ds)

        ' crv1 is Viewer dropped on Design Time
        crv1.ReportSource = cReport

'############################

Now the problem is, when i run the code, it shows me all records of
that table rather than showing me just 1.

I tried all possible ways to overcome this problem, but all seems not
working for me. Any suggestions, thoughts? should I use parameters?
formula fields? anything else?

Any help will be appreciated.

Regards,

Fahad

4. Crystal Reports and Large Datasets - VB.Net

5. howto two datasets for a report documnet(crystal)

hello all,
i m using vb.net.i want to make a crytal report which contains a subreport
in the header .the subreport in the header will display class info like
class  ,class teacher,class monitor and school name.
the main report will display the list of students in that studying in that
class.list contains info like student name,age and sex.
i am using dataset for the data source of report.
i can bind only one dataset at a time to the report document..how can i
dislay both the datasets(for the subreport and main report) .
regards
khalsa

6. Crystal Reports - Database Login dialog when using datasets - VB Crystal Report

7. How to Usu DataSets under a NameSpace as a Crystal Reports Data Source

Hello people


I'm trying to create a new DataReport taking as data source a "DataSet" 
that is located into a "NameSapce" on my proyect ( Visual Studio 2002 ), the 
question is: Hoy to tell Crystal reports "The DataSet 'DS_MyQuerys" is under 
the nameSpace 'Acounts' ???

This where the table is:    Accounts.DS_MyQuerys.Table1
I wanna take Table1 and put it into a report

Thanks for your help
Sergio 

8. Crystal Reports - Setting up a one-to-many relationship in a crystal report - VB.Net