Link to home
Start Free TrialLog in
Avatar of Vartana
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 ??
ASKER CERTIFIED SOLUTION
Avatar of gregoryyoung
gregoryyoung
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vartana
Vartana

ASKER

gregasm  no i dont think i have versions of them ?
Avatar of Vartana

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 .  
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Howard Cantrell
Howard Cantrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vartana

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");
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.
Avatar of Vartana

ASKER

well because i save all of the contents of the dataset2 to xml and i dont need the data in dataset1


Avatar of Vartana

ASKER

i used the wizard and it let me link tables
what is your datasource setting code ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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)
Avatar of Vartana

ASKER

yeah none of this is clear to me yet. Can someone clarify this for me ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial