sql and crystal report problem

[tonioJ]

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...

 

[kenhamady]

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

http://www.kenhamady.com/

tek@kenhamady.com

 

[tonioJ]

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.

tonioJ

 

[WELLDUH]

tonio , do you compile and distribute
your report if so you might try thread 149-90259

 

[kenhamady]

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

http://www.kenhamady.com/

tek@kenhamady.com

 

[tonioJ]

hello ken,
thank you again for the reply. yes, it does ask for the user name and password.....

hello wellduh..
thanks for the reply.. i'll check out your suggestion...

 

[kenhamady]

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

http://www.kenhamady.com/

tek@kenhamady.com

 

[anna1974]

Hi

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

 

[tonioJ]

hello anna1974,

have you tried verifying the database???

if the key field that you have used for linking one table to another has been changed, you have to re-link the tables.

 

[anna1974]

Hi TonioJ

thanks for your reply.

My crystal report displays values from just one single table. It works fine now.

But the guys are soon going to change the table name and add one more field to the table. Rest of the table fields are going remain as such.

As the table name is going to change, i have to relink the database to my report. right?

When i do this "set database location". the format on the crystal report completely collapses.

IS there a way i can retain the design format of my report and still attach it to the new table.

 

[kenhamady]

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

http://www.kenhamady.com/

tek@kenhamady.com

 

[Sot]

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" }

Kumar

 

[kenhamady]

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

http://www.kenhamady.com/

tek@kenhamady.com