Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Help requested in formulating Functions and script to create a mat
0 views
Skip to first unread message
JRatWork
Jan 5, 2010, 10:14:03 AM1/5/10
to
Visual Studio.net 2003, SQL Server Report Designer, SQL Query Analyser.
I have a table of milestones with data such as project, miletone name,
baseline date, planned date and actual date. My task is to produce a chart
that has months in the columns and for each month a set of blocks of data,
made by concatenating fileds form the table, for milestones due in that
month. I can extract the 'blocks' of data easily enough but when I put them
in columns each successive month starts on a new line below those of the
previous month. I need it so that the first milestone of each month is in
the first row, the second of each in the next row and so on. Months have
different amounts of milestones and some months have no milestones but there
must be a column shown.
I have a table of milestones with data such as project, miletone name,
baseline date, planned date and actual date. My task is to produce a chart
that has months in the columns and for each month a set of blocks of data,
made by concatenating fileds form the table, for milestones due in that
month. I can extract the 'blocks' of data easily enough but when I put them
in columns each successive month starts on a new line below those of the
previous month. I need it so that the first milestone of each month is in
the first row, the second of each in the next row and so on. Months have
different amounts of milestones and some months have no milestones but there
must be a column shown.
Can anyone help with ideas of how to write a function or functions which
will deliver the rows to the Report Designer??
0 new messages