Search results for query: *

Hi, I have 2 parameters in the crystal report 2008.start_date and end_date which are like datetime format. when the user enters the value for the above parameters, he should be able to enter as "yyyy-mm-dd 00:00:00" when selected from the calender(keeping the time format as default to 00:00:00)...

i have a requirement where i should join the resulting fields into one field. that is i have region field. region ------ east west north south i want to present it in this way Region ------- east, west, north, south can somebody pls help me out. thanks.

hi, I need some help regarding buliding crosstab report 1) can we have cross tab summary bulit on condition like: if <condition> then count(field) else average(field) 2)can cross tab summary be summarized on already summarize field in the formula like: formula is count(field) then using this...

Hi, i have a crosstab report, where i have to summarized the summary field according to the condition below: IIF(Int(Count({RESOURCE.RES_TYPE}))>1, IIf(DateValue ({RESOURCE.START_LCL_TS}) <= DateValue (CurrentDateTime), Count({({@source value})& " Values",Count({RESOURCE.PROJECTION_VALUE})& "...

Hi, Is there any way or formula to pass Multivalues thru Parameter to a Stored Procedure. the report works fine with the single value,but with multivalues , the stored procedure is taking as null. So, can somebody help me out in passing multivalues thru parameter to stored procedure. thanks.

hi, i have a requirement in my report, The requirement is to open the report with the present paramter in the report through opendoc. but i dont know the report server location which is to be added. is there any way to get report server path location? thanks.

Hi, I have dynamic parameter in the report and i have the requirement to get all values in the drop down list to get all the values selected. I have tried but not able to get it. So wanted to know Is it possible to get all option in the dynamic parameter list? and is it possible to pass custom...

hi, in my report there is crosstab where there are 5 rows and a column. i have a requirement to create a link (hyperlink) to sort the row field as ascending or descending. when the user click on the link the row field should sort accordingly. I want to know how should i create the link to link...

Hi, I need help in creating dynamic parameter. i am having country parameter and region parameter both are different parameter without cascading. i want the parameters to appear with region values grouped by country value parameter. if i go with the option of cascading the parameters appear...

Is there any way to create dynamic parameter without cascading the fields? Like i am creating a report based on stored procedure. so there are multiple parameter coming up while creating. In my situation i have customer parameter and grouppath parameter . So when the user run the report when...

can somebody pls mention the formula for below i got for eachday,each week,month but needed for other: for each day: datetime(date({table.datetime}),time(0,0,0)) for each week: datetime(date({table.datetime})-dayofweek({table.datetime})+1, time(0,0,0) for each month...

i have a chart place in the group header, which is showing some values and on change of datetime field. the datetime field in group by the parameter interval like monthly,weekly,daily,hourly. if the parameter is monthly, the chart shows monthly data. i want to make the chart drill down so that...

Hi, i am creating a report in which i have created a text box call clipboard which is hyperlinked. when the user click on the clipboard it should open the report through browser. I have worked on adding the parameters to the path. but how can i get report file path location.

i am creating a report through stores procedure which have 11 parameter, which do appear while creating report. Is there any way to hardcode them in crystal and hide them from appearing to the end user? I want to pass the value of one parameter to other parameter to get the values dynamically...

Is there any formula or way to group the date field and printing the section by monthly,weekly,daily not by selecting it in group,but want to mention it by formula. Since i have a parameter in the report which mention the report to print monthly,weekly,daily.

thread149-1581864 Can you pls mention the formula if the interval is weekly,daily,hourly. as mentioned for quarter

I am creating a chart in the report,placing it in the group header grouped by metric_name and where the "on change of" is on date field based on formula. the formula is like if order_date in {?start_date} to {?end_date} then order_date. and show values on order_amount. and there is a parameter...