Search results for query: *

Hello I would like to hide columns in cross-tab. I used suppress with formula but it leaves empty columns. The current cross tab is like this 07/01/2020 07/02/20 07/03/20 07/04/20 07/05/20 Total Site 1 1 1...

Hello, I have requirement to construct where clause based on parameters that was passed. If any parameter is null then do not include it in where clause if it is not null then include it in where clause. For example The Stored Procedure takes 4 input parameters ClientId ClientLName...

Hello I have below data records and would like only to show the max date row records ID SvcDate SvcName Provider ClientId 1 10/01/2015 TESTING ABC 123 2 11/20/2015 CBC XYS 123 3 12/1/2015 CHEM 7 ABC...

I am trying to understand what does it mean when we say else true? because if it evaluates to True what would crystal replace with if it is joining other statements with true? in below case if the first part evaluates to True then it is combined with and with date range criteria. i would like...

If i put the first part in the formula then what would the formula evaluate if {?Status} does not have value? (if hasvalue({?Status}) then if {?Status} = 'ALL' then true else {Command.Status}={?Status} else true) I am tryi

Will do @Skip Regards

Hello, If you are adding OR and removing IF then how does it work, because then we are saying use ALL or what ever the value the user selected for status. What i am looking for is when user selected ALL or null then status should not be part of the criteria. ({?Status}='ALL' or...

Hello, I have below data and i would like to count the data by category and if client has more category then he needs to be counted only in one category according to the order clientid category id catg date 123 low 1/1/2015 123 mid 3/1/2015 777 mid...

Hello, I have below record selection criteria If {?Status}='ALL' Then True Else {Command.Status}={?Status} and {Command.DateService}>={?StartDate} and {Command.DateService}<={?EndDate} My goal is when user selects ALL or do not select any value for Status parameter i do not want to include it...

Hello, I would like to know how i can write a formula that will return True or False if the string has number or numbers in it. For example StringVar temp:="ABC 12"; Stringvar temp1:="ABC"; I would like to check temp for number and it should return true and temp1 should return false...

Hello I have a group on table pimary key but i want to reverse the order of records for example Table 1 RowId Name Dob SSN 1 Test,Name 5/1/14 123232555 2 Test,Name2 7/1/14 231224444 3 Test,Name3 9/1/14 100000000...

Hello I have below table data SvcId SvcName ClId CntType 1 test1 100 1 2 test2 100 2 3 test3 100 3 4 test4 100 2 5 test2 101 1 6 test3 102 2 7 test4 102 3 8...

Hello I have a text field with Can Grow option checked and for long text it divides the text to show on next line. For example This is my test str ing to fix I would like to have the result like below This is my test String to fix Instead of dividing the word into two parts, wrap at the...

Hello, I have a table like below that stores information for each provider for each of contract by category by month. Amt allocated is set for each category when contract is setup, the users enter how much they spended each month. Now i wanted to know the over all spended amount for each...

If i add Sum as summaries i am getting the sum for all months for allowed amount. The allowed amount is set once at the begining or updated but we need to get Max of Allowed amount and sum it across the contracts if i add crosstab, i will have categories as rows and allowed amt and expended amt...

can you elaborate more subreport option that yyou suggested. If i have the subreport then what should main report will have? in Subreport do i include sum for amounts? little more specific would help. Regards

Hello, I have a table like below that stores information for each provider for each of contract by category by month. Amt allocated is set for each category when contract is setup, the users enter how much they spended each month. Now i wanted to know the over all spended amount for each...

I have posted this in Crystal Reports. Thanks

Hello, I have a scenario, where client can have more than one Race like below ClientId Client Name Client Datebirth Client Race 100 John, Smith 01/01/1980 White 100 John, Smith 01/01/1980 AmericanIndian 101 John, Dose 03/01/1977 Black 102 Doe, John 01/23/1983 Asian 102 Doe, John 01/23/1983...

Hello, I have a scenario, where client can have more than one Race like below ClientId Client Name Client Datebirth Client Race 100 John, Smith 01/01/1980 White 100 John, Smith 01/01/1980 AmericanIndian 101 John, Dose 03/01/1977...