Vartana
asked on
VB.NET Crystal Reports Login/Username on Dataset
I made a crystal report using datasets and when i run it it asks for a user name and password with server and database ?????
Im using a dataset what username, password ??
Im using a dataset what username, password ??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The CR gets the values from 2 datasets and 3 tables
DataSet1
------------
---MyTable
------ID
------Name
Dataset2
-------------
---MyTable
------Description
------ID
no in CR i linked the ID of dataset2 mytable to the dataset 1 mytable .
DataSet1
------------
---MyTable
------ID
------Name
Dataset2
-------------
---MyTable
------Description
------ID
no in CR i linked the ID of dataset2 mytable to the dataset 1 mytable .
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so any ideas guy ?
as i said make sure your tables have the same names .. that is the major cause I get here using push model ...
DataAdapter.Fill(ds, "CorrectTableName");
DataAdapter.Fill(ds, "CorrectTableName");
also how are you pushing in 2 datasets ?
better question why are you pushing in 2 datasets you can put the table from dataset2 in dataset1 for crystal and avoid this.
ASKER
well because i save all of the contents of the dataset2 to xml and i dont need the data in dataset1
ASKER
i used the wizard and it let me link tables
what is your datasource setting code ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
in this case the first one brings up a good point but off ... you need to set the datasource for your subreports (not the login)
ASKER
yeah none of this is clear to me yet. Can someone clarify this for me ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER