Search results for query: *

Hi members, i want to display & in string in oracle. right now when i am running my script it is asking me to enter variable value and in the out put string it does not display & .. so how can i display & in string in oracle ? Thanks. any help is greatly appreciated.

Hi everybody, i want to sum up all column vlaues at last - bottom of column and su up of one tuple - raws values in last column. i want to handle this in my query and function not at crystal side. below is my sample output : column 1 column 2 column 3 sum raw 1 10 15...

hi members, i know the concepts and definition of veiws but i do not understand why peoples used views in crystal report ? because query defined under view , that we can also write in command of CR. so what is the advantage of using views in CR and why peoples used in that ? thanks.

Hi Group Members, below is my problem. need output like : Accessory Research_amt Plant_amt health_amt total_amt Staff 10 20 15 45 so i need summation of all tuple raw amount in last column raw - same tuple. Research_amt , Plant_amt , Health_amt each...

Hi members, hoep everyone doing excellant. i am fascing problem in order of sql query data. suppose my query data of one column is 1 2 3. using order by ascending or descending clause i can get results of order...

Hi group members, i am trying to create materialized view using toad oracle. under materialized view tab - i follow create materialized view option. inside that i define name of materialized view and desing select query. eve though, it give me 000938 error code - missing select statement...

HI group members, How can u use dynamic parameter in page header and page footer? thanks.

Hi, i am very new in reporting world. can anybody explain or povide me nice url for how to integrate crystal report with c sharp fornt end application ? thanks in advance

Hi, i developed crystal report now i want to integrate that crystal report with c sharp application ? can anybody explain or provide me good url that how to integration crystal report with front end application ? thanks.

hi everyone, i am using bar chart in my report. on x-axis i shows dollar amount 0 , 100k , 200k , 300k , 400k, 500k, 600k on y-axis shows 4 items - Accesories , Bikes, clothing, components i am also using legend which shows year. on y-axis each item shows bar for each year dollar amount...

Hi Members, I have a line chart that shows Total $ for each person for 5 years. There are 5 charts (one for each department). The years are 1999, 2000, 2001, 2002, and 2003. The chart should display the totals in that order but sometimes it mixes them up (2000, 1999, 2001, 2002, 2003). I've...

Hi everyone, i am beginners in crystal XI. i have one problem with arrays in formula. my columns displays is like this -- column1 2001 2001 2001 2001 2002 2002 2003 2003 2003 2004 2004 actually i want to display distinct years in ascending order. i have one logic that i can use current raw...

Hi, 5 my Y-axis values are like, $200000 $100000 $50000 i want to reduce gap - height between two Y-axis scale value. i tryied to find height and width property in char exper. but i could not. can anybody pls help me. thanks.

Hi everbody, i would like to know diffarance between dashboard and crystal report ? i heared that xcelius is a dashboard. can someboady provide me any good URL or explanation regarding this ? i appriciate your time and help. thanks.

Hi everyone, i am facing problem regarding that how to dynamically change scales values on axis x and y in chart. do i need to write formula for that ? or without writing formula is it possible ? any help is greatly appriciated. thanks to all.

Hi everyone, in chart on vetical axes, i have, $30.00 &20.00 $10.00 $0.00 if no values lies between range $0.00 to $10.00 then i do not want to show that scale in chart run time. same if no values lies between $20.00 and $30.00 then i do not want to show that scale in chart. any kind...

Hi everyone, i would like to know, that like year to date and month to date function (YTD,MTD) year to month function is qvailabel in crystal XI or not ? thanks.

Hi everyone, Hope everyone doing excellant. i am using SQL query in SQL command. query runs fine in TOAD. but when i am tyring to filter result of query by using parameter in sql command then it gives me problem and it is not working. when same parameter i implemented in record selection, then...

Hi everone, i have one number field on x-axis of chart. i need to display $ sign in front of my number, right now i am getting 100,000.00 i need in formate of $100,000.00. i did tried in formula and concatnate $ and number field. but it is not working. thanks.

hi everyone, i am very new to crystal report. i am stuck with one array creation problem in formula. can anybody provide me good material or guidance or step that how to creat ARRYA in XI ? any help appriciated