Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nikol
  • Content: Threads
  • Order by date
  1. nikol

    Page break poblem

    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?
  2. nikol

    subreport problem

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

    CRXI formulas knowledge

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

    CR XI formula

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

    Subreport Linking Problem

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

    Parameter not working.

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

    Problem with 2 NULL values

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

    Top 5 selection

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

    SUM of Distinct counts

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

    sql Query

    Hi , UID NAME PHONE 1 peter 715-987-8656 1 jill 910-987-8778 2 mike 510-758-9767 2 mott 345-987-0876 Can I make the above DB columns as UID NAME 1...
  11. nikol

    GROUP BY problem..

    Hi, I have created a report where I have a GROUP BY SECTION with uid & DETAIL SECTION is supressed. LIKE: UID 1 PHONE 510-897-8976 STATE CA ---------------------------------------------------------- UID 2 PHONE 925-976-9087 STATE CA...
  12. nikol

    Conditional Statement problem..

    I have 2 tables answer & secunsec SELECT answer.uid, CASE when answer.question_id=1212 then secunsec.val_float end as rent from answer FULL OUTER JOIN secunsec on answer.uid=secunsec.uid QUESTION_ID=1212 means rent/uid This query gives me output as UID QUESTION_ID VAL_FLOAT...
  13. nikol

    Page setup

    How can I make my report in the center of the page while printing?
  14. nikol

    Record selection formula

    I have a report with record selection formula" if {?my Parameter} = 'All Cities' then 1=1 else {command.name} = {?my Parameter} " & a dynamic parameter list of cities as AllCities SJ SFO SC SA ... This report has grouping on gender like Female 5 Male...
  15. nikol

    Can have extra row

    I'm working in Crystal reports XI & using SQL also. I have a table with columns list_id name . when list_id =2, name column has all city names for particular state(like CA) LIST_ID NAME count 2 Sant Clara 3 2 San jose...
  16. nikol

    Subreport Problem

    I'm working on a report which has "City"parameter as static prompt. In SELECT EXPERT I have the formula if {?my Parameter} = 'All Cities' then 1=1 else {command.city} = {?my Parameter} . When I refresh the report It asks me for the city. If I do "All cities" , it gives me all clients in all...
  17. nikol

    Subreport problem

    I'm working on a report which has "City"parameter as static prompt. In SELECT EXPERT I have the formula if {?my Parameter} = 'All Cities' then 1=1 else {command.city} = {?my Parameter} . When I refresh the report It asks me for the city. If I do "All cities" , it gives me all clients in all...
  18. nikol

    adding "all' in a view

    Hi, I have table with a column which has shows all cities in CA state. Is it possible to add one more row "all cities" in a view.I cant add anything in DB tables. So,I was just wondering can I make a view of all CA state cities & add one more row "all cities" which means all cities in CA.
  19. nikol

    Subreports Linking

    Hi, i have 4 subreports & when I linked them together in DETAIL SECTION & refresh them. It give 16 reports 4-4 same reports of all subreports.What should i do?
  20. nikol

    subreport linking

    I'm trying to link my main report to subreports through a"static" parameter field. Its not working but if I link with dynamic parameter field it works fine. Is there anything I need to do to link subreports with static parameter field?

Part and Inventory Search

Back
Top