hello people out there! can anyone help me with this problem? why is it that everytime i open or refresh my report, it always ask me for a user name and password? please help...
Does the database have a password?
Does it ask you immediately when you open the report, or just when you try to run it? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
hello ken,
thank you very much for the reply. it ask me for the password after I open and refresh the report with crystal report. I am using ms sql server 7. The database has a no password and i am using "sa" as the username in sql and I didn't change the default blank password. When I created the report and i still use "sa" as my user name to add a database in my report. By the way, I am using crystal report 8 prof. edition.
If you create a new report does it ask for a user name and password before you can get to the data? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
Either there is security on the database, or Crystal is having a problem connecting - maybe a permissions problem. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
I developed a complex crytal report accessing data from just one table.
Now the table defintion and also the name of the table has changed ( database adminitrators work i dont have control over it)
WHen i go to RELINK the database tables to the crystal report that i already developed...the whole format is messed up. It will atleast 3 days to get that report look fixed.
Is this the problem with crystal reports !!! is it a problme to even just add an extra field to the table and get in the crystal report !!!!???
your help us greatly appreciated !! and save me a lot of hardship !! thanks in advance
Set location should not cause the report to fail. That is how you change the table without losing the format. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
Any one help ...
If i run the following query in sqlserver query analyser i am getting output....But if i paste the same query in Crystal Reports -Show query option and save the report and run the report it si not giving proper output...I meam
first two fields is not there?(patient_age_vw."age_group",patient_age_vw."patients" )
here first query is
SELECT
patient_age_vw."age_group",patient_age_vw."patients" ,patient_age_vw_male."count",patient_age_vw_female."count",patient_age_vw_other."count"
FROM
{ oj "patient_age_vw" patient_age_vw right OUTER JOIN "patient_age_vw_male" patient_age_vw_male ON patient_age_vw."sequence" = patient_age_vw_male."GROUP"
right OUTER JOIN "patient_age_vw_female" patient_age_vw_female ON patient_age_vw."sequence" = patient_age_vw_female."GROUP"
right OUTER JOIN "patient_age_vw_other" patient_age_vw_other ON patient_age_vw."sequence" = patient_age_vw_other."GROUP"
}
the second query which i am seeing in show query option...If i paste the above query and save then it is show following...
SELECT
patient_age_vw_female."Count",
patient_age_vw_male."Count",
patient_age_vw_other."Count"
FROM
{ oj "patient_age_vw" patient_age_vw right OUTER JOIN "patient_age_vw_male" patient_age_vw_male
ON patient_age_vw."sequence" = patient_age_vw_male."GROUP" right OUTER JOIN "patient_age_vw_female" patient_age_vw_female
ON patient_age_vw."sequence" = patient_age_vw_female."GROUP" right OUTER JOIN "patient_age_vw_other" patient_age_vw_other
ON patient_age_vw."sequence" = patient_age_vw_other."GROUP" }
Please start a new thread for this question. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.