Hi Alberto,
We are currently facing your same issue. Did you get some solution to limit the rowcount on reportbuilder models? Thanks in advance for any ideas.
|||Hi Cato, unluckly it seems that there isn't a good solution. Keep an eye on security filters on report models,this is the only thing that seems to "filter" data.
HTH.
Alberto
We want to limit the number of rows that can be extracted from the sql server db using report builder. In the report model reference seems that there is not this kind of option (something like "max rowcount"). Is it possible to set this limit to the user that connects to sql server (something like: whatever is the query this user does, set @.@.rowcount to 10000)?
Thanks.
Alberto.
Hi Alberto,
We are currently facing your same issue. Did you get some solution to limit the rowcount on reportbuilder models? Thanks in advance for any ideas.
|||Hi Cato, unluckly it seems that there isn't a good solution. Keep an eye on security filters on report models,this is the only thing that seems to "filter" data.
HTH.
Alberto
In the Winform designer, right click on the Toolbox and select 'Choose Items...' menu item. Hit the Brows button and select file 'Microsoft.AnalysisServices.Viewers.dll'. Hit the OK button to add all the viewer controls to your toolbox.
2) Are these controls installed with VS 2005 or SQL 2005 and these are just the redistributable versions for systems where VS 2005 and SQL 2005 are not installed?
The view controls are shipped with SQL 2005 as well as in its separate redistributable available for download.
3) Is there a description of the controls and what each one does?
You can find description of each individual viewer control in SQL Books online.
Hi,
I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.
I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)
There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.
Has anyone does this for SSMSE? Or am I going about this in the wrong way?
Thanks in advance,
Keith
Hi Keith,
You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.
One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.
Mike
|||Thanks Mike! I am deploying it with SQL Express as well.
Take care,
Keith
Hi,
I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.
I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)
There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.
Has anyone does this for SSMSE? Or am I going about this in the wrong way?
Thanks in advance,
Keith
Hi Keith,
You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.
One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.
Mike
|||Thanks Mike! I am deploying it with SQL Express as well.
Take care,
Keith
Hi,
I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.
I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)
There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.
Has anyone does this for SSMSE? Or am I going about this in the wrong way?
Thanks in advance,
Keith
Hi Keith,
You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.
One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.
Mike
|||Thanks Mike! I am deploying it with SQL Express as well.
Take care,
Keith
Hi All,
How can I add sql server express sp1 or sp2 into a setup project I created for an application. Normally sqlserver express is a prerequisite for my app and in deployment vs only adds sqlexpress not the sqlexpress with sp1 or sp2. I know that I need those to make my application run on vista. Any suggestion?
Thanks
The prerequisites in VS are driven by a set of manifests installed with VS that only target SQL Express RTM. Microsoft has not released updates to these prerequisites, but you can build your own prerequisite for SQL Express SP2 by following the directions in the SQL Express blog. Check out the instructions here.
Mike
|||After a long wait I knew that you will reply. I haven't tried your instructions yet but I am sure this is the answer. Thanks for the reply.Hi All,
How can I add sql server express sp1 or sp2 into a setup project I created for an application. Normally sqlserver express is a prerequisite for my app and in deployment vs only adds sqlexpress not the sqlexpress with sp1 or sp2. I know that I need those to make my application run on vista. Any suggestion?
Thanks
The prerequisites in VS are driven by a set of manifests installed with VS that only target SQL Express RTM. Microsoft has not released updates to these prerequisites, but you can build your own prerequisite for SQL Express SP2 by following the directions in the SQL Express blog. Check out the instructions here.
Mike
|||After a long wait I knew that you will reply. I haven't tried your instructions yet but I am sure this is the answer. Thanks for the reply.When ever I hit the CTRL+N to add a new query and then save it, why doesn't it get added to the current project I'm working on? Since it's not added, I have to open Windows Explorer, navigate to the right folder, then drag'n'drop it into the right project in my solution. A lot of work for something it should be doing by default.
What am I missing? Thanks.
This does not appear possible with SQL Server 2005 SP2. Could you file this on Microsoft Connect? http://connect.microsoft.com/SQLServer/Feedback/
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
|||Done, id 275345.When ever I hit the CTRL+N to add a new query and then save it, why doesn't it get added to the current project I'm working on? Since it's not added, I have to open Windows Explorer, navigate to the right folder, then drag'n'drop it into the right project in my solution. A lot of work for something it should be doing by default.
What am I missing? Thanks.
This does not appear possible with SQL Server 2005 SP2. Could you file this on Microsoft Connect? http://connect.microsoft.com/SQLServer/Feedback/
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
|||Done, id 275345.I'm in the final stage of my asp.net project and one of the last things I need to do is add the following file information to my SQL server 2000 database when a file is uploaded:
First of all I have a resource table to which I need to add:
- filename
- file_path
- file_size
(the resource_id has a auto increment value)
so that should hopefully be straight forward when the file is uploaded. The next step is to reference the new resource_id in my module_resource table. My module resource table consists of:
- resource_id (foreign key)
- module_id (foreign key)
So, adding the module_id is easy enough as I can just get the value using Request.QueryString["module_id"]. The bit that I am unsure about is how to insert the new resource_id from the resource table into the module_resource table on file upload. How is this done? Using one table would solve the issue but I want one resource to be available to all modules - many to many relationship.
Any ideas?
Many thanks :)Since Resource_ID is an Identity column, you should be able to perform a SCOPE_IDENTITY() after the INSERT into the Resource table to pick up the value.
For example:
DECLARE @.resourceID bigintINSERT INTO
Resource
(
filename,
file_path,
file_size
)
VALUES
(
@.filename,
@.file_path,
@.file_size
)
SELECT @.resource_ID = SCOPE_IDENTITY()INSERT INTO
Module_Resource
(
module_ID,
resource_ID
)
VALUES
(
@.module_ID,
@.resource_ID
)
Terri
After installing SQL Server (both 2005 and 2008) sometimes the BI Templates are missing from the new project dialog. Is there a way to find those templates and add them after a SQL Server install? I have searched the web and Microsoft MSDN, but found no information. Thank you if you can help me.
Hi,
From your description, do you mean the Business Intelligence project template disappear in the create project dialogue?
Based on my understanding, you can try to open "SQL Server Business Intelligence Development Studio" from SQLServer 2005 menu group instead of starting Visual Studio designer. If you still can't find the business intelligence project template. Please make sure that if you have choose the "SQLServer Reporting Service" to be installed while you installing the SQLServer2005.
Thanks.
No, the problem is that they do not appear in VS/BIDS even if SSRS is installed. The templates must be available on the web somewhere and the correct folder location and configuration to add them to the VS/BIDS interface must exist somewhere.
Hi there,
My company has a centralised user profile repository that all new applications worldwide use for authorization and user details; we access it from the various apps via a web service.
What I'd like to do in a report is to pass a user's ID to the web service and return their name and contact details to display in the header. I imagine I'd need to do this in a custom function and I can see where I can add a reference to use in this function but not where to add a web reference. Is this possible?
Regards,
Uzum4k1i.
One possible solution to the issue is to add custom code to the report: custom code (e.g., a C# library project in which a web reference could be added) calls the web service and exposes the web service call result for the report to reference. the assembly containing custom code needs to be deployed on the report server. More details are available here:
http://msdn2.microsoft.com/en-us/library/ms252130.aspx
Another possible option is to configure the web service as an XML data source in which the web service URL is the connection string. Details here:
http://msdn2.microsoft.com/en-us/library/ms159741.aspx
http://msdn2.microsoft.com/en-us/library/ms345338.aspx
|||Cheers Tau Liang, both of those answers sound like they'll fit the bill nicelyHi there,
My company has a centralised user profile repository that all new applications worldwide use for authorization and user details; we access it from the various apps via a web service.
What I'd like to do in a report is to pass a user's ID to the web service and return their name and contact details to display in the header. I imagine I'd need to do this in a custom function and I can see where I can add a reference to use in this function but not where to add a web reference. Is this possible?
Regards,
Uzum4k1i.
One possible solution to the issue is to add custom code to the report: custom code (e.g., a C# library project in which a web reference could be added) calls the web service and exposes the web service call result for the report to reference. the assembly containing custom code needs to be deployed on the report server. More details are available here:
http://msdn2.microsoft.com/en-us/library/ms252130.aspx
Another possible option is to configure the web service as an XML data source in which the web service URL is the connection string. Details here:
http://msdn2.microsoft.com/en-us/library/ms159741.aspx
http://msdn2.microsoft.com/en-us/library/ms345338.aspx
|||Cheers Tau Liang, both of those answers sound like they'll fit the bill nicely