Search results for query: *

Hi, is there way to supress column in Crosstab? Thanks ________________________________________ I am using Windows XP, Crystal Reports 9.0 with SQL Server

Another SUB or Group question. ID Code Prod 111 1001 AAA 111 1002 AAA 222 2002 BBB 333 3001 CCC 333 3002 CCC 333 3003 CCC At the end I need Count of Codes Total Prod for 111 -...

I have heard some stand up talking about how minorities changing the way they wanted to be named and he went onto homeless and said if we have to start calling them 'hygiene impaired squeegee technician' but if it is too much we can offer to shorten it to 'outdorsemen'... I know it is wrong but...

I think SUB Report but then I thought maybe I shouldn't have. You please, tell me. PUB QTY FuturePlan AA_1 12 100 AA_2 1 100 BB_1 0 10 BB_2 5 10 So on my Report I trim PUB to a 2 first letters and...

I have data that looks like this QTY AMOUNT AVERAGE 1.00 $2995 $2995 .025 $0 $0 1.25 $2995 $2995 Totaling fields at RFooter are SUM of Totaling fields at Groop Footer. Like TotalQTY and SUM TotalQTY. How do I make formula to never mind RFooter (it'll...

Just heard on a radio... Question: 'Doing THIS can cut your chances of getting sick by 25%. What is it?' In 2 days this question was answered and the answer was 'Having a night out...' Here I am trying to 'get it'...what is the 'night out?' and what kind of night out can help us to be...

I just read about a beach that is fabulous getaway for gay and gay-friendly people. I am still laughing trying to figure out if it is what? New category? Gay-friendly people. How many chances we will soon check Gay-friendly or Gay-unfriendly on applications? Is this funny or scary or stupid...

Both of my fields are Number datatype. Formula is If({field1})=0 then {field2} else "" I want to see blank if else but formula asks for Number in place of "". How do I display blank if else? Thanks ________________________________________ I am using Windows XP, Crystal Reports 9.0 with SQL Server

I have names like A_1_WE_SILV Q_2_UU and I need to trim to before second underbar like A_1 How do I do that? ________________________________________ I am using Windows XP, Crystal Reports 9.0 with SQL Server

I ran into this. My data in SQL Server Prod EQ TotEQ Amount ABC 1.000 3 $100 ABC .060 1 $10 ABC .250 1 $1 To pull EQ field I was suppose to multiply EQ*10. Now in Crystal when I am pulling this field it brings only those 1.000...

Hi, I am having a problem creating a view from someone elses script Select A_S_P * 10 as [RT QTY] * * * Group By A_S_P * 10 It gives me Incorrect syntax near 10 Anything you can see right away that I am missing? ________________________________________ I am using Windows XP, Crystal...

Hi, I am having a problem creating a view from someone elses script Select A_S_P * 10 as [RT QTY] * * * Group By A_S_P * 10 It gives me Incorrect syntax near 10 Anything you can see right away that I am missing? ________________________________________ I am using Windows XP, Crystal...

Name Status1 Status2 Amount ABC Cancelled NoInv $400 SCD Suspended Inv $300 VSD Active Cash $400 I need to show on Report following: Amount where Status1 = 'Cancelled' asnd Status2 = 'NoInv' Amount where Status1 = 'Suspended' asnd Status2 =...

Do not have time to research but if anyone heard about New York Sneak Thief, which adds syllables after consonants. ________________________________________ I am using Windows XP, Crystal Reports 9.0 with SQL Server

I ran into problem. I have records that are : CusID LName CoNAme 001 Fran Doob 002 Cole Sop Integra 003 Tom Frok Tom Frok If CoName is empty I need to display LName, if CoName and if Lname is the same I need to display CoName Output is : CusId (always) CoName...

Data CO_NAme Status BillAmount AAAA AC 100 BBB CN 2000 CCC NA 35 So I need to display as : CO_Name AC CN+NA Total I am planning to create SUB_Report with Status='AC' and Main Report will have Status<>'AC' What...

I need formula so if Balance (Currency) is 0 then display 'ALL'. I wrote formula IIF({?Balance}<>0,{?Balance},"'ALL'") wich tells me that ALL should be currency. How can I change it so ALL is excepted? Thanks ________________________________________ I am using Windows XP, Crystal Reports 9.0...

Hi, I have few email accounts with Main account all built on. So one of my emails gives me blank page and it's setting the same as others, it use to be fine. I am allowed Main + 5 and I have only Main + 3. My provider is ATT. Anyone? Thanks ________________________________________ I am using...

My SubReport is in Report Footer b. I have Page Header c that gets displayed on every page. But I need it not to be displayed when Sub Report is displayed. Thanks ________________________________________ I am using Windows XP, Crystal Reports 9.0 with SQL Server

My Subreport is the Summary of the Main Report. Main Report has anly DateFrom and DateTO parameters that used as a formula set to True. @DateRange {ASI_RECEIPT_JOURNAL_VW.TRANS DATE} >= {?StartDate} and {ASI_RECEIPT_JOURNAL_VW.TRANS DATE} <= {?EndDate} In Select Expert Formula @DateRange is...