Search results for query: *

thanks ! So we can summarize data coming from sub-reports? Secondly, we can access stored procedures from within crystal -- correct? Thanks bob

Hi, Thanks for the quick reply. Our final value would be based off of 4 different calculations all interconnected with each other. So if we have one calucated weighted average based on a query -- it will have to be used in an other query and so on and the final result will have to be...

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

Thank you very much LB

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

Lbass, Regarding your comment "-- Report header pages have no page footers" Is it possible to do the following? : In "Report Options" i check "Show All Headers on Drill Down" and then use DrillDownGroupLevel to control other sections of the report. Please advise bob

Lbass, Regarding your comment "-- Report header pages have no page footers" Is it possible to do the following? : In "Report Options" i check "Show All Headers on Drill Down" and then use DrillDownGroupLevel to control other sections of the report. Please advise Vijay

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

Lbass, Yes you are right -- only RH shows up on page1. 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...

you said "---but you need to have it displayed separately before you can drill down within the sub-report" My question is this: The user does not what a sub-report is , so how or what does a CR designer say on the sub-report displayed page -- aka -- click here ????? to see ?? and click again...

Lbass, what do you mean by left function ? so you are saying that the following assessment of the formula is incorrect? if {view.field 1} is null or {view.field 1} equals SPACE if isnull({view.field 1) or {view.field 1}=" " then return the left 10 characters of {view.field 1} else return...

lbass you had earlier mentioned: "If you place the display formula in the page footer, it will only show -------- Because of this, the results are only accurate in footer sections. If you want to display the same info, but in a report header section, you would need to insert a crosstab as...

The previous reporting guy made a mistake he should have used then return the left 10 characters of {view.field 1 } Thanks Guys -- i just had to make sure i understood it correctly Regards bob

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

I am able to display them -- that's not the issue atall. The question here is "presentation" -- does it not look * gross (for lack of a better word)?? for 6-8 parameter values listed horizontally across the page header? -- Imagine if i am doing this for 7 more parameters listed one below the...

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

I am using a Ubound function to display all the values that the user has chosen. So in the top left corner of the page will look like: Parameter 1: 225 new york ave, 645 penn ave, 1355 main street Parameter 2: similar like above Parameter 3: similar like above Parameter 4: similar like above...

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