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

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

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

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