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!

  • Congratulations strongm 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: *

  1. swiss2007

    Labels in details repeat on next page

    Thanks Madawc for the reply but the problem is the data is not grouped.
  2. swiss2007

    Labels in details repeat on next page

    One correction, The label is not college but College Year. Any help is appreciated, Thanks
  3. swiss2007

    Labels in details repeat on next page

    I have 3 columns College, Year and programs and the data looks like College Year Program 2005-2006 1styear Maths Physics English Earth Science 2006-2007 2ndyear AB CD EF GH IJ KL MN OP QR 2007-2008...
  4. swiss2007

    html formatting

    Thanks but what is the content of {@wirk}
  5. swiss2007

    html formatting

    Thanks lb. I have the following text field in the application in 4 lines A B CD EFG No matter how I format the field in the front end application, in crystal report when I set the field formatting to html text, it shows up as ABCDEFG without the tags and other formatting like line break...
  6. swiss2007

    html formatting

    I have a crystal report designed using crsystal reports V11. A few fields in the database are stored in html tags. When I show these fields in the report, the html format is showing up. When I right click on the fields ----> Format field ----> Paragraph ----> Text interpretation ----> HTML...
  7. swiss2007

    Grouping in intervals

    I have orderid, customer name and orderamt 1, abc, 950 2, abd, 500 3, abe, 450 4, abf, 1950 5, abg, 1200 6, abx, 2200 7, aby, 2500 8, abz, 2700 9, abxx, 2800 10, abzz, 3100 I want to pass one parameter number, 100 or 500 or 1000 so that the order amt results are grouped based...
  8. swiss2007

    Spliting a long txt string into two parts at a variable mark

    Have you tried Right click on the field -----> Format Text ------> Uncheck Keep Object Together.
  9. swiss2007

    show the cross tab difference

    I have completely 2 different datasources pcp1 and pcp2 and are not related The data coming from pcp1 and pcp2 is most of the times same but not always. I have a cross tab in the main report taht displays data from pcp1 and subreport that displays data from pcp2 my goal is to find if there is...
  10. swiss2007

    Extract Part of a field using a formula

    sorry, I meant if {Table.yourstringfield} like "*0-325*" then true else false
  11. swiss2007

    Extract Part of a field using a formula

    if {Command.abc} like "*0-325*" then true else false
  12. swiss2007

    Running total when two data types are similar formula

    In Running total formula use a formula like if {C_CAR.TYPE} like "*Slow" then true else false
  13. swiss2007

    field doesn't contain

    try using the following formula in the select ----> selection formulas ----> Record Not({DATACOMMENT} LIKE '*partial*')
  14. swiss2007

    Strings

    you could try strreverse(extractstring(strreverse({yourstring}),"","-"))
  15. swiss2007

    Highlight cross tab cell and also other cells

    But the highlighting expert only gives the option to highlight Profit(Y/N) field and not Orderamt field based on the Profit(Y/N) field.
  16. swiss2007

    Highlight cross tab cell and also other cells

    I have a Cross tab that has Rows Country Columns Year Summarized fields orderamt Profit(Y/N) sample data looks like 2001 2002 Austria Orderamt 4200 6000 Profit(Y/N) Y N France Orderamt 5500 5000 Profit(Y/N) N N Germany Orderamt 12000 10000 Profit(Y/N) N Y Ireland...
  17. swiss2007

    Record Selection From a Sum Calculation

    Hi Tested again, USE create 2 formulas @Cash if Cash = 0 then Cash else 0 @NonCash if NonCash = 0 then NonCash else 0 insert a sum on these 2 formulas in GF4 and u can suppress it. then go to report ---->selection formulas----> Group and write a condition sum(@Cash,transdate) = 0 and...
  18. swiss2007

    Record Selection From a Sum Calculation

    create 2 formulas @Cash if Cash <> 0 then Cash else 0 @NonCash if NonCash <> 0 then NonCash else 0 insert a sum on these 2 formulas in GF4 and u can suppress it. then go to report ---->selection formulas----> Group and write a condition sum(@Cash,transdate) = 0 and...

Part and Inventory Search

Back
Top