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?
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?
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.