Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pndMaster
  • Content: Threads
  • Order by date
  1. pndMaster

    Hide column in Cross tab - CR2013

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

    Dynamic SQL - Where clause help

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

    CR XI - Selection formula to Limit to Max Date Records

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

    Crystal XI - Calculating count once per category

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

    Crystal XI - Record Selection Formula - Not include fields

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

    Pattern Match for any number in string - CR XI

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

    CR XI - Showing records in reverse order

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

    CR XI - Help with Running Total

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

    CR XI - Text Wrap to last space without dividing the word

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

    CRXI - Sum of Max not able to implement

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

    CR XI - Creating Sum by categories

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

    CR2008 - Count and Show once in group

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

    CR2008 - Count Once for Multiple values

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

Part and Inventory Search

Back
Top