Search results for query: *

hi jdemmi, thanks for reply.. i want to used in oracle query nt in CR. so your mention answer is for oracle query ? let me know. thanks/

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 all, Thanks for reply. i also heared that when we make views, it is aleady compile on server. so because of that reports runs fast ..is it right ? thanks.

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 fmrock, if you want to parameter as a optional, then you sould declare that parameter type is STRING. then only user can leave blank that parameter. let me know it works or not for you.. 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...

ok . but can i submit my .rpt in this forum ? thank lbass.

hi lbass, still this small thing gives me hard time. lbass i am using adventure works database which ships with sql server 2005 and from that i am developing my reports. so is there any way that i can e-mail my .rpt file so u can easily and find out my problem ? can you provide me your...

hi lbass, thanks and i apriciated your helpt to me my friend. lbass, yea i verified that i have more than on "on change of@ fields. first one is monthname and second below of it is a years. and i also verified that TOP N is not set on both of this field. but still it gives me hard time...

Hi Lbass and jahnavi, i have one question. if {?Teams}[i] in {table.leads} then ( redim preserve x[j]; x[i] := {table.leads} )); {table.leads} in x in above code, is {table.leads} contain all rows of column or only one raws ata one time in loop ? your help is greatly appriciated. thanks.

data type is string. The years are 1999-sales, 2000-sales, 2001-sales, 2002-sales, and 2003-sales. The chart should display the totals in that order but sometimes it mixes them up (2000-sales, 1999-sales, 2001-sales, 2002-sales, 2003-sales). so in 'on change of' filed datatype is string. i...

hi Lbass, thanks for given me reply. if not (totext({table.year},0,"") in x but in above statement, there is no value in X. how if part looking for value in variable x ? numbervar i; and also do we need to assign initial value ot i variable ? like numbervar i = 0; your help is appriciated...

hi lbass, i have number datatype thanks lbass