Search results for query: *

Hi, We are using crystal version 2008. Can you tell me if Weighted averages can be calculated using crystal reports? We were having issues using Bex and we did not want to store the calcuated values in cubes. Can you tell me in brief what all do I need to use to be able to do weighted...

Hi, I have a cloumn 1 for fiscal year period in MS excel. I also have a 2 additional second column for which I have to create 2 series within the chart with the fiscal period on the X axis. But i need to show only the "last 12 months" of the fiscal period only. how do I do this in the...

hi, I am using crystal version 10. The USA phone numbers are in the format: (212)345-6789 and The UK phone numbers are in the format: 44-212-345-6789 I need ONLY the last 4 numbers: example 6789 like in the above example Please advise Thanks bob

Hi, I have created a report in SSRS 2005. However, the user would like to see the report in excel/blackberry. Right now the user has to zoom in etc to see the report. How and what can i do to "Optimize" the report for blackberry? Please advise Thanks bob

Hi, I am using CR version 10. I need a page footer on page 1 of my report. I have the following sections: RH a - Free form placement, keep together RH b - Free form placement, suppresss , keep together RH c - Free form placement, suppresss RH c - Free form placement, suppresss RH d - Free...

hi, I have a report developed by a previous developer - can you tell me what it means? if isnull({view.field 1) or {view.field 1}=" " then left({view.field 2}, 10) else {view.field 1} what does this mean?? ---> left({view.field 2}, 10) especially left ? and ,10 Thanks bob

hi, I am using crystal version 10. I have inserted a sub-report and i also have to drill down 2-3 levels down. So when i click on the bar chart in page 1 it takes me to the sub-report -- *** BUT this is not clickable/drill down YET. I have to click * anywhere on this un-drillable sub-report...

hi, Lets say the report uses 6 parameters (dynamic or range)and the requirement of the report also is to ** display the names of the parameters and what values were chosen. example of parameters: City, Buildings, Floors, Rooms Buildings: 55 Hudson, 22 broadway, 1600 pensylvanina ave Floors...

hi, I am requesting how to group and use drill down to properly represent the report requirement. I am using Crystal version 10. Report presently uses 3 parameters(Building,floor,location area). Can use more if necessary. example. Building = 100 times square --> this is represented by...

Hi, I am using Crystal v 10. I need to drill down into a sub-report(more than two levels down) -- but I am unable to get the page footer. I can give more details but if you can tell me for certain if it's possible then please let me know TIA bob

hi, Can somebody direct me to where i can find report designs of other designers just to get design inspirations/ideas? TIA bob

Hi, I am using Crystal v10. I have seen this thread in the FAQ's http://www.tek-tips.com/faqs.cfm?fid=5684 (Displaying parameters chosen using a formula)- that is displaying whatever the user has chosen. This i am able to use. Now I want to display the output for the chosen parameter. -- Let...

hi I have a RHa and Rhb , with RHb containing a drill down chart. This is in page 1.I want to display the page footer here but I am unable to do so. What are my options/ Thanks bob

HI , I am using Crystal v 10. I have a group called U-height (for servers in a datacenter). In change group options i have done the following: <5U --> edit -> is less than 5.0 5U-14U --> edit -> is between 5.0 and 14.0 15U-24U --> edit -> is between 15.0 and 24.0 25U-Max --> edit -> is >...

HI, I am using CR v10. I have the following sections Gh1 -- suppressed Gh2 -- suppressed Gh3 -- suppressed Gh4 -- Building name Gh5 -- Floor Gh6 -- Location area code Gh7a -- small sub-report with employee name Gh6 -- There are many location area codes. Question; I want to underlay...

Hi, I have say 100 computers with identifying asset numbers in GH2c as a column(location) . Similarly I have 1 month, 3 months, 6 month, 9 month etc in Gh1c -- these represent the number of computers that have not been audited in these months. Now i want to create the location in GH2c as a...

Hi, i am using cr v10. I have a lots of computers with tag numbers. Right now most of them have tag numbers. I have a report where i need to group them together. For those that don't have tag numbers i want to label them "Un-allocated" Question: For this i am doing Group by from the group...

hi , I am using CR v10. if {@MonthRange} = ' 9 Months' then 1 else 0 When i create a summary based on this in RF i obviously get 0 in someplaces. How can i replace the 0 with: 1)nothing or 2) - Thank bob

hi, When using a sub-report in a main report -- is it "always" possible to show a page footer in every single page of the report? Thanks bob

I am using Crystal Reports v 10. I have a bunch of servers that are being reported for "NOT being audited". On the X axis I have a month range -- @month range. Y - axis = count of location group 1 = month range group 2 = Datacenter (Location) In month range i have 'specified order' and i...