How to make ship list

Dear all, I have a request to make a shipment list.
The shipment is listed by 3 columns in horizontal direction.
ex.
Original ship sn :
ship001
ship002
ship003
ship004
ship005
ship006
Ship List Report format :
ship001......ship002......ship003
ship004......ship005......ship006
How should I do in reporting services?
Should I use List, Table, or Matrix '!
please help!
thanks.You could use a List control and set the Layout\Columns property of the
report body to 3? (The Preview tab doesn't display this correctly though;
you will have it export it PDF to see it correctly).
Mark
"sam" <sam@.discussions.microsoft.com> wrote in message
news:A33C9698-2C6C-4BF8-A387-D6BCC2AACB81@.microsoft.com...
> Dear all, I have a request to make a shipment list.
> The shipment is listed by 3 columns in horizontal direction.
> ex.
> Original ship sn :
> ship001
> ship002
> ship003
> ship004
> ship005
> ship006
> Ship List Report format :
> ship001......ship002......ship003
> ship004......ship005......ship006
> How should I do in reporting services?
> Should I use List, Table, or Matrix '!
> please help!
> thanks.|||I have the same PB.
is it possible to have a multicolumn subreport ?
when i used nested multicolumn in my report, the other column are not display!
any idea '
regards
"MCC" wrote:
> You could use a List control and set the Layout\Columns property of the
> report body to 3? (The Preview tab doesn't display this correctly though;
> you will have it export it PDF to see it correctly).
> Mark
> "sam" <sam@.discussions.microsoft.com> wrote in message
> news:A33C9698-2C6C-4BF8-A387-D6BCC2AACB81@.microsoft.com...
> > Dear all, I have a request to make a shipment list.
> > The shipment is listed by 3 columns in horizontal direction.
> > ex.
> > Original ship sn :
> > ship001
> > ship002
> > ship003
> > ship004
> > ship005
> > ship006
> >
> > Ship List Report format :
> > ship001......ship002......ship003
> > ship004......ship005......ship006
> >
> > How should I do in reporting services?
> > Should I use List, Table, or Matrix '!
> > please help!
> > thanks.
>
>|||Another related question..
What if I want to place shipment header on the top of the page?
I cannot place any objects across the multi-columns report body.
Any suggestions or ideas for me ?
thanks
"MCC" wrote:
> You could use a List control and set the Layout\Columns property of the
> report body to 3? (The Preview tab doesn't display this correctly though;
> you will have it export it PDF to see it correctly).
> Mark
> "sam" <sam@.discussions.microsoft.com> wrote in message
> news:A33C9698-2C6C-4BF8-A387-D6BCC2AACB81@.microsoft.com...
> > Dear all, I have a request to make a shipment list.
> > The shipment is listed by 3 columns in horizontal direction.
> > ex.
> > Original ship sn :
> > ship001
> > ship002
> > ship003
> > ship004
> > ship005
> > ship006
> >
> > Ship List Report format :
> > ship001......ship002......ship003
> > ship004......ship005......ship006
> >
> > How should I do in reporting services?
> > Should I use List, Table, or Matrix '!
> > please help!
> > thanks.
>
>|||While in SSRS and the report is exported to PDF, the rows are not 3 across.
the records go down the top then down again.
"sam" wrote:
> Another related question..
> What if I want to place shipment header on the top of the page?
> I cannot place any objects across the multi-columns report body.
> Any suggestions or ideas for me ?
> thanks
> "MCC" wrote:
> > You could use a List control and set the Layout\Columns property of the
> > report body to 3? (The Preview tab doesn't display this correctly though;
> > you will have it export it PDF to see it correctly).
> >
> > Mark
> >
> > "sam" <sam@.discussions.microsoft.com> wrote in message
> > news:A33C9698-2C6C-4BF8-A387-D6BCC2AACB81@.microsoft.com...
> > > Dear all, I have a request to make a shipment list.
> > > The shipment is listed by 3 columns in horizontal direction.
> > > ex.
> > > Original ship sn :
> > > ship001
> > > ship002
> > > ship003
> > > ship004
> > > ship005
> > > ship006
> > >
> > > Ship List Report format :
> > > ship001......ship002......ship003
> > > ship004......ship005......ship006
> > >
> > > How should I do in reporting services?
> > > Should I use List, Table, or Matrix '!
> > > please help!
> > > thanks.
> >
> >
> >sql

How to make report server email a report on request?

Rather than use a schedule to email a report, I want to get the report
server to email a report on request from a batch job.
Is it possible to do this by issuing a single HTTP url to the report server?
--
McGeeky
http://mcgeeky.blogspot.comTry this:
1. Schedule the report to send an e-mail the way you want it. Set the next
run time to yesterday at this time. Save the schedule.
2. Look at the jobs in the SQL Server, and look for the job that has a
scheduled date/time of yesterday.
3. either you call that job or execute the SQL from the only step within
your app. Either way, do not modify the scheduled job or the RS Schedule,
otherwise the link is lost and the report will not work.
If somebody knows how to schedule directly the reports within RS via T-SQL,
please share it with us.
Thank you|||Thats a good tip. Thanks Cesar
--
McGeeky
http://mcgeeky.blogspot.com
"Cesar Meza" <CesarMeza@.discussions.microsoft.com> wrote in message
news:D387E824-1664-4FE0-8FA3-1111DDBBA182@.microsoft.com...
> Try this:
> 1. Schedule the report to send an e-mail the way you want it. Set the next
> run time to yesterday at this time. Save the schedule.
> 2. Look at the jobs in the SQL Server, and look for the job that has a
> scheduled date/time of yesterday.
> 3. either you call that job or execute the SQL from the only step within
> your app. Either way, do not modify the scheduled job or the RS Schedule,
> otherwise the link is lost and the report will not work.
> If somebody knows how to schedule directly the reports within RS via
T-SQL,
> please share it with us.
> Thank you

How to List information by date

Hi,

I want to track the lifecycle of a request(requestno), the time it was submitted to accepted/denied.

The information is captured as :

Audit

auditid
adminid
auditdate
requestno
taskid

auditid adminid auditdate requestno taskid
1 1 12/06/2007 1 1
2 3 13/06/2007 2 1
3 12 12/06/2007 3 1
4 2 13/06/2007 1 2
5 2 16/06/2007 1 3
6 4 14/06/2007 2 2
7 4 7/06/2007 2 4

Task
taskid
taskname

taskid taskname
1 Submitted
2 InProgress
3 Accepted
4 Denied
5 Transferred

I want a query that will list down the following. There should be only one row for each request :

RequestNo DtSubmit DtProgress DtAccepted DtDenied Admin
1 12/06/2007 13/06/2007 16/06/2007 null 2
2 13/06/2007 14/06/2007 null 17/06/2007 4
3 12/06/2007 null null null 12

Thanks,

Vidya.

here it is,

Code Snippet

Create Table #audit (

[auditid] int ,

[adminid] int ,

[auditdate] datetime ,

[requestno] int ,

[taskid] int

);

SET DATEFORMAT DMY

Insert Into #audit Values('1','1','12/06/2007','1','1');

Insert Into #audit Values('2','3','13/06/2007','2','1');

Insert Into #audit Values('3','12','12/06/2007','3','1');

Insert Into #audit Values('4','2','13/06/2007','1','2');

Insert Into #audit Values('5','2','16/06/2007','1','3');

Insert Into #audit Values('6','4','14/06/2007','2','2');

Insert Into #audit Values('7','4','7/06/2007','2','4');

Create Table #task (

[taskid] int ,

[taskname] Varchar(100)

);

Insert Into #task Values('1','Submitted');

Insert Into #task Values('2','InProgress');

Insert Into #task Values('3','Accepted');

Insert Into #task Values('4','Denied');

Insert Into #task Values('5','Transferred');

Select

RequestNo

,Max(Case When T.[taskid]=1 Then [auditdate] End) DtSubmit

,Max(Case When T.[taskid]=2 Then [auditdate] End) DtInProgress

,Max(Case When T.[taskid]=3 Then [auditdate] End) DtAccepted

,Max(Case When T.[taskid]=4 Then [auditdate] End) DtDenied

,Max(Case When T.[taskid]=5 Then [auditdate] End) DtTransferred

,Max(Adminid)

From

#audit A

Join #task T On A.[taskid] = T.[taskid]

Group By

RequestNo

|||

Bingo!!

Thanks.