Creating sub folders in VS.NET 2005 for reports

Hi,
I am wondering if anyone has done this...I can't find it in either of
the book I bought.
I have created som dashboards that each have numerous drills in them to
other reports. All these reports are currently living in on
folder...What I would like to do is to create a subfolder in designer
and deploy the detailed reports into a separate folder like 'Detailed
Reports' so that when the user logs into the report he/she just sees
the dashboards and does not see the rather long list of detailed
reports.
I have tried all the usual things but can't see how to do this...I must
be missing something simple...I am sure..
Peter
www.peternolan.comHi Peter,
You can change the value specified for TargetFolder in your designer to
piont to the new subfolder where you would like to store your detailed
reports.
eg. reports/Mynewsubfolder
Cheers,
Ramya
Peter Nolan wrote:
> Hi,
> I am wondering if anyone has done this...I can't find it in either of
> the book I bought.
> I have created som dashboards that each have numerous drills in them to
> other reports. All these reports are currently living in on
> folder...What I would like to do is to create a subfolder in designer
> and deploy the detailed reports into a separate folder like 'Detailed
> Reports' so that when the user logs into the report he/she just sees
> the dashboards and does not see the rather long list of detailed
> reports.
> I have tried all the usual things but can't see how to do this...I must
> be missing something simple...I am sure..
> Peter
> www.peternolan.comsql

Creating sub folders in VS.NET 2005 for reports

Hi,
I am wondering if anyone has done this...I can't find it in either of
the book I bought.
I have created som dashboards that each have numerous drills in them to
other reports. All these reports are currently living in on
folder...What I would like to do is to create a subfolder in designer
and deploy the detailed reports into a separate folder like 'Detailed
Reports' so that when the user logs into the report he/she just sees
the dashboards and does not see the rather long list of detailed
reports.
I have tried all the usual things but can't see how to do this...I must
be missing something simple...I am sure..
Peter
www.peternolan.comHi Peter,
In VS Designer when you check the properties for your report project,
under the deployment section you will find the TargetFolder property.
You can specify the subfolder path here eg. folder/subfolder. Do this
before you deploy your detailed reports.
Hope this helps.
Cheers, Ramya
Peter Nolan wrote:
> Hi,
> I am wondering if anyone has done this...I can't find it in either of
> the book I bought.
> I have created som dashboards that each have numerous drills in them to
> other reports. All these reports are currently living in on
> folder...What I would like to do is to create a subfolder in designer
> and deploy the detailed reports into a separate folder like 'Detailed
> Reports' so that when the user logs into the report he/she just sees
> the dashboards and does not see the rather long list of detailed
> reports.
> I have tried all the usual things but can't see how to do this...I must
> be missing something simple...I am sure..
> Peter
> www.peternolan.com|||Hi Ramya,
the way I see this is that each report project in vs.net must go to one
folder on the target report server...correct?
Therefore I would need a project for my dashboards and another project
for my detailed reports....
I should be able to just split prodjects like that correct?
(I was looking for how i created subfolders inside the one project but
it seems like it will not do this...)
Thanks
Peter
www.peternolan.com.|||Hi Ramya/Others,
I tried new projects and pointing reports across to the new project but
they are not available in 'jump to report' list and I would need to
point them to a URL...so I also tried hiding the detailed reports in
the folder, and this pretty much gives the effect I want....the
reports are hidden unless the user click detail but they run when
drilled into....so that when the user open the folder there only looks
like there are the dashboard reports there and the folder is not
cluttered.
Peter

Creating report folder hierarchy in VS.NET

Is it possible to create (or duplicate) the report server Report Manager
folder hierarchy in the VS.NET development IDE? There does not appear to be
an option to add a Folder to the Solution Explorer tree, and if I drag a
folder from the file system into the tree I receive an Access Denied message
when I try to open it.
I would like to be able to create a deployment hierarchy, because now all
reports deploy to the project root on the Report Server, and I have to move
them to the correct folder.
Thanks,
TimFolders are not supported in Report Designer.
It is in our wish list for future version.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Dreyling" <TimDreyling@.discussions.microsoft.com> wrote in message
news:3F148B87-78EB-4E61-8D04-BA286EAB13A3@.microsoft.com...
> Is it possible to create (or duplicate) the report server Report Manager
> folder hierarchy in the VS.NET development IDE? There does not appear to
> be
> an option to add a Folder to the Solution Explorer tree, and if I drag a
> folder from the file system into the tree I receive an Access Denied
> message
> when I try to open it.
> I would like to be able to create a deployment hierarchy, because now all
> reports deploy to the project root on the Report Server, and I have to
> move
> them to the correct folder.
> Thanks,
> Tim|||To build a deployment hierarchie you could add several projects to your
solution and enter a different deployment folder for each of the projects.
Hth,
Pieter
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:%23Yt2JPlrEHA.376@.TK2MSFTNGP14.phx.gbl...
> Folders are not supported in Report Designer.
> It is in our wish list for future version.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Tim Dreyling" <TimDreyling@.discussions.microsoft.com> wrote in message
> news:3F148B87-78EB-4E61-8D04-BA286EAB13A3@.microsoft.com...
>> Is it possible to create (or duplicate) the report server Report Manager
>> folder hierarchy in the VS.NET development IDE? There does not appear to
>> be
>> an option to add a Folder to the Solution Explorer tree, and if I drag a
>> folder from the file system into the tree I receive an Access Denied
>> message
>> when I try to open it.
>> I would like to be able to create a deployment hierarchy, because now all
>> reports deploy to the project root on the Report Server, and I have to
>> move
>> them to the correct folder.
>> Thanks,
>> Tim
>|||Thanks for the answers. I will give it a shot.
"Pieter van Maasdam" wrote:
> To build a deployment hierarchie you could add several projects to your
> solution and enter a different deployment folder for each of the projects.
> Hth,
> Pieter
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:%23Yt2JPlrEHA.376@.TK2MSFTNGP14.phx.gbl...
> > Folders are not supported in Report Designer.
> > It is in our wish list for future version.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Tim Dreyling" <TimDreyling@.discussions.microsoft.com> wrote in message
> > news:3F148B87-78EB-4E61-8D04-BA286EAB13A3@.microsoft.com...
> >> Is it possible to create (or duplicate) the report server Report Manager
> >> folder hierarchy in the VS.NET development IDE? There does not appear to
> >> be
> >> an option to add a Folder to the Solution Explorer tree, and if I drag a
> >> folder from the file system into the tree I receive an Access Denied
> >> message
> >> when I try to open it.
> >>
> >> I would like to be able to create a deployment hierarchy, because now all
> >> reports deploy to the project root on the Report Server, and I have to
> >> move
> >> them to the correct folder.
> >>
> >> Thanks,
> >> Tim
> >
> >
>
>

creating extended stored procedure using vs.net 2005 for sql2005

Hi,

web searches give no end of how extended stored procedures can only be written in C++ ( or maybe vb also) .

And that extended stored procedures should be abandonded in favour of CLR framework procedures.

And how most articles explain how to convert ESPs to CLR procedures!!!!!

But I need to pass a non-discript block of binary data, extract pieces of data identified by its offset into the block, data type inferred by offset; into data to be written to the SQL database. These offsets are determinede by mapping (C UNION) to C typedef structures.

This cannot be done by managed code, therefore cannot be done by C++ CLR.

It is also ill suited for C# .

Sounds like a job for C++ extended stored procedure.

But how does one create and deploy an ESP with Visual Studio 2005? All wizards seem to insist on CLR.

Help!?

Boyd

This is an interesting problem, why are you sending in a binary block of data like that instead of disassembling it on the client side?

Thanks,

John

|||

Hi,

The binary block could have in the order of 50 different fields concatinated one byte after another. This binary structure maps to a "c typedef struct " definition.

Legacy systems take such a structure, do a "memcpy" out a communication port, a machine at the other end receives the bytes, assigns a pointer of the appropriate "typedef struct" and by inference knows exactly where the data as and the type ( integer, real, character array of fixed length, .... )

Disembling this stuff on the client side requires round-trips to the server for each and every field - very time consuming - especially when I could easily have 400 such blocks (8000 fields) per second from another machine on the network. Then write each field back if it changes (16000 transactions per second over the network). Might be a performance issue. Much more efficient to forward the block to the sql server once and let it do the ripping and shredding.