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 Chriss Miller 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. coffee123

    Cross tab. Cumulative totals?

    Problem Cross tab with a sum of a field. I need it to do a cumulative total to the end of the period. Ie sum(field1) + (field1) for the different date ranges. Iv tried to use a formula but the formula field does not appear in the "selectable report fields" got any ideas? or is...
  2. coffee123

    crosstab page breaks

    can you force a page break in a crosstab. ie New page after the total? thanks
  3. coffee123

    cross tabs naming coloum problem

    cheers mate your idea helped. It made me look at the problem at a different angle. thanks Kevin [thumbsup]
  4. coffee123

    cross tabs naming coloum problem

    greetings I have an intresting problem. I have a cross tab table. I have the dates in the coloum headings. But i need to put a changing text under the dates. eg headings =====> 07/07/02 14/07/02 etc .... changing text =====> Period 1 Period 2 etc .... Period 12 I have tried to...
  5. coffee123

    date time in SQL store procedure

    greetings Problem: im running reports of stored procedures. When i declare the parameters in the stored procedures to my knowledge you can only declare the parameters as date time. ie (@from_date datetime. ) when you call the stored procedure from the crystal reports. It brings up the...
  6. coffee123

    CROSS TABS for each week grouping

    Greetings people Problem. I have created a crosstab report. I am grouping cross tabs on date field with the "each week" group option. BUT here come the problem the date the crosstab defaults to the nearest sunday. Not good. I want it to be a first monday. ie Sunday + 1 day. in a...

Part and Inventory Search

Back
Top