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
Showing posts with label folders. Show all posts
Showing posts with label folders. Show all posts
Tuesday, March 20, 2012
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
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
Monday, March 19, 2012
Creating SSRS folders?
New ssrs istall.
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
How do I create an ssrs reports folder?
Also, and this is strange, but in vs.net I had to create a new shared
datasource after removing the old one on the report with the same
name. The report renders fine when I do an f5 pointing to a new
datasource, but I no longer have the RUN "!" icon available while in
the data tag to run my query. Why is this?
Thanks for any help or information.Hello,
I suppose that user which you use to connect to Report Manager has
insufficient permissions.
Check if this situation takes place also if you use user account which is a
member of the server's Administrators group (BUILTIN\Administrators).
Or maybe you have in IIS configured anonymouse access to Report Manager
Site.
Does RS ask for login credentials when you open Report Manager?
Best Regards,
Radoslaw Lebkowski
Uzytkownik "jobs" <jobs@.webdos.com> napisal w wiadomosci
news:1193850825.364868.47100@.19g2000hsx.googlegroups.com...
> New ssrs istall.
> When I attempt to open report manager, i just get
> SQL Server Reporting Services
> Home
> with no option for creating a folder etc, like i have on development
> When I attempt to deploy to ther server I get :
> Deploying to http://amsqlclusterxx/reportserver/
> Error rsItemAlreadyExists : The item '/Retailer' already exists.
> How do I create an ssrs reports folder?
> Also, and this is strange, but in vs.net I had to create a new shared
> datasource after removing the old one on the report with the same
> name. The report renders fine when I do an f5 pointing to a new
> datasource, but I no longer have the RUN "!" icon available while in
> the data tag to run my query. Why is this?
> Thanks for any help or information.
>
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
How do I create an ssrs reports folder?
Also, and this is strange, but in vs.net I had to create a new shared
datasource after removing the old one on the report with the same
name. The report renders fine when I do an f5 pointing to a new
datasource, but I no longer have the RUN "!" icon available while in
the data tag to run my query. Why is this?
Thanks for any help or information.Hello,
I suppose that user which you use to connect to Report Manager has
insufficient permissions.
Check if this situation takes place also if you use user account which is a
member of the server's Administrators group (BUILTIN\Administrators).
Or maybe you have in IIS configured anonymouse access to Report Manager
Site.
Does RS ask for login credentials when you open Report Manager?
Best Regards,
Radoslaw Lebkowski
Uzytkownik "jobs" <jobs@.webdos.com> napisal w wiadomosci
news:1193850825.364868.47100@.19g2000hsx.googlegroups.com...
> New ssrs istall.
> When I attempt to open report manager, i just get
> SQL Server Reporting Services
> Home
> with no option for creating a folder etc, like i have on development
> When I attempt to deploy to ther server I get :
> Deploying to http://amsqlclusterxx/reportserver/
> Error rsItemAlreadyExists : The item '/Retailer' already exists.
> How do I create an ssrs reports folder?
> Also, and this is strange, but in vs.net I had to create a new shared
> datasource after removing the old one on the report with the same
> name. The report renders fine when I do an f5 pointing to a new
> datasource, but I no longer have the RUN "!" icon available while in
> the data tag to run my query. Why is this?
> Thanks for any help or information.
>
Sunday, March 11, 2012
Creating RS Folders
We are setting up a Reporting Server and are categorizing our reports by
departments and applications within the departments. I have a long list of
these categorizations which are in the follwing format:
Dept1 App1 Rept1
Dept1 App2 Rept1
Dept2 App1 Rept1
Dept2 App3 Rept1
Dept3 App2 Rept1
...
My two questions are:
1) What is the fastest way for me to create all the folders to reflect the
categorizations as listed above (can this be done faster than just doing it
manually)
2) Once the folder structures have been set up. Can I somehow save this or
script it out for future server builds?Look into using rs.exe to create the folders. You can also use any .Net
language to make SOAP calls to create the folder structure, creating an .exe
that will create them on any RS machine you want.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:32995ABD-3B01-4F4B-8854-6B0108ADC401@.microsoft.com...
> We are setting up a Reporting Server and are categorizing our reports by
> departments and applications within the departments. I have a long list of
> these categorizations which are in the follwing format:
> Dept1 App1 Rept1
> Dept1 App2 Rept1
> Dept2 App1 Rept1
> Dept2 App3 Rept1
> Dept3 App2 Rept1
> ...
> My two questions are:
> 1) What is the fastest way for me to create all the folders to reflect the
> categorizations as listed above (can this be done faster than just doing
> it
> manually)
> 2) Once the folder structures have been set up. Can I somehow save this or
> script it out for future server builds?|||Daniel,
In using the SOAP calls, with forms authentication set up, it appears we'll
need to make sure the forms auth cookie gets through. (I can't get rs.exe
to work, and I presume it's because that cookie isn't there.)
From what I've heard, this means the .NET app we create needs to be a web
service or web app to have visibility into the web security context. Is
that correct?
Thanks,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ONReSH18EHA.3124@.TK2MSFTNGP11.phx.gbl...
> Look into using rs.exe to create the folders. You can also use any .Net
> language to make SOAP calls to create the folder structure, creating an
> .exe that will create them on any RS machine you want.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "DBA72" <DBA72@.discussions.microsoft.com> wrote in message
> news:32995ABD-3B01-4F4B-8854-6B0108ADC401@.microsoft.com...
>> We are setting up a Reporting Server and are categorizing our reports by
>> departments and applications within the departments. I have a long list
>> of
>> these categorizations which are in the follwing format:
>> Dept1 App1 Rept1
>> Dept1 App2 Rept1
>> Dept2 App1 Rept1
>> Dept2 App3 Rept1
>> Dept3 App2 Rept1
>> ...
>> My two questions are:
>> 1) What is the fastest way for me to create all the folders to reflect
>> the
>> categorizations as listed above (can this be done faster than just doing
>> it
>> manually)
>> 2) Once the folder structures have been set up. Can I somehow save this
>> or
>> script it out for future server builds?
>|||Daniel (or any other MSFT person or person with experience) ... Do we need
to create a web service or web app to *script* reporting services *with
forms auth running*?
I appreciate any replies, thanks,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:uJwZkKR9EHA.1300@.TK2MSFTNGP14.phx.gbl...
> Daniel,
> In using the SOAP calls, with forms authentication set up, it appears
> we'll need to make sure the forms auth cookie gets through. (I can't get
> rs.exe to work, and I presume it's because that cookie isn't there.)
> From what I've heard, this means the .NET app we create needs to be a web
> service or web app to have visibility into the web security context. Is
> that correct?
> Thanks,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:ONReSH18EHA.3124@.TK2MSFTNGP11.phx.gbl...
>> Look into using rs.exe to create the folders. You can also use any .Net
>> language to make SOAP calls to create the folder structure, creating an
>> .exe that will create them on any RS machine you want.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "DBA72" <DBA72@.discussions.microsoft.com> wrote in message
>> news:32995ABD-3B01-4F4B-8854-6B0108ADC401@.microsoft.com...
>> We are setting up a Reporting Server and are categorizing our reports by
>> departments and applications within the departments. I have a long list
>> of
>> these categorizations which are in the follwing format:
>> Dept1 App1 Rept1
>> Dept1 App2 Rept1
>> Dept2 App1 Rept1
>> Dept2 App3 Rept1
>> Dept3 App2 Rept1
>> ...
>> My two questions are:
>> 1) What is the fastest way for me to create all the folders to reflect
>> the
>> categorizations as listed above (can this be done faster than just doing
>> it
>> manually)
>> 2) Once the folder structures have been set up. Can I somehow save this
>> or
>> script it out for future server builds?
>>
>
departments and applications within the departments. I have a long list of
these categorizations which are in the follwing format:
Dept1 App1 Rept1
Dept1 App2 Rept1
Dept2 App1 Rept1
Dept2 App3 Rept1
Dept3 App2 Rept1
...
My two questions are:
1) What is the fastest way for me to create all the folders to reflect the
categorizations as listed above (can this be done faster than just doing it
manually)
2) Once the folder structures have been set up. Can I somehow save this or
script it out for future server builds?Look into using rs.exe to create the folders. You can also use any .Net
language to make SOAP calls to create the folder structure, creating an .exe
that will create them on any RS machine you want.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:32995ABD-3B01-4F4B-8854-6B0108ADC401@.microsoft.com...
> We are setting up a Reporting Server and are categorizing our reports by
> departments and applications within the departments. I have a long list of
> these categorizations which are in the follwing format:
> Dept1 App1 Rept1
> Dept1 App2 Rept1
> Dept2 App1 Rept1
> Dept2 App3 Rept1
> Dept3 App2 Rept1
> ...
> My two questions are:
> 1) What is the fastest way for me to create all the folders to reflect the
> categorizations as listed above (can this be done faster than just doing
> it
> manually)
> 2) Once the folder structures have been set up. Can I somehow save this or
> script it out for future server builds?|||Daniel,
In using the SOAP calls, with forms authentication set up, it appears we'll
need to make sure the forms auth cookie gets through. (I can't get rs.exe
to work, and I presume it's because that cookie isn't there.)
From what I've heard, this means the .NET app we create needs to be a web
service or web app to have visibility into the web security context. Is
that correct?
Thanks,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ONReSH18EHA.3124@.TK2MSFTNGP11.phx.gbl...
> Look into using rs.exe to create the folders. You can also use any .Net
> language to make SOAP calls to create the folder structure, creating an
> .exe that will create them on any RS machine you want.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "DBA72" <DBA72@.discussions.microsoft.com> wrote in message
> news:32995ABD-3B01-4F4B-8854-6B0108ADC401@.microsoft.com...
>> We are setting up a Reporting Server and are categorizing our reports by
>> departments and applications within the departments. I have a long list
>> of
>> these categorizations which are in the follwing format:
>> Dept1 App1 Rept1
>> Dept1 App2 Rept1
>> Dept2 App1 Rept1
>> Dept2 App3 Rept1
>> Dept3 App2 Rept1
>> ...
>> My two questions are:
>> 1) What is the fastest way for me to create all the folders to reflect
>> the
>> categorizations as listed above (can this be done faster than just doing
>> it
>> manually)
>> 2) Once the folder structures have been set up. Can I somehow save this
>> or
>> script it out for future server builds?
>|||Daniel (or any other MSFT person or person with experience) ... Do we need
to create a web service or web app to *script* reporting services *with
forms auth running*?
I appreciate any replies, thanks,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:uJwZkKR9EHA.1300@.TK2MSFTNGP14.phx.gbl...
> Daniel,
> In using the SOAP calls, with forms authentication set up, it appears
> we'll need to make sure the forms auth cookie gets through. (I can't get
> rs.exe to work, and I presume it's because that cookie isn't there.)
> From what I've heard, this means the .NET app we create needs to be a web
> service or web app to have visibility into the web security context. Is
> that correct?
> Thanks,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:ONReSH18EHA.3124@.TK2MSFTNGP11.phx.gbl...
>> Look into using rs.exe to create the folders. You can also use any .Net
>> language to make SOAP calls to create the folder structure, creating an
>> .exe that will create them on any RS machine you want.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "DBA72" <DBA72@.discussions.microsoft.com> wrote in message
>> news:32995ABD-3B01-4F4B-8854-6B0108ADC401@.microsoft.com...
>> We are setting up a Reporting Server and are categorizing our reports by
>> departments and applications within the departments. I have a long list
>> of
>> these categorizations which are in the follwing format:
>> Dept1 App1 Rept1
>> Dept1 App2 Rept1
>> Dept2 App1 Rept1
>> Dept2 App3 Rept1
>> Dept3 App2 Rept1
>> ...
>> My two questions are:
>> 1) What is the fastest way for me to create all the folders to reflect
>> the
>> categorizations as listed above (can this be done faster than just doing
>> it
>> manually)
>> 2) Once the folder structures have been set up. Can I somehow save this
>> or
>> script it out for future server builds?
>>
>
Labels:
applications,
categorizing,
creating,
database,
departments,
folders,
microsoft,
mysql,
oracle,
reporting,
reports,
server,
setting,
sql
Sunday, February 19, 2012
Creating folders for calculted measure
How to create folders for calculated measures
On the calculations tab you should see a button named "calculation properties" . when you click this a new window will pop up where you can specify display folders for you calculated measures.
Van Dieu
|||Thanks Van.Creating folders for calculted measure
How to create folders for calculated measures
On the calculations tab you should see a button named "calculation properties" . when you click this a new window will pop up where you can specify display folders for you calculated measures.
Van Dieu
|||Thanks Van.
Subscribe to:
Posts (Atom)