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 Mike Lewis 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: *

  1. lavadan

    Export to excel with drop down data

    I have to export crystal reports to excel format. One column should have drop down capability when exported to excel. For ex: Column A has options class A, Class b and class C. But that column should have the drop down capability. Is this possible in crystal reports or any other workarounds?
  2. lavadan

    CSV file escape phone number format

    I have a CSV file converted from excel. The phone numbers in the csv file looks like 8887964532. But when I import the data into sql using import wizard, the phone number is converted to +18887964532. +1 is added infront of all Phone numbers. Is there a way to escape this?
  3. lavadan

    SQL Maintenance Job Schedule

    I have a sql maintenance job that takes back up, delete old back ups...etc. It is scheduled to run everyday. Is there a way to change the schedule to not run on 15th of every month? I dont want to create multiple schedules. Any other way?
  4. lavadan

    Maximum of each column value

    This does and work and throws an error. I am using sql 2016. I wrote a script using cursor but it takes a long time since i have close to 3000 tables. Any other way to determine this?
  5. lavadan

    current max value of all int columns

    How to find the current maximum value of columns with int datatype in a database
  6. lavadan

    Maximum of each column value

    I have a small database with 10-12 tables. How can I find maximum value for each column for all tables via a query?
  7. lavadan

    Record added for the first time

    I have a table of the below format: ID ChildCode ParentCode Action ActionDate 1 1 1 Added 8/9/16 14:01 1 2 1 Added 8/9/16 14:01 1 1 1 Removed 2/27/17 9:21 1 1 1 Added 2/15/19 10:27 1 3 2 Added...
  8. lavadan

    Slashes in a string

    I have a string that can have N number of /. How can I find how many slashes my string has? Apple/Banana/Peach -2 slashes Cow/Milk - 1 slash abc/xyz/per/wsl/pol -4 slashes How can find the # of slashes?
  9. lavadan

    format address field

    I have a address field that is all caps. How do I make the address just first letter caps, or have N, W, S,E caps, or have Ln, Dr, Ct Rd (Anything that is ln ,dr, ct, rd should be Ln, Dr, Ct, Rd) so if my address's are 123 abc ln the formatted address should be 123 Abc Ln 456 w pseo dr...
  10. lavadan

    Rows into dynamic columns

    I have a table with name and Amount Name Amount rita 100.00 rick 100.00 sam 150.00 harry 200.00 heather 290.00 James 200.00 I was wondering if I can do a dynamic pivot on Amount Column so that my result will be 100 150 200 290 Rita Sam Harry Heather Ram James
  11. lavadan

    Device Independent Bitmap OLE Object

    I have some crystal reports(crystal reports 2008)and they all have OLE Object. All I know is that they are Device Independent Bitmap picture. How would I find more info about this OLE Object like Is it a static or Dynamic OLE Object If it is dynamic, then where can I get the link to the OLE...
  12. lavadan

    Null Parameters or table with no data

    I have a table StateCounty with State and County. The table can also be empty. I want to use the values from these tables as parameter to get data from zip table like select * from tblzip where tblZip.State in (select distinct State from StateCounty) and tblZip.County in (select distinct...
  13. lavadan

    Issue with setting and resetting a variable

    But I have not declared it as Global variable/shared/local. What is the default variable type if I did not declare?
  14. lavadan

    Issue with setting and resetting a variable

    I have the below report structure Report Header- Variable set to 0 Page Header- Section supressed if variable is 1(which means suppress on last page suppression formula is WhilePrintingRecords; numberVar variable1; if variable1=0 then...
  15. lavadan

    Convert unique row to columns

    How would I modify the query to get the childrens name in seperate column I have a SQL table Parent ID Children 1 Smith 1 Jenny 1 Ryan 2 Joe I want the result to be. Only top 2 children will be shown. If a parent id has 10 children, then I want only the top 2 in...
  16. lavadan

    Convert unique row to columns

    I have a SQL table Parent ID Children 1 Smith 1 Jenny 1 Ryan 2 Joe 2 Jane I want the result to be ParentID Children 1 Smith, Jenny, Ryan 2 Joe, Jane How can achieve this result?
  17. lavadan

    Find more than 1 alphanumeric chars in a string

    I have an employee name table Surname GivenName ABC x.yz ABc x.y.z ABC X.*YZ A*.BC xyz The query needs to get me the surname and givenname which have more than 1 non alphanumeric characters together(one after the other). In this case the output will be abc x.*yz a*.BC xyz How would I find...
  18. lavadan

    Export Crystal Reports formula values only

    Hi, I have a question on crystal reports formula. I have a report which uses some tables from sql server 2008. I get the table values in the report and have created number of formulas in crystal side to the get desired results. Is it possible to export only the formula values to some other...
  19. lavadan

    Average results in Crystal Bar Charts

    Please help me with Crystal Charts for the following scenario:I have list of how much people earn and how much they spend for entertainment. Name Monthly Salary Entertainment Expense A 3000 300 B 5000 400 C 1500...
  20. lavadan

    Distinct Data

    The CustomerID is the PK has many unique ContactID. Your soultion worked. Thanks.

Part and Inventory Search

Back
Top