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 am getting the data results in 4 rows in detail section of the report as below: region ------ east west north south and i want to present join them to make it a single row like region ------ east, west, north, south when i use join it says it need a array where as the region field is...

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.

Do you have any PDF on how to start with manual cross tab?

The crosstab report I have like below: Group1:client name Group2: metric name 2010-07 2010-08 2010-09 Row1 Row2 Row3 Row4 Row 5 summarzied value Where row1- level1_resource_name, row2-level2_resource_name, row3-resource_type, Row4- resource_Groupname, row5- threshold_val...

the issues i have is: 1) the values are repeating if i am using summarized formula like count(field) and the crosstab summary is not grouping by the column which is datetime field in my case. 2) If i am using count(field) or avg(field) the summary value is not grouping accordingly. 3)If i use...

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})& "...

its oracle 10g

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.

but that does not work with opendoc

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

i am getting one parameter for customer and when i am doing dynamic cascading prompt to get all grouppath values for the customer, there it appear other customer prompt. and i cannot delete the customer parameter since it is from stored procedure. i want to remove the customer prompt appearing...

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

But is there any option of hiding parameter?

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