Crystal Reports - Replacing blank strings

Hi
Part of my report displays an Assignee's name, however if a job as been assigned to a team but not yet assigned to a team member, it displays nothing.
Any suggestions where/how to write a formula that replaces blanks with a custom string such as "Not yet assigned" ?

Much appreciated
ThanksHi
Part of my report displays an Assignee's name, however if a job as been assigned to a team but not yet assigned to a team member, it displays nothing.
Any suggestions where/how to write a formula that replaces blanks with a custom string such as "Not yet assigned" ?

Much appreciated
Thanks

I've done this a couple ways.

Method 1: insert the text object "Not yet assigned" in the same place as the Assignee's name. Format the Assignee field with a white background.

Method 2: prepare a formula @.assignee. if isnull({assigneefield}) then "Not assigned yet" else {assigneefield}

crystal report -sorting issue

I am new to crystal reporting
Ii have an existing report with Job Numbers, Job Description and Total fields, The report works fine with the right sorting and groping in the Crystal report viewer.
But once loaded in the ASP page it stops sorting and grouping in the asp page - companys brower page.
Any suggestions on what must have gone wrong.
Thanks in advance

SandyTry checking in the
Menu File / Options / Database tab / Perrform Grouping On Server|||Hi Sandy, saw a very similar post somewhere else, this sounds odd, if it sorts correctly in CR, it should sort in ASP the same, you may want to have a web person check to make sure something is not sorting your report once it gets to the page. Sorry I am not much help...|||Try checking in the
Menu File / Options / Database tab / Perrform Grouping On Server

hi

done the changes-- but how would it reflect in my asp page

thanks

sandy|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.

what amount sub reports there're in your main report?
what amount records show your report?|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.

what amount sub reports there're in your main report?
what amount records show your report?

NO there is no subreports in my report - its a simple report - with fields like job, description and amount. - with a total and a grand total in the end. the report is coming to from the viewer though an asp page. Its sorted in the
report but when it has sort in the asp page ... it refuses to do the same. but when i click on the job field it sorts by descending and with one more click to goes to ascending. Now i want a default ascending as in the report.
I am a newbie in asp..
If you can please help

sandy

Crosstab Report

I am creating report with total costs by job, it repeats "column totals"
two times, and at the end column "grand total". "grand total" column is okay.
Is there any way I can drop/disable repeating "column totals". See example below, help me to drop repeating column.

Thanks

Job 1 Job 2 GrandTotal
Total Total

Cost 1 177,855 177,855 162,755 162,755 340,610
Cost 2 169,847 169,847 161,063 161,063 330,910
Cost 3 37,404 37,404 102,416 102,416 139,820In CR,right click on the cross tabl. Choose format Cross tabl. U ve a tab like "Customize Style". Choose each and every row in Rows List and below that u ve Grouping Option. Suppres that grouping option. I think this may be a soln. Try it out.

cronjob on ms sqlserver

I want to take a daily backup for my ms sql database. But not sure how to do it ? I think i can use something like cron job which will automatically take the backup of my complete database.

Please help me as i am new to this ms sql.

Thank you in advance.Here is everything you need to know:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Good Luck.