Search results for query: *

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?

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?

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?

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

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

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

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?

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

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

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

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

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

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?

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

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

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

I am new bie to sql. Can anyone help me with the following question. I have the following customer table with CustomerID as pk. Each CustomerID can have many ContactID’s . Atleast one ContactID for each customer should be billing contact. I have to find the CustomerID’s for which none of the...

Hi All, I have a question on how to solve this in crystal XI: I have a field from a table which looks like- Sammy, Green, Public, Beach I want to display it in crystal reports as Sammy(Green, Public, Beach) - i.e. after the first & last commas , there should be brackets Does anybody have...

Dear Forum members, I am an excel rookie. I have customer names on the first column and customer IDs on the second culumn. I am trying to insert my second column data into my first columns alternate rows. Current data: Column 1 Column 2 Row 1 Joe...

Hello All, Please help me with the SQL Query. The table structure is: EffectiveDate Amount 08/31/2008 400 09/30/2008 350 10/31/2008 200 11/30/2008 500 12/31/2008 100 I want to find the difference between any two...