Search results for query: *

I export my report through EXPORT OPTION then microsoft word(RTF). I'm working on CR XI. I dont about the service pack.

Hi, I have a report with 2 GROUP BY sections. When I refresh the reoprt it looks fine in the CR but I export that report in MS-word the last records overlap with new page record. What should I do?

Hi, I have 2 subreports with 2 parameter fields city & date range. These parameters r static parameters (means I have created a notepad with list of cities & import them to parameter field same with dates parameter.I want 2 date ranges Minimum date & maximum date coz I want to display clients...

Hi, I'm SQL developer & just started working on Crystal reports XI. I'm using SQL in crystal reports to generate reports. I dont know much about how to DEFINE & USE formauls. Which is the best way or book to learn " How to define & use formula's in CRs" like record selection formula's.

Hi, I'm SQL developer & just started working on Crysat reports XI. I'm using SQL in crystal reports to generate reports. I dont know much about how to DEFINE & USE formauls. Which is the best way & book to learn " How to define & use formula's in CRs" like record selection formula's.

I got it. Thanks for ur help..

I'm using datetime type parameter. Both subreport & main report entry_date are of same data type.I have written ({Command_3.entry_date} >= Minimum ({?Date range}) and {Command_3.entry_date} <= Maximum ({?Date range})) in the selection formula for the main report. & ({Command_7.entry_date} >=...

I'm still not getting the correct output. I created a date_range parameter in the main report. I cant see date_range field in "select data in subreport based on field" Report field is all blank.

I have 4 subreports with 3 parameter fields(Cities,Advisor & Daterange). When I tried to link the report by selecting "Fields to link to" with 3 parameters. i can see City & advisor fields from subreports in "Select data in subreport based on field" But when I select "date range" parameter & add...

I have used a Static parameter to filter the report on date range. I have used 2 formula's Minimum ({parameter}) for starting date & maximum ({parameter}) for end date, & place these formula's in Report header. In parameters I kept "Custom values" & Range values' to TRUE. Its not working.

In Ist case I had only 1 null value like UId CHILDREN OTHER @FinalTotal 5 7 12 2 1 4 7 I made a formula @finaltotal (if isnull ({children}) then ({uid})+ ({other}) else {@Total}) where @Total is another formula UID + CHILDREN + OTHER...

Hi, How can I get the TOTAL for Null Values. UId CHILDREN OTHER TOTAl(SUM (UID)+(CHILDREN)+(OTHER) --- --------- ----- ------------------------------- 5 7 12 1 6 7 4 2 1 7 6...

Hi , I have a table with more then 50 Zipcodes & Client (UID's). Zipcodes UID 96745 10 95051 9 96457 6 98657 4 96234 4 TOTAl -----...

I used the first thing to get distinct count of uid's. Now I want to find the SUM of Distinct counts..Like I described earlier was "12

Hi, How can I sum a field which has Distinct count of nos. Zipcodes UId 95051 1 1 2 Total: 4 76891 3 3 Total: 6 96456 1 1 Total: 2...

Hi !! r937, Its working.. From last 3 hrs I'm trying-trying & ofcourse I was still trying.. Thanks for the help.. I was just wondering what if a client_id has only 1 referral like CLIENT_ID (UID 1) has only 1 referral UID NAME 1 peter;715-987-8656...

Hi, I got my half of the answer. UID NAME 1 peter;715-987-8656 1 jill;910-987-8778 2 mike;510-758-9767 2 mott;345-987-0876 Now is there any way I can do the following UID NAME 1...

Hi, I got my half of the answer. UID NAME 1 peter;715-987-8656 1 jill;910-987-8778 2 mike;510-758-9767 2 mott;345-987-0876 Now is there any way I can do the following UID NAME 1...

Hi Ibass, When I run the formula it gives the error: "String length is less then zero or not as Integer

UID is the CLIENT_ID & name are its references (like who referred them) CLIENT_ID (ie UID 1 is referred by 2 persons peter & jill & I have there phone numbers.) Like UID Question_id NAME 1 556 peter 1 601 408-976-8778(Peter'sphoneNumber) 1...