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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BrendanBlackford

  1. BrendanBlackford

    select nested aggregate

    Thank you. Can you explain this? It doesn't work. 25 A 25 A 25 A 25 A dissapeared as well. The only thing that appear is the jobs that don't have correspondent in ch. How do I print that: Substring(Ch.Cost,4,7) JNr Ch.Type I appear now with the name BB, because I'm...
  2. BrendanBlackford

    Subreport from Cross Tab ... or something else

    Thank you for your reply. Now I have other issue. I have for A1 a cell. Over each cell I put an on demanding subreport without name. A B C 1 2 3 When I oped the report, after I closed it, Crystal puts names on each subreport, like A1 - without name, B1 name - 01, C1 name - 01,02 Can...
  3. BrendanBlackford

    Subreport from Cross Tab ... or something else

    Hello CRXI on SQLServer I have a cross tab in a report, on horizontal Departures Loc and on vertical Arrivals Loc; on summary sum of formula: datediff("d",{ZTT;1.DepDate},{ZTT;1.ArrDate}) When I click for example the cell which is the intersection of A with B, is it possible to bring the...
  4. BrendanBlackford

    CASE in WHERE clause with parameter

    Hi all Excuse me for not replying sooner. Now in the procedure is: ( (@Choose = 'C' And (Tba.CAccNumber='123' or Tbb.SName like 'C%')) Or (@Choose = 'T' And (Tba.CAccNumber ='234' or Tbb.SName like 'T%')) Or (@Choose = 'Air' And (Tba.Via= 'Air' and not(@Choose = 'C' or @Choose = 'T' or...
  5. BrendanBlackford

    CASE in WHERE clause with parameter

    Thank you all. I have to write as well ... or (@Choose = 'SeaF' And (TbA.Via= 'Sea' And Tba.Type like 'F')) or (@Choose='AllOthers') then bring all the remaining rows
  6. BrendanBlackford

    Crystal Report Server XI release 1 Single Sign On problem with Windows

    I can't get single sign on (SSO) working for Crystal Reports Server XI release 1 (CMC 11.0.0.748) using Windows AD. I have followed the admin guide provided with the software, but get the logon screen each time I want to view a document using opendocument.aspx (.NET version). This forum topic...
See more

Part and Inventory Search

Back
Top