Results 1 to 2 of 2

Thread: Cross Tab Report Problem

  1. Jan 30th, 2006, 01:56 AM #1
    mfdarvesh
    mfdarvesh is offline

    Thread Starter
    Member
    Join Date
    Mar 2005
    Posts
    47

    Cross Tab Report Problem

    I am using SQL Server 200 with VB6 and Crystal Report 9.2. I have a created a cross tab using SQL Server stored procedure. My table as follows:

    PNo Head Amount

    I have turned Head as Privot. Now the problem is every employee has different No. of heads in this table. There may be any number of rows an employee has.

    How may I design a report so that all possible colums may be printed, as CR only shows the available no. of columns.
    Reply With Quote Reply With Quote
  2. Apr 3rd, 2006, 01:50 AM #2
    mansoor47
    mansoor47 is offline
    New Member
    Join Date
    Mar 2006
    Posts
    12

    Re: Cross Tab Report Problem

    i like your e mail, if it will be [email protected]
    Contact At
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width