Installed SP1, still finding not possible to hide a parameter. Can someone provide the process please. The parameter is an ID that is send via URL to the report server. I created a Report Parameter for it, then created a queary parameter setting that to the incoming value of the Report Parameter. Help pleaseYou can hide a paremeter after you have deployed your report.
But hiding a parameter disallow you to pass any value to this parameter
through the URL!!!
The parameter is not simply hide to the user, is also completly inaccessible
to the user through any URL, but just available to the administrator to
change the default value of the parameter.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> Installed SP1, still finding not possible to hide a parameter. Can someone
provide the process please. The parameter is an ID that is send via URL to
the report server. I created a Report Parameter for it, then created a
queary parameter setting that to the incoming value of the Report Parameter.
Help please|||According to another post by Brian Welcker,
"This is onlt supported on the server. In Report Manager, leave the 'prompt
user' checkbox checked but clear our the prompt string. This should not
prompt the user but still allow you to specify them via URL."
with SP1, you should be able to specify in URL
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||From the SP1 Read Me:
4.3.1 Hiding Parameters in a Published Report
In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
Hide the parameter fields in a published report.
Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
Previously, the only way to hide a parameter value was to clear the Prompt User check box in the Parameters properties page. However, a side effect of clearing the check box was that you could no longer specify a parameter value for the report at run time. This limitation has been removed. In SP1, you can clear the Prompt User check box to hide the parameter fields and values in the report. Doing so does not introduce restrictions on how you subsequently set the parameter value externally at run time.
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||mmmm...
I'll test this.
maybe this doesn't works for me because I have a default value.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A3AD4330-FF88-46BD-97B8-58AB215F4507@.microsoft.com...
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that
allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription
that is used to trigger report execution and delivery).
> Previously, the only way to hide a parameter value was to clear the Prompt
User check box in the Parameters properties page. However, a side effect of
clearing the check box was that you could no longer specify a parameter
value for the report at run time. This limitation has been removed. In SP1,
you can clear the Prompt User check box to hide the parameter fields and
values in the report. Doing so does not introduce restrictions on how you
subsequently set the parameter value externally at run time.
>
> "Jéjé" wrote:
> > You can hide a paremeter after you have deployed your report.
> > But hiding a parameter disallow you to pass any value to this parameter
> > through the URL!!!
> > The parameter is not simply hide to the user, is also completly
inaccessible
> > to the user through any URL, but just available to the administrator to
> > change the default value of the parameter.
> >
> >
> > "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> > news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > > Installed SP1, still finding not possible to hide a parameter. Can
someone
> > provide the process please. The parameter is an ID that is send via URL
to
> > the report server. I created a Report Parameter for it, then created a
> > queary parameter setting that to the incoming value of the Report
Parameter.
> > Help please
> >
> >
> >|||Ok..
Now i have to create a subscription with specific parameters for this subscription and then i should uncheck Promt User checkbox?
Is that right?
The result report i'll use the parameter without problems?
"Eddie" wrote:
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
> Previously, the only way to hide a parameter value was to clear the Prompt User check box in the Parameters properties page. However, a side effect of clearing the check box was that you could no longer specify a parameter value for the report at run time. This limitation has been removed. In SP1, you can clear the Prompt User check box to hide the parameter fields and values in the report. Doing so does not introduce restrictions on how you subsequently set the parameter value externally at run time.
Showing posts with label via. Show all posts
Showing posts with label via. Show all posts
Friday, March 30, 2012
Hide parameter toolbar and send par via querystring?
Hide parameter toolbar and send par via querystring?
I have some stored proceures that receive some parameters and output some
querys. I dont want the user to select parameters because I need to gice
those parameters via query string from My Applications
How can I achieve tha?
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
http://spaces.msn.com/members/extremed/Luis,
Check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp
Adrian M.
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:%23n13jSW$EHA.1400@.TK2MSFTNGP11.phx.gbl...
> Hide parameter toolbar and send par via querystring?
>
> I have some stored proceures that receive some parameters and output some
> querys. I dont want the user to select parameters because I need to gice
> those parameters via query string from My Applications
>
> How can I achieve tha?
>
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 3.
> MIEMBRO ACTIVO DE ALIANZADEV
> http://spaces.msn.com/members/extremed/
>
I have some stored proceures that receive some parameters and output some
querys. I dont want the user to select parameters because I need to gice
those parameters via query string from My Applications
How can I achieve tha?
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
http://spaces.msn.com/members/extremed/Luis,
Check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp
Adrian M.
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:%23n13jSW$EHA.1400@.TK2MSFTNGP11.phx.gbl...
> Hide parameter toolbar and send par via querystring?
>
> I have some stored proceures that receive some parameters and output some
> querys. I dont want the user to select parameters because I need to gice
> those parameters via query string from My Applications
>
> How can I achieve tha?
>
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 3.
> MIEMBRO ACTIVO DE ALIANZADEV
> http://spaces.msn.com/members/extremed/
>
Wednesday, March 28, 2012
Hide browser menu in viewer
I am calling the report server via http to view the SQL 2005 reports. Is
there a way to hide the browser bar at the top that has the browser printer
icon on it so people do not click the wrong icon to print? Thanks.
DavidYou need some browser client side code (javaScript) to open a new browser
window. In this javascript code, you can specify is you want browser's
menu/toolbar/scrollbar shown or not. You can also specify the window's size,
location on screen. This all client side code. No server side code can do
this.
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:%237uBSpUWIHA.2268@.TK2MSFTNGP02.phx.gbl...
>I am calling the report server via http to view the SQL 2005 reports. Is
>there a way to hide the browser bar at the top that has the browser printer
>icon on it so people do not click the wrong icon to print? Thanks.
> David
>
there a way to hide the browser bar at the top that has the browser printer
icon on it so people do not click the wrong icon to print? Thanks.
DavidYou need some browser client side code (javaScript) to open a new browser
window. In this javascript code, you can specify is you want browser's
menu/toolbar/scrollbar shown or not. You can also specify the window's size,
location on screen. This all client side code. No server side code can do
this.
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:%237uBSpUWIHA.2268@.TK2MSFTNGP02.phx.gbl...
>I am calling the report server via http to view the SQL 2005 reports. Is
>there a way to hide the browser bar at the top that has the browser printer
>icon on it so people do not click the wrong icon to print? Thanks.
> David
>
Hide Breadcrumbs
My users access SQL reports via weblinks from a Sharepoint portal. Even
though they don't have backward access through the folders, they can still
hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
Thanks for the help
JDJD,
It sounds like you are copying the URL out of Internet Explorer and
making it the source of web part in SharePoint. There are actually
SharePoint web parts that have been provided by Microsoft for this. For
more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
If you want to keep using URLs, you can use the ReportViewer control to
open the report instead of opening a Report Manager URL. The Report
Viewer control does not show the report WITHIN Report Manager, so there
are no breadcrumbs.
With:
server name = goodwin
Report Server virtual directory = reportserver
report path = Production/Reports/
report name = Report1
The URL would look like this:
http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
To modify toolbar options, you can use some ReportViewer parameters.
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Hope this helps!
-Josh
JDArsenault wrote:
> My users access SQL reports via weblinks from a Sharepoint portal. Even
> though they don't have backward access through the folders, they can still
> hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> Thanks for the help
> JD|||Josh,
Just what the doctor ordered!
Thanks
JD
"Josh" wrote:
> JD,
> It sounds like you are copying the URL out of Internet Explorer and
> making it the source of web part in SharePoint. There are actually
> SharePoint web parts that have been provided by Microsoft for this. For
> more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
> If you want to keep using URLs, you can use the ReportViewer control to
> open the report instead of opening a Report Manager URL. The Report
> Viewer control does not show the report WITHIN Report Manager, so there
> are no breadcrumbs.
> With:
> server name = goodwin
> Report Server virtual directory = reportserver
> report path = Production/Reports/
> report name = Report1
> The URL would look like this:
> http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
> To modify toolbar options, you can use some ReportViewer parameters.
> http://msdn2.microsoft.com/en-us/library/ms152835.aspx
> Hope this helps!
> -Josh
>
> JDArsenault wrote:
> > My users access SQL reports via weblinks from a Sharepoint portal. Even
> > though they don't have backward access through the folders, they can still
> > hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> >
> > Thanks for the help
> >
> > JD
>
though they don't have backward access through the folders, they can still
hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
Thanks for the help
JDJD,
It sounds like you are copying the URL out of Internet Explorer and
making it the source of web part in SharePoint. There are actually
SharePoint web parts that have been provided by Microsoft for this. For
more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
If you want to keep using URLs, you can use the ReportViewer control to
open the report instead of opening a Report Manager URL. The Report
Viewer control does not show the report WITHIN Report Manager, so there
are no breadcrumbs.
With:
server name = goodwin
Report Server virtual directory = reportserver
report path = Production/Reports/
report name = Report1
The URL would look like this:
http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
To modify toolbar options, you can use some ReportViewer parameters.
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Hope this helps!
-Josh
JDArsenault wrote:
> My users access SQL reports via weblinks from a Sharepoint portal. Even
> though they don't have backward access through the folders, they can still
> hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> Thanks for the help
> JD|||Josh,
Just what the doctor ordered!
Thanks
JD
"Josh" wrote:
> JD,
> It sounds like you are copying the URL out of Internet Explorer and
> making it the source of web part in SharePoint. There are actually
> SharePoint web parts that have been provided by Microsoft for this. For
> more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
> If you want to keep using URLs, you can use the ReportViewer control to
> open the report instead of opening a Report Manager URL. The Report
> Viewer control does not show the report WITHIN Report Manager, so there
> are no breadcrumbs.
> With:
> server name = goodwin
> Report Server virtual directory = reportserver
> report path = Production/Reports/
> report name = Report1
> The URL would look like this:
> http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
> To modify toolbar options, you can use some ReportViewer parameters.
> http://msdn2.microsoft.com/en-us/library/ms152835.aspx
> Hope this helps!
> -Josh
>
> JDArsenault wrote:
> > My users access SQL reports via weblinks from a Sharepoint portal. Even
> > though they don't have backward access through the folders, they can still
> > hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> >
> > Thanks for the help
> >
> > JD
>
Wednesday, March 21, 2012
Hi Availability over WAN advice
Hi Team,
Not sure of the best solution. I have two SQL servers in different parts of
the country connected via a 3mb VPN WAN. Both are used for the same front end
application but use different databases.
I want each server to be able to take over the others database in the event
of a disaster at one site. The two sites are on different domains but I plan
to merge the two into one and have a standby computer in each location with
the site specific apps.
I have two domain controllers and two TS servers at my disposal for
reconfiguration.
Any ideas on the best way to go?
Thanks
Andrew
I would use bi-directional transactional replication or merge replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andrew Jurgens" <AndrewJurgens@.discussions.microsoft.com> wrote in message
news:C626429E-6082-454D-8BC0-970A1B51179C@.microsoft.com...
> Hi Team,
> Not sure of the best solution. I have two SQL servers in different parts
of
> the country connected via a 3mb VPN WAN. Both are used for the same front
end
> application but use different databases.
> I want each server to be able to take over the others database in the
event
> of a disaster at one site. The two sites are on different domains but I
plan
> to merge the two into one and have a standby computer in each location
with
> the site specific apps.
> I have two domain controllers and two TS servers at my disposal for
> reconfiguration.
> Any ideas on the best way to go?
> Thanks
> Andrew
>
sql
Not sure of the best solution. I have two SQL servers in different parts of
the country connected via a 3mb VPN WAN. Both are used for the same front end
application but use different databases.
I want each server to be able to take over the others database in the event
of a disaster at one site. The two sites are on different domains but I plan
to merge the two into one and have a standby computer in each location with
the site specific apps.
I have two domain controllers and two TS servers at my disposal for
reconfiguration.
Any ideas on the best way to go?
Thanks
Andrew
I would use bi-directional transactional replication or merge replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andrew Jurgens" <AndrewJurgens@.discussions.microsoft.com> wrote in message
news:C626429E-6082-454D-8BC0-970A1B51179C@.microsoft.com...
> Hi Team,
> Not sure of the best solution. I have two SQL servers in different parts
of
> the country connected via a 3mb VPN WAN. Both are used for the same front
end
> application but use different databases.
> I want each server to be able to take over the others database in the
event
> of a disaster at one site. The two sites are on different domains but I
plan
> to merge the two into one and have a standby computer in each location
with
> the site specific apps.
> I have two domain controllers and two TS servers at my disposal for
> reconfiguration.
> Any ideas on the best way to go?
> Thanks
> Andrew
>
sql
Monday, March 12, 2012
heterogeneous replication
how can i make a replication between SQl Server 2000 and Oracle 9i
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
sure can. Follow the advise you see in this link.
http://www.nwsu.com/lowres_Replication_Ch02.pdf
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Saul Ernesto Martinez Gutierrez" <quetin81@.yahoo.com.mx> wrote in message
news:uJjNrmKvEHA.2200@.TK2MSFTNGP11.phx.gbl...
>
> how can i make a replication between SQl Server 2000 and Oracle 9i
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
sure can. Follow the advise you see in this link.
http://www.nwsu.com/lowres_Replication_Ch02.pdf
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Saul Ernesto Martinez Gutierrez" <quetin81@.yahoo.com.mx> wrote in message
news:uJjNrmKvEHA.2200@.TK2MSFTNGP11.phx.gbl...
>
> how can i make a replication between SQl Server 2000 and Oracle 9i
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
Sunday, February 19, 2012
HELP: ASP.NET won''t connect to SQLexpress after deploying to IIS, try a lot of things...
Hello,
I have finish building my ASP.NET site using VS 2005 and it compile just fine. Than I try hosting it to the web via IIS v5.1 and I am getting permission error from SQL express.
I have posted a detail question in experts-exchange.com and since you need a user account to even view the thread, I have taken the liberty to save the thread as .html file and host it to my ISP site. You can see the detail problem I am having here: http://users.accesscomm.ca/mm/EEdetail.html
I am going to list out some stuff I have done:
1. I have two database that need access, the ASPNETDB.mdf for user login and another database (PhotoDataBase.mdf) to store information relating to the photo I uploaded to my ASP.NET site.
2. I have already follow this How to site: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx and setup:
- TCP/IP enable, as shown here:
- I have started SQL Browser service
- The firewall part I am not so sure about. I am currently using Zonealarm....
3. I have installed SQL Server Management Studio Express(SSMSE) and attach the two database to it.
4. I have set SSMSE server properties to accept both SQL and window authentication.
5. I have made sure that both database "read only" setting to false
6. I have setup SQL login with User ID = SQLLOGIN
Here is the original connection in web.config:
<add name="ConnectionString"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|Da
and here is the new connection I just type in web.config that replace the original one: and the error i get are the follow: Server Error in '/' Application. 7. I did haven't done much to ASPNETDB.mdf yet and the error i get right now are the following: _ Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Please help! I am really running out of ideas.... and I need to have this setup in a few days.... Thanks! These two links will take you in the right direction but you still have the ASPNETDB as a User Instance database which is not supported in other editions of SQL Server so you need to correct that also. In Asp.net deployment takes careful planning or any part of the application can stop the deployment. Hope this helps. http://geekswithblogs.net/ranganh/archive/2005/04/25/37613.aspx http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx These two links will take you in the right direction but you still have the ASPNETDB as a User Instance database which is not supported in other editions of SQL Server so you need to correct that also. In Asp.net deployment takes careful planning or any part of the application can stop the deployment. Hope this helps. http://geekswithblogs.net/ranganh/archive/2005/04/25/37613.aspx http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx Thanks! This is the answer I needed! I am glad I could help.
providerName="System.Data.SqlClient" />
<add name="ConnectionString"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|Da
providerName="System.Data.SqlClient" />
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Server Error in '/' Application.
Cannot open user default database. Login failed.
Login failed for user 'MINGDESKTOP\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Login failed for user 'MINGDESKTOP\ASPNET'.
_
Subscribe to:
Posts (Atom)