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

Part and Inventory Search

Back
Top