Search results for query: *

HI All, I am using Crystal Reports XI version. Database : DB2 I have an CASEID field in DB2 which is of type BIGINT I have a report which shows the summary of a region related CASEIDs however I have a dynamic report which has CaseName as subreport caption. I am passing the caseid as...

Thanks for replying. Well I have simplified the query for posting it in the forum. we have the query like this select * from Table where Datefield >= date(substr(CHAR(YEAR((@Prompt('Select Date','D',,Mono,Free)))),1,4)|| '-1-1') AND Datefield <= date(substr(CHAR(YEAR((@Prompt('Select...

I am not sure if I am doing it in the right forum. i am using Business Objects Designer V 11.5.0.0. I have created a derived table which has prompts user to select a year like this select * from ABC where YEAR (ABCDate) = YEAR[highlight #FCE94F](@Prompt('Select...

Table : "TableXYZ" Column : "ColumnA" User provides a value which is stored in variable "UserYear" Needed Query : Select all fields from TableXYZ where year of columnA = UserYear Query I came up with : select * from TableXYZ where year(columnA) = UserYear. Query my boss want : He wants a...

Thank you so much for the reply. SQl expression I have never worked, and that is one thing I would like to learn. Is there any white paper which teach the basics of the SQl Expression.

I have simplified the report for you. I have around 10 sections in the Group footer and then the first 5 have about atelast 300 of formula which displays state values and then we have in the next sections "County" values in the sub report. THe layout can not be changed as it is per user...

Actually that is the problem..we show "State Values" in the GROUP HEADER 1 out of which a few formula are based on "County Values" from the subreport in the Section 2. I was hoping if a workaround is there ...Thanks for the response though..

Hi I am using Business Objects XI. I will try to trim down the issue so that it makes sense. I have a Group Footer in that I have two sections In Section A I have a Shared Var CaseCount In Section B I have a subreport which will give the Shared Var CaseCount = 25. How can i get the...

I have selected A1 to C3 and the data was as follows ccc cc cc abc aaa aa aaa aaa aaa and then clicked on conditional Formatting and then new rule and then Use a formula to determine which cells to format and then pasted the formula =NOT(AND($A2=$B2,$A2=$C2)) and i have got only the first row...

so how do i write the formula and also the data...i mean when i add formatting formula it remeoves data...is there somethingi am missing??

Hi I am not that good with excel so please bare with me ..I am using excel version 2010. I have data like this Column A Column B column C Abc.......abc.....abc ccc.......ccc.....ccc bab.......bab.....bab aaa.......aaa.....aaa ccc.......aa......ccc ccc.......cc......cc and i want...

Thank you for the prompt responses... Yes I can't group based on XYZ...otherwise that would have solved the situation before... The section A and Section B are in Group footer section rather than Details section...while i was doing a test report i just simplified it...I just created a group and...

if you added a section to the group footer (one for state and one for federal... you will need to formulas on should say if xyz = 'state' then whatever results you want and place that in the GF1a section the other should say if xyz = 'federal' then whatever federal results you want and plae...

By Section I mean Report section part ...in this example Details Section A, Details Section B ...

HI Just the update...I just tried it and event he numbers does not increment... in Report Header i have a TestINIT formula ....Numbervar X:= 1 in Details A i have Test1 formula ....numbervar X := numbervar X + 1; in details B i have place the same Test1 formula... The result was like Report...

Hi Thank you so much for posting the reply.. Well the solution does not work in my situation.. let me explain in detail how it will not work.. I need to change the formula based on the section or Group footer... like In section A it is always 'STATE' funding code in Section B it is always...

Hi I am using Business objects XI. I want to know if there is a way to change the value of a formula based on the section it is.. Lest say i have a group footer and i have two sections Sec A and SEC B. In Sec A the value should be 1 in Sec B the value should be 2 please let me know if you...