I have many reports in a project and I want to set some of the properties in
one place and have all of the reports read from it. Properties like page
size, margins, font size, etc.
Is that possible?Create a standard template and copy it at ProjectItems\ReportProject search
for this directory default should be where your projects are stored. Once you
copy any one creating a report will select the template. So we can maintain a
standard.
Amarnath
"David" wrote:
> I have many reports in a project and I want to set some of the properties in
> one place and have all of the reports read from it. Properties like page
> size, margins, font size, etc.
> Is that possible?
>|||You can store these values in a table you reference via a dataset and then
use an expression to set the format values from the fields in the dataset.
Using parameters for the reportname and the user, you could allow users to
personalize individual reports.
"David" wrote:
> I have many reports in a project and I want to set some of the properties in
> one place and have all of the reports read from it. Properties like page
> size, margins, font size, etc.
> Is that possible?
>sql
Showing posts with label project. Show all posts
Showing posts with label project. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
Projects in SQL Management Studio
I love the template explorer in SQL Management Studio 2005. However, why can't we save these files to a project we've started in Management Studio. I hope in the future that we will be able to change the folder names of projects in Management Studio, and that we will be able to drag template items from the template explorer to our project in the Solution Explorer window.
SQL Project team, can you please add this in the future?
Ron, thanks for your suggestion. I will forward on your comments to my team.
http://connect.microsoft.com is a customer portal where our users can file bugs, vote on their importance, and track their progress throughout our project's lifecycles. You'll be able to connect to the exact member of the team who owns any particular area of SQL Server. Would you mind submitting this idea there and posting a link back to the forum?
Thanks!
Paul A. Mestemaker II
Program Manager
SQL Server
http://blogs.msdn.com/sqlrem/
I have posted this suggestiong and a few other project-related suggestions in a post on connect.microsoft.com. Here's the link:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=151213
Project Type - Business Intelligence
I have sql server 2005 beta 2 and Visual Studio .Net 2003 installed.
I do not have the project type "Business Intelligence" in Visual Studio.
I have tried everything I could think of.
it is supposed to be there correct?On Sat, 30 Oct 2004 09:33:01 -0700, "Bryan Farrell"
<BryanFarrell@.discussions.microsoft.com> wrote:
>I have sql server 2005 beta 2 and Visual Studio .Net 2003 installed.
>I do not have the project type "Business Intelligence" in Visual Studio.
>I have tried everything I could think of.
>it is supposed to be there correct?
Bryan,
Do you have the beta 2 of SQL Server 2005 or of SQL Server 2005
Express?
If you have Express then the Business Intelligence Development Studio
is not included.
If you have the beta 2 of SQL Server 2005 then you should be able to
find the Business Intelligence Development Studio in the SQL Server
2005 folder under All Programs.
Andrew Watt
MVP - InfoPath|||i have beta 2 of SQL Server 2005.
i have the Business Intelligence Development Studio.
but what i am looking for is Visual Studio .Net 2003 - then New Project -
then Business Intelligence. thats what i do no have. the Business
Intelligence project type.
thx.
"Andrew Watt [MVP - InfoPath]" wrote:
> On Sat, 30 Oct 2004 09:33:01 -0700, "Bryan Farrell"
> <BryanFarrell@.discussions.microsoft.com> wrote:
> >I have sql server 2005 beta 2 and Visual Studio .Net 2003 installed.
> >I do not have the project type "Business Intelligence" in Visual Studio.
> >I have tried everything I could think of.
> >
> >it is supposed to be there correct?
> Bryan,
> Do you have the beta 2 of SQL Server 2005 or of SQL Server 2005
> Express?
> If you have Express then the Business Intelligence Development Studio
> is not included.
> If you have the beta 2 of SQL Server 2005 then you should be able to
> find the Business Intelligence Development Studio in the SQL Server
> 2005 folder under All Programs.
> Andrew Watt
> MVP - InfoPath
>
I do not have the project type "Business Intelligence" in Visual Studio.
I have tried everything I could think of.
it is supposed to be there correct?On Sat, 30 Oct 2004 09:33:01 -0700, "Bryan Farrell"
<BryanFarrell@.discussions.microsoft.com> wrote:
>I have sql server 2005 beta 2 and Visual Studio .Net 2003 installed.
>I do not have the project type "Business Intelligence" in Visual Studio.
>I have tried everything I could think of.
>it is supposed to be there correct?
Bryan,
Do you have the beta 2 of SQL Server 2005 or of SQL Server 2005
Express?
If you have Express then the Business Intelligence Development Studio
is not included.
If you have the beta 2 of SQL Server 2005 then you should be able to
find the Business Intelligence Development Studio in the SQL Server
2005 folder under All Programs.
Andrew Watt
MVP - InfoPath|||i have beta 2 of SQL Server 2005.
i have the Business Intelligence Development Studio.
but what i am looking for is Visual Studio .Net 2003 - then New Project -
then Business Intelligence. thats what i do no have. the Business
Intelligence project type.
thx.
"Andrew Watt [MVP - InfoPath]" wrote:
> On Sat, 30 Oct 2004 09:33:01 -0700, "Bryan Farrell"
> <BryanFarrell@.discussions.microsoft.com> wrote:
> >I have sql server 2005 beta 2 and Visual Studio .Net 2003 installed.
> >I do not have the project type "Business Intelligence" in Visual Studio.
> >I have tried everything I could think of.
> >
> >it is supposed to be there correct?
> Bryan,
> Do you have the beta 2 of SQL Server 2005 or of SQL Server 2005
> Express?
> If you have Express then the Business Intelligence Development Studio
> is not included.
> If you have the beta 2 of SQL Server 2005 then you should be able to
> find the Business Intelligence Development Studio in the SQL Server
> 2005 folder under All Programs.
> Andrew Watt
> MVP - InfoPath
>
Project structure when using RepSvcs
Hi,
I have a WinForm project in VS .NET and need to incorporate Reporting
Services.
The application will display the reports to the users on a form with an IE
control.
Is it possible to add the report items to the application project? or
Must I create a separate project of type report and have the reports there?
How could the reports be invoked by the application?
Thanks in advance,
RichardIf you are using IE control you have only one choice. One, the reports need
to be in their own project. Two, they have to be deployed to a server in
order to test your links.
As far as invoking the reports, it confuses me. You stated that you are
using the IE control. The only way to use this control is doing URL
integration. All you are doing is assembling a string and setting the URL
property for the control.
I guess in a convoluted way you could use web services, stream the html to a
file and give the IE control a
If you are using VS.Net 2005 then look at the new controls. There is a
winform and webform controls. The new winform control is a much better way
of integrating reports (I am using it in a Winform application. I use IE
control in a In-Touch application... real time control user interface).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
> Hi,
> I have a WinForm project in VS .NET and need to incorporate Reporting
> Services.
> The application will display the reports to the users on a form with an IE
> control.
> Is it possible to add the report items to the application project? or
> Must I create a separate project of type report and have the reports
> there?
> How could the reports be invoked by the application?
> Thanks in advance,
> Richard|||Sorry Bruce, I meant a ReportViewer control on a WinForm.
"Bruce L-C [MVP]" wrote:
> If you are using IE control you have only one choice. One, the reports need
> to be in their own project. Two, they have to be deployed to a server in
> order to test your links.
> As far as invoking the reports, it confuses me. You stated that you are
> using the IE control. The only way to use this control is doing URL
> integration. All you are doing is assembling a string and setting the URL
> property for the control.
> I guess in a convoluted way you could use web services, stream the html to a
> file and give the IE control a
> If you are using VS.Net 2005 then look at the new controls. There is a
> winform and webform controls. The new winform control is a much better way
> of integrating reports (I am using it in a Winform application. I use IE
> control in a In-Touch application... real time control user interface).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
> > Hi,
> >
> > I have a WinForm project in VS .NET and need to incorporate Reporting
> > Services.
> > The application will display the reports to the users on a form with an IE
> > control.
> > Is it possible to add the report items to the application project? or
> > Must I create a separate project of type report and have the reports
> > there?
> > How could the reports be invoked by the application?
> >
> > Thanks in advance,
> >
> > Richard
>
>|||Ahhh, HUGE difference. There are two ways to use the Winform control: server
and local mode.
Server mode, develop your reports in a reports project, separately. Test out
your report there, deploy and then integrate with Winform control (which is
what I do).
Local mode. Develop report initially in a reports project. Test out report.
Copy rdl file, renaming it to rdlc. Bring the rdlc into your winform
project. Note that you do have much more to do to get full functionality of
a report in local mode. It is nowhere near as simple as integrating in a
report which is deployed to a server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:5820FB57-5FC6-4742-A571-1531CC73E4E0@.microsoft.com...
> Sorry Bruce, I meant a ReportViewer control on a WinForm.
> "Bruce L-C [MVP]" wrote:
>> If you are using IE control you have only one choice. One, the reports
>> need
>> to be in their own project. Two, they have to be deployed to a server in
>> order to test your links.
>> As far as invoking the reports, it confuses me. You stated that you are
>> using the IE control. The only way to use this control is doing URL
>> integration. All you are doing is assembling a string and setting the URL
>> property for the control.
>> I guess in a convoluted way you could use web services, stream the html
>> to a
>> file and give the IE control a
>> If you are using VS.Net 2005 then look at the new controls. There is a
>> winform and webform controls. The new winform control is a much better
>> way
>> of integrating reports (I am using it in a Winform application. I use IE
>> control in a In-Touch application... real time control user interface).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
>> > Hi,
>> >
>> > I have a WinForm project in VS .NET and need to incorporate Reporting
>> > Services.
>> > The application will display the reports to the users on a form with an
>> > IE
>> > control.
>> > Is it possible to add the report items to the application project? or
>> > Must I create a separate project of type report and have the reports
>> > there?
>> > How could the reports be invoked by the application?
>> >
>> > Thanks in advance,
>> >
>> > Richard
>>
I have a WinForm project in VS .NET and need to incorporate Reporting
Services.
The application will display the reports to the users on a form with an IE
control.
Is it possible to add the report items to the application project? or
Must I create a separate project of type report and have the reports there?
How could the reports be invoked by the application?
Thanks in advance,
RichardIf you are using IE control you have only one choice. One, the reports need
to be in their own project. Two, they have to be deployed to a server in
order to test your links.
As far as invoking the reports, it confuses me. You stated that you are
using the IE control. The only way to use this control is doing URL
integration. All you are doing is assembling a string and setting the URL
property for the control.
I guess in a convoluted way you could use web services, stream the html to a
file and give the IE control a
If you are using VS.Net 2005 then look at the new controls. There is a
winform and webform controls. The new winform control is a much better way
of integrating reports (I am using it in a Winform application. I use IE
control in a In-Touch application... real time control user interface).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
> Hi,
> I have a WinForm project in VS .NET and need to incorporate Reporting
> Services.
> The application will display the reports to the users on a form with an IE
> control.
> Is it possible to add the report items to the application project? or
> Must I create a separate project of type report and have the reports
> there?
> How could the reports be invoked by the application?
> Thanks in advance,
> Richard|||Sorry Bruce, I meant a ReportViewer control on a WinForm.
"Bruce L-C [MVP]" wrote:
> If you are using IE control you have only one choice. One, the reports need
> to be in their own project. Two, they have to be deployed to a server in
> order to test your links.
> As far as invoking the reports, it confuses me. You stated that you are
> using the IE control. The only way to use this control is doing URL
> integration. All you are doing is assembling a string and setting the URL
> property for the control.
> I guess in a convoluted way you could use web services, stream the html to a
> file and give the IE control a
> If you are using VS.Net 2005 then look at the new controls. There is a
> winform and webform controls. The new winform control is a much better way
> of integrating reports (I am using it in a Winform application. I use IE
> control in a In-Touch application... real time control user interface).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
> > Hi,
> >
> > I have a WinForm project in VS .NET and need to incorporate Reporting
> > Services.
> > The application will display the reports to the users on a form with an IE
> > control.
> > Is it possible to add the report items to the application project? or
> > Must I create a separate project of type report and have the reports
> > there?
> > How could the reports be invoked by the application?
> >
> > Thanks in advance,
> >
> > Richard
>
>|||Ahhh, HUGE difference. There are two ways to use the Winform control: server
and local mode.
Server mode, develop your reports in a reports project, separately. Test out
your report there, deploy and then integrate with Winform control (which is
what I do).
Local mode. Develop report initially in a reports project. Test out report.
Copy rdl file, renaming it to rdlc. Bring the rdlc into your winform
project. Note that you do have much more to do to get full functionality of
a report in local mode. It is nowhere near as simple as integrating in a
report which is deployed to a server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:5820FB57-5FC6-4742-A571-1531CC73E4E0@.microsoft.com...
> Sorry Bruce, I meant a ReportViewer control on a WinForm.
> "Bruce L-C [MVP]" wrote:
>> If you are using IE control you have only one choice. One, the reports
>> need
>> to be in their own project. Two, they have to be deployed to a server in
>> order to test your links.
>> As far as invoking the reports, it confuses me. You stated that you are
>> using the IE control. The only way to use this control is doing URL
>> integration. All you are doing is assembling a string and setting the URL
>> property for the control.
>> I guess in a convoluted way you could use web services, stream the html
>> to a
>> file and give the IE control a
>> If you are using VS.Net 2005 then look at the new controls. There is a
>> winform and webform controls. The new winform control is a much better
>> way
>> of integrating reports (I am using it in a Winform application. I use IE
>> control in a In-Touch application... real time control user interface).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
>> > Hi,
>> >
>> > I have a WinForm project in VS .NET and need to incorporate Reporting
>> > Services.
>> > The application will display the reports to the users on a form with an
>> > IE
>> > control.
>> > Is it possible to add the report items to the application project? or
>> > Must I create a separate project of type report and have the reports
>> > there?
>> > How could the reports be invoked by the application?
>> >
>> > Thanks in advance,
>> >
>> > Richard
>>
Project Server DB
Hi all,
I have a problem here, i want to update the DraftDB in Project Server from an exteral DB (which is not within the Project Server architecture). How can go about doing this?
-the exteral DB would have similiar Tables with the DraftDB such as having a Table call Sponsor
-if i add a new record, edit a record, or delete a record on Table Sponsor on the exteral DB, the update would reflect to the DraftDB in Project Server?
Is there any PSI calls that capable of achieving this? Any ideas? (If you couldn't help, would you have any suggestions of who/where i should turn to?)
Thanks a lot
Michael
This seems like a job for SQL Server Agent. You should be able to do your cross-db queries and inserts through the agent.
http://technet.microsoft.com/en-us/library/ms187061.aspx
Hope this helps,
John
|||Hi,i don't really get it.
Thanks
Michael
Project Server 2003 Setup Error 25624
Has anyone seen this one before?
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that creates
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillB
Yes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:
>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have that
>working on a SQL 2005 server without error from a query analyzer that creates
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB
|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Ben
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that creates
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillB
Yes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:
>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have that
>working on a SQL 2005 server without error from a query analyzer that creates
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB
|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Ben
Project Server 2003 Setup Error 25624
Has anyone seen this one before?
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that creates
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillBYes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:
>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have that
>working on a SQL 2005 server without error from a query analyzer that creates
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Bensql
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that creates
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillBYes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:
>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have that
>working on a SQL 2005 server without error from a query analyzer that creates
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Bensql
Project Server 2003 Setup Error 25624
Has anyone seen this one before?
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that create
s
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillBYes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:
>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have tha
t
>working on a SQL 2005 server without error from a query analyzer that creat
es
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Ben
I am using the db admin account and have all the rights necessary but it
keeps failing during setup. I have also located the WEBSPS.SQL and have that
working on a SQL 2005 server without error from a query analyzer that create
s
the necessary functions... sprocs.. etc... Just does not want to go in from
the setup program and rolls back. Anyone have any ideas?
Thanks,
BillBYes...that's a common error installing project server when
the permissions aren't set correctly with SQL Server.
-Sue
On Sun, 9 Oct 2005 17:33:04 -0700, "billb"
<billb@.discussions.microsoft.com> wrote:
>Has anyone seen this one before?
>I am using the db admin account and have all the rights necessary but it
>keeps failing during setup. I have also located the WEBSPS.SQL and have tha
t
>working on a SQL 2005 server without error from a query analyzer that creat
es
>the necessary functions... sprocs.. etc... Just does not want to go in from
>the setup program and rolls back. Anyone have any ideas?
>Thanks,
>BillB|||Hi Sue,
Thanks for your response. What are the proper permissions for SQL
Server?
Thanks,
--Ben
Project Server
Hi All,
I have got project server 2003 installed at both
forest DC and child DC, what if i want to replicate both
the datbases with each other. And which type of
replication most importantly
You can replicate the databases. As far as which method of replication,
that depends upon a lot of business needs factors. Every single replication
method will work from a technical standpoint. Not all of them will meet
your business needs.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
I have got project server 2003 installed at both
forest DC and child DC, what if i want to replicate both
the datbases with each other. And which type of
replication most importantly
You can replicate the databases. As far as which method of replication,
that depends upon a lot of business needs factors. Every single replication
method will work from a technical standpoint. Not all of them will meet
your business needs.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
project server
I installed SP4 of SQL SERVER 2000 and even so I don't get to install
project server. Somebody knows how I can solve that.. the error message says
that
I have to install the sp3 or superior of the sql server 2000.Based on your comments, I am not sure where you are getting stuck.
You need to install SQL first w/SP3a or SP4.
Then create users as per project server install guide
Then setup sharepoint, including creating a Top Level Site
Then setup Project Server
Then install the Project Server SQL hotfix - see project server website,
then Project Server SP2.
Hope this helps.
project server. Somebody knows how I can solve that.. the error message says
that
I have to install the sp3 or superior of the sql server 2000.Based on your comments, I am not sure where you are getting stuck.
You need to install SQL first w/SP3a or SP4.
Then create users as per project server install guide
Then setup sharepoint, including creating a Top Level Site
Then setup Project Server
Then install the Project Server SQL hotfix - see project server website,
then Project Server SP2.
Hope this helps.
Tuesday, March 20, 2012
Project question.
Project question.
Hi, I'm developing a DB that is as follow:
This DB is for control the Credit Cards information. Then it has a lot of
movement.
1-I have a client.
2-This client has an account
3-This account can has a many cards ( for exemple: credit card
international, credit card gold.) each one whit your rules (like: limit,
date of pay.)
4- And I have a table that receives all transactions, for example: (very
simplified)
Client '1010 1010 1010 1010' buy product that have cost of $100,00 ,date
05/05/05
Client '1010 1010 1010 1010' buy product that have cost of $50,00 , date
05/20/05
.
Client '2020 2020 2020 2020' buy product that have cost of $80,00 ,date
05/04/05
Client '2020 2020 2020 2020' buy product that have cost of $50,00 , date
05/18/05
.
I need made calculations to generate a bill for each client each month.
My question is: When I have 1 million of client (consequently 5 million of
transaction in this table to month) and I need make calculations, this table
will work. (It won't be locked)
How I should do this.
Anyone have experience with a lot of data. How work with a lot of data that
need be calculate.
Any think is important to me.
Thank you very much.Hello,
You may want to consider use Horizontal partitioning
http://msdn.microsoft.com/library/d...-us/optimsql/od
p_tun_1_11ev.asp
http://www.sqlteam.com/Item.ASP?ItemID=684
Also, general query optimation is necesary for each specific query:
HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
http://support.microsoft.com/?id=243589
http://www.sql-server-performance.com/mr_indexing.asp
INF: Index Tuning Wizard Best Practices
http://support.microsoft.com/?id=311826
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "ReTF" <re.tf@.newsgroup.nospam>
| Subject: Project question.
| Date: Wed, 3 Aug 2005 09:32:57 -0300
| Lines: 74
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <OjmzhbCmFHA.3256@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: 200-211-161-64-amr.cpe.vivax.com.br 200.211.161.64
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.programming:109244
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
| Project question.
|
|
|
| Hi, I'm developing a DB that is as follow:
|
|
|
| This DB is for control the Credit Cards information. Then it has a lot of
| movement.
|
|
|
| 1-I have a client.
|
| 2-This client has an account
|
| 3-This account can has a many cards ( for exemple: credit card
| international, credit card gold.) each one whit your rules (like: limit,
| date of pay.)
|
| 4- And I have a table that receives all transactions, for example: (very
| simplified)
|
|
|
| Client '1010 1010 1010 1010' buy product that have cost of $100,00 ,date
| 05/05/05
|
| Client '1010 1010 1010 1010' buy product that have cost of $50,00 , date
| 05/20/05
|
| .
|
| Client '2020 2020 2020 2020' buy product that have cost of $80,00 ,date
| 05/04/05
|
| Client '2020 2020 2020 2020' buy product that have cost of $50,00 , date
| 05/18/05
|
| .
|
|
|
| I need made calculations to generate a bill for each client each month.
|
|
|
| My question is: When I have 1 million of client (consequently 5 million
of
| transaction in this table to month) and I need make calculations, this
table
| will work. (It won't be locked)
|
|
|
| How I should do this.
|
|
|
| Anyone have experience with a lot of data. How work with a lot of data
that
| need be calculate.
|
|
|
|
|
| Any think is important to me.
|
|
|
| Thank you very much.
|
|
|
|
|
Hi, I'm developing a DB that is as follow:
This DB is for control the Credit Cards information. Then it has a lot of
movement.
1-I have a client.
2-This client has an account
3-This account can has a many cards ( for exemple: credit card
international, credit card gold.) each one whit your rules (like: limit,
date of pay.)
4- And I have a table that receives all transactions, for example: (very
simplified)
Client '1010 1010 1010 1010' buy product that have cost of $100,00 ,date
05/05/05
Client '1010 1010 1010 1010' buy product that have cost of $50,00 , date
05/20/05
.
Client '2020 2020 2020 2020' buy product that have cost of $80,00 ,date
05/04/05
Client '2020 2020 2020 2020' buy product that have cost of $50,00 , date
05/18/05
.
I need made calculations to generate a bill for each client each month.
My question is: When I have 1 million of client (consequently 5 million of
transaction in this table to month) and I need make calculations, this table
will work. (It won't be locked)
How I should do this.
Anyone have experience with a lot of data. How work with a lot of data that
need be calculate.
Any think is important to me.
Thank you very much.Hello,
You may want to consider use Horizontal partitioning
http://msdn.microsoft.com/library/d...-us/optimsql/od
p_tun_1_11ev.asp
http://www.sqlteam.com/Item.ASP?ItemID=684
Also, general query optimation is necesary for each specific query:
HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
http://support.microsoft.com/?id=243589
http://www.sql-server-performance.com/mr_indexing.asp
INF: Index Tuning Wizard Best Practices
http://support.microsoft.com/?id=311826
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "ReTF" <re.tf@.newsgroup.nospam>
| Subject: Project question.
| Date: Wed, 3 Aug 2005 09:32:57 -0300
| Lines: 74
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <OjmzhbCmFHA.3256@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: 200-211-161-64-amr.cpe.vivax.com.br 200.211.161.64
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.programming:109244
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
| Project question.
|
|
|
| Hi, I'm developing a DB that is as follow:
|
|
|
| This DB is for control the Credit Cards information. Then it has a lot of
| movement.
|
|
|
| 1-I have a client.
|
| 2-This client has an account
|
| 3-This account can has a many cards ( for exemple: credit card
| international, credit card gold.) each one whit your rules (like: limit,
| date of pay.)
|
| 4- And I have a table that receives all transactions, for example: (very
| simplified)
|
|
|
| Client '1010 1010 1010 1010' buy product that have cost of $100,00 ,date
| 05/05/05
|
| Client '1010 1010 1010 1010' buy product that have cost of $50,00 , date
| 05/20/05
|
| .
|
| Client '2020 2020 2020 2020' buy product that have cost of $80,00 ,date
| 05/04/05
|
| Client '2020 2020 2020 2020' buy product that have cost of $50,00 , date
| 05/18/05
|
| .
|
|
|
| I need made calculations to generate a bill for each client each month.
|
|
|
| My question is: When I have 1 million of client (consequently 5 million
of
| transaction in this table to month) and I need make calculations, this
table
| will work. (It won't be locked)
|
|
|
| How I should do this.
|
|
|
| Anyone have experience with a lot of data. How work with a lot of data
that
| need be calculate.
|
|
|
|
|
| Any think is important to me.
|
|
|
| Thank you very much.
|
|
|
|
|
Project Planning
Hello
Is this disguise for your real business problem? I mean, project-
planning tools are plentiful on the market, so I don't see why you
would write your own. Or is it a class assignment?
Based on three tables (Projects, Tasks and UserCalender) I would like
to work out the total amount of available resources (UserCalender
table contains a entry for each user for each day, day being 7.5
hours) and total required effort (sum of Tasks.EstimateLikley) split
over 12 months.
For example:
Jan:
Available Resources: (4 Users, 7.5 hours per day, 5 working days per
week, 23 Working days in Jan) = (23 x 4) = (92 * 7.5) = 690 Available
Hours
Required Resources:
Project Start Date: 1/1/2007
Project End Date: 1/6/2007
Total Required effort (Sum of Tasks.Hours for above project): 500
Hours Average over 6 months = 83.33 Hours per month, so in Jan I need
to deduct 83.33 from 600 = 516.67 Hours.
etc
How could I do this, I have tried several ways but finding it hard.
ThanksPP (paul@.bobbob.net) writes:
Quote:
Originally Posted by
Based on three tables (Projects, Tasks and UserCalender) I would like
to work out the total amount of available resources (UserCalender
table contains a entry for each user for each day, day being 7.5
hours) and total required effort (sum of Tasks.EstimateLikley) split
over 12 months.
>
For example:
>
>
Jan:
Available Resources: (4 Users, 7.5 hours per day, 5 working days per
week, 23 Working days in Jan) = (23 x 4) = (92 * 7.5) = 690 Available
Hours
Required Resources:
Project Start Date: 1/1/2007
Project End Date: 1/6/2007
Total Required effort (Sum of Tasks.Hours for above project): 500
Hours Average over 6 months = 83.33 Hours per month, so in Jan I need
to deduct 83.33 from 600 = 516.67 Hours.
>
etc
>
How could I do this, I have tried several ways but finding it hard.
Is this disguise for your real business problem? I mean, project-
planning tools are plentiful on the market, so I don't see why you
would write your own. Or is it a class assignment?
In any case, for this types of questions, it helps if you post:
o CREATE TABLE statements for your tables.
o INSERT statements with sample data.
o The desired result given the sample.
This helps to clarify ambiguities in your post, and it also makes it
easy to copy and past to develop a tested solution.
... although, if it's really a class assignment, you are better to
discuss the problem with your teacher. You are likely to learn more
that way.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Project Plan template for Migration from MS SQL 2000 to MS sql 2005
Hello:
I'm looking for a Project Plan template for Migration from MS SQL 2000 to MS sql 2005.
We apporeciate your help.
regards
William
Hi William,
I am also searching for a migration template project plan. Pl. can you send it to me if you have found one?
Thanks,
GP
geeta_pajjuri@.yahoo.com
|||can you pls send a copy to me too.
Thanks
Narsan
lingala_narsan@.hotmail.com
|||We are also looking for a Project Plan for Migration. Greatly appreciate if someone can share.Regards,
Shastry
|||Hi guys,
If anyone has found this template, please could you send it to me...Many thanks in advance...
Cheers,
/A
alfredo_espejo(At)hotmail.com
Project Plan template for Migration from MS SQL 2000 to MS sql 2005
Hello:
I'm looking for a Project Plan template for Migration from MS SQL 2000 to MS sql 2005.
We apporeciate your help.
regards
William
Hi William,
I am also searching for a migration template project plan. Pl. can you send it to me if you have found one?
Thanks,
GP
geeta_pajjuri@.yahoo.com
|||can you pls send a copy to me too.
Thanks
Narsan
lingala_narsan@.hotmail.com
|||We are also looking for a Project Plan for Migration. Greatly appreciate if someone can share.Regards,
Shastry
|||Hi guys,
If anyone has found this template, please could you send it to me...Many thanks in advance...
Cheers,
/A
alfredo_espejo(At)hotmail.com
Project Plan template for Migration from MS SQL 2000 to MS sql 2005
Hello:
I'm looking for a Project Plan template for Migration from MS SQL 2000 to MS sql 2005.
We apporeciate your help.
regards
William
Hi William,
I am also searching for a migration template project plan. Pl. can you send it to me if you have found one?
Thanks,
GP
geeta_pajjuri@.yahoo.com
|||can you pls send a copy to me too.
Thanks
Narsan
lingala_narsan@.hotmail.com
|||We are also looking for a Project Plan for Migration. Greatly appreciate if someone can share.Regards,
Shastry
|||Hi guys,
If anyone has found this template, please could you send it to me...Many thanks in advance...
Cheers,
/A
alfredo_espejo(At)hotmail.com
|||Did you guys got one? please send me a copy leonson@.hotmail.com
Project opening - XML Document Error (118, 17)
While openeing the solution file (.sln), I got the following error:
"There is an error in XML document (118, 17)."
I am trying to open a project of SQL Server 2000 - Reporting Services.
Don't know what had happened actually.Hi,
Have you edited or changed anything on the rdl file / sln file.?
Amarnath
"Rohit Jain" wrote:
> While openeing the solution file (.sln), I got the following error:
> "There is an error in XML document (118, 17)."
> I am trying to open a project of SQL Server 2000 - Reporting Services.
> Don't know what had happened actually.|||Thanks Amarnath,
Yeah I have found the solution. Actually the error was occurring due to a
change in .rptproj file, and by this change the file itself got corrupted.
Thanks for your response Amarnath.
But stll I have 1 query - where I can found that XML document for which the
error was displayed.
"Amarnath" wrote:
> Hi,
> Have you edited or changed anything on the rdl file / sln file.?
> Amarnath
> "Rohit Jain" wrote:
> > While openeing the solution file (.sln), I got the following error:
> >
> > "There is an error in XML document (118, 17)."
> >
> > I am trying to open a project of SQL Server 2000 - Reporting Services.
> >
> > Don't know what had happened actually.
"There is an error in XML document (118, 17)."
I am trying to open a project of SQL Server 2000 - Reporting Services.
Don't know what had happened actually.Hi,
Have you edited or changed anything on the rdl file / sln file.?
Amarnath
"Rohit Jain" wrote:
> While openeing the solution file (.sln), I got the following error:
> "There is an error in XML document (118, 17)."
> I am trying to open a project of SQL Server 2000 - Reporting Services.
> Don't know what had happened actually.|||Thanks Amarnath,
Yeah I have found the solution. Actually the error was occurring due to a
change in .rptproj file, and by this change the file itself got corrupted.
Thanks for your response Amarnath.
But stll I have 1 query - where I can found that XML document for which the
error was displayed.
"Amarnath" wrote:
> Hi,
> Have you edited or changed anything on the rdl file / sln file.?
> Amarnath
> "Rohit Jain" wrote:
> > While openeing the solution file (.sln), I got the following error:
> >
> > "There is an error in XML document (118, 17)."
> >
> > I am trying to open a project of SQL Server 2000 - Reporting Services.
> >
> > Don't know what had happened actually.
Project in Share Point
Hello,
I have got a project where I am asked to utilize SharePoint features as much as possible. This project is earlier developed in .Net using Sharepoint Object Model. But now .Net should be eliminated as much as possible.
The requirements are :
Display a list of projects for the logged in user (windows logged in user). The list should have search criteria: project name, customer, project manager, project period.
On click of a project in the list, project details should be displayed Details like customer, team, start date, highlights, news. On click of a team member's name, Details of the team member (Name, office location, project joining, releaving dates, photo ) should be displayed.
To do this in Sharepoint my major hurdle is to display project list for windows logged in user. How do I do this in Sharepoint?
Expecting ideas/workarounds from all... Please be kind enough for that.
Thanks !!!!!!!!!!!!!!!!!!
Hi -You'll most likely receive more responses in the Sharepoint forums.
http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=330&SiteID=17
HTH...
Joe|||Thanks a lot for the link Joe.
Project in Share Point
Hello,
I have got a project where I am asked to utilize SharePoint features as much as possible. This project is earlier developed in .Net using Sharepoint Object Model. But now .Net should be eliminated as much as possible.
The requirements are :
Display a list of projects for the logged in user (windows logged in user). The list should have search criteria: project name, customer, project manager, project period.
On click of a project in the list, project details should be displayed Details like customer, team, start date, highlights, news. On click of a team member's name, Details of the team member (Name, office location, project joining, releaving dates, photo ) should be displayed.
To do this in Sharepoint my major hurdle is to display project list for windows logged in user. How do I do this in Sharepoint?
Expecting ideas/workarounds from all... Please be kind enough for that.
Thanks !!!!!!!!!!!!!!!!!!
Hi -You'll most likely receive more responses in the Sharepoint forums.
http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=330&SiteID=17
HTH...
Joe|||Thanks a lot for the link Joe.
Project Hierarchy and Shared Data Sources
Our desires might be misguided, so I would like to hear what some of the more
learned members have to say:
Issue 1:
It appears that Reporting Services supports a folder paradigm that nicely
models how we desire to organize our reports. However, this folder paradigm
is not supported in Visual Studio .NET. In other words, it does not appear
that I can construct a VS.NET solution that contains folders and sub folders
that describe a tree structure.
While the VS.NET solution is â'flatâ' I can however modify the Properties of
each Report Project and set TargetFolder such that as the projects are
deployed they end up in a hierarchy on the report server.
My question is this: Have any of you â'seenâ' this condition and if so, what
have you learned or what have you done about it? Did you perhaps adopt the
same approach as I, accepting the VS .NET solution structure as â'flatâ' and
use the TargetFolder property to achieve the desired hierarchy on the report
server?
Issue 2:
We desire to use a single shared data source for all of our reports. A
shared data source is contained in a given Report Project. There does not
seem to be a way that I can use one projectâ's shared data source in another
projectâ's report. If we consider the hierarchical folder paradigm described
in Issue 1 (above), it seems the only solution is to establish the same
shared data source in each and every Report Project I create.
I suppose alternatively, that I could dispense with attempting to use a
shared data source entirely. Rather, I would just imbed the same data source
into each and every report developed. My thinking here is somewhat an issue
of reuse/maintenance. If I only need one, I donâ't feel I should have to have
more than one instance across the entire Report Server. This may be contrary
to some of the larger scale objectives of Reporting Services, where perhaps
it is desired that different folders access different data using different
credentials and whatnot. At present, we donâ't even name a real DB Server in
the Connection String, but rather a logical name, which is handled via an
Alias that is established on each of our target environments (Dev, QA,
Staging, Beta, Production) such that the deployed reports/data sources will
point to their appropriate DB.
My question here is: Is it possible to use a single shared data source
across many individual report projects without having to physically copy that
shared data source to each project?You are correct on Issue 1. I have just organized my projects for a 1 to 1
relationship with the folders but if you want the folders organized in a
tree you have to do as you mention here. For SQL Server I just put in the
connection but for other data sources (like Sybase) I put in a file dsn.
For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
Bruce Loehle-Conger
MVP SQL Server Reporting Services
For Issue number 2 I do the following. Yes I have to have a shared
datasource created for each folder BUT the actual
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
> Our desires might be misguided, so I would like to hear what some of the
more
> learned members have to say:
> Issue 1:
> It appears that Reporting Services supports a folder paradigm that nicely
> models how we desire to organize our reports. However, this folder
paradigm
> is not supported in Visual Studio .NET. In other words, it does not
appear
> that I can construct a VS.NET solution that contains folders and sub
folders
> that describe a tree structure.
> While the VS.NET solution is 'flat' I can however modify the Properties of
> each Report Project and set TargetFolder such that as the projects are
> deployed they end up in a hierarchy on the report server.
> My question is this: Have any of you 'seen' this condition and if so, what
> have you learned or what have you done about it? Did you perhaps adopt
the
> same approach as I, accepting the VS .NET solution structure as 'flat' and
> use the TargetFolder property to achieve the desired hierarchy on the
report
> server?
> Issue 2:
> We desire to use a single shared data source for all of our reports. A
> shared data source is contained in a given Report Project. There does not
> seem to be a way that I can use one project's shared data source in
another
> project's report. If we consider the hierarchical folder paradigm
described
> in Issue 1 (above), it seems the only solution is to establish the same
> shared data source in each and every Report Project I create.
> I suppose alternatively, that I could dispense with attempting to use a
> shared data source entirely. Rather, I would just imbed the same data
source
> into each and every report developed. My thinking here is somewhat an
issue
> of reuse/maintenance. If I only need one, I don't feel I should have to
have
> more than one instance across the entire Report Server. This may be
contrary
> to some of the larger scale objectives of Reporting Services, where
perhaps
> it is desired that different folders access different data using different
> credentials and whatnot. At present, we don't even name a real DB Server
in
> the Connection String, but rather a logical name, which is handled via an
> Alias that is established on each of our target environments (Dev, QA,
> Staging, Beta, Production) such that the deployed reports/data sources
will
> point to their appropriate DB.
> My question here is: Is it possible to use a single shared data source
> across many individual report projects without having to physically copy
that
> shared data source to each project?
>|||Bruce, did you have a 'finished' reply to my second issue? It seems you got
cut off midstream. I see you said that I would need the datasource to be
present in each folder but...
"Bruce L-C [MVP]" wrote:
> You are correct on Issue 1. I have just organized my projects for a 1 to 1
> relationship with the folders but if you want the folders organized in a
> tree you have to do as you mention here. For SQL Server I just put in the
> connection but for other data sources (like Sybase) I put in a file dsn.
> For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> For Issue number 2 I do the following. Yes I have to have a shared
> datasource created for each folder BUT the actual
> "Herman K" <HermanK@.discussions.microsoft.com> wrote in message
> news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
> > Our desires might be misguided, so I would like to hear what some of the
> more
> > learned members have to say:
> >
> > Issue 1:
> >
> > It appears that Reporting Services supports a folder paradigm that nicely
> > models how we desire to organize our reports. However, this folder
> paradigm
> > is not supported in Visual Studio .NET. In other words, it does not
> appear
> > that I can construct a VS.NET solution that contains folders and sub
> folders
> > that describe a tree structure.
> >
> > While the VS.NET solution is 'flat' I can however modify the Properties of
> > each Report Project and set TargetFolder such that as the projects are
> > deployed they end up in a hierarchy on the report server.
> >
> > My question is this: Have any of you 'seen' this condition and if so, what
> > have you learned or what have you done about it? Did you perhaps adopt
> the
> > same approach as I, accepting the VS .NET solution structure as 'flat' and
> > use the TargetFolder property to achieve the desired hierarchy on the
> report
> > server?
> >
> > Issue 2:
> >
> > We desire to use a single shared data source for all of our reports. A
> > shared data source is contained in a given Report Project. There does not
> > seem to be a way that I can use one project's shared data source in
> another
> > project's report. If we consider the hierarchical folder paradigm
> described
> > in Issue 1 (above), it seems the only solution is to establish the same
> > shared data source in each and every Report Project I create.
> >
> > I suppose alternatively, that I could dispense with attempting to use a
> > shared data source entirely. Rather, I would just imbed the same data
> source
> > into each and every report developed. My thinking here is somewhat an
> issue
> > of reuse/maintenance. If I only need one, I don't feel I should have to
> have
> > more than one instance across the entire Report Server. This may be
> contrary
> > to some of the larger scale objectives of Reporting Services, where
> perhaps
> > it is desired that different folders access different data using different
> > credentials and whatnot. At present, we don't even name a real DB Server
> in
> > the Connection String, but rather a logical name, which is handled via an
> > Alias that is established on each of our target environments (Dev, QA,
> > Staging, Beta, Production) such that the deployed reports/data sources
> will
> > point to their appropriate DB.
> >
> > My question here is: Is it possible to use a single shared data source
> > across many individual report projects without having to physically copy
> that
> > shared data source to each project?
> >
>
>|||To answer your second question, yes you can have the same data source for
mutliple reports in multiple folders, but you need to connect each report to
the data source individually after you publish. You can either do this
manually or write a script. I haven't written a script yet to do this yet,
but someone here might have a code example.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:CAB6F427-B5FD-4711-8CB2-7865E992345C@.microsoft.com...
> Bruce, did you have a 'finished' reply to my second issue? It seems you
> got
> cut off midstream. I see you said that I would need the datasource to be
> present in each folder but...
> "Bruce L-C [MVP]" wrote:
>> You are correct on Issue 1. I have just organized my projects for a 1 to
>> 1
>> relationship with the folders but if you want the folders organized in a
>> tree you have to do as you mention here. For SQL Server I just put in the
>> connection but for other data sources (like Sybase) I put in a file dsn.
>> For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> For Issue number 2 I do the following. Yes I have to have a shared
>> datasource created for each folder BUT the actual
>> "Herman K" <HermanK@.discussions.microsoft.com> wrote in message
>> news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
>> > Our desires might be misguided, so I would like to hear what some of
>> > the
>> more
>> > learned members have to say:
>> >
>> > Issue 1:
>> >
>> > It appears that Reporting Services supports a folder paradigm that
>> > nicely
>> > models how we desire to organize our reports. However, this folder
>> paradigm
>> > is not supported in Visual Studio .NET. In other words, it does not
>> appear
>> > that I can construct a VS.NET solution that contains folders and sub
>> folders
>> > that describe a tree structure.
>> >
>> > While the VS.NET solution is 'flat' I can however modify the Properties
>> > of
>> > each Report Project and set TargetFolder such that as the projects are
>> > deployed they end up in a hierarchy on the report server.
>> >
>> > My question is this: Have any of you 'seen' this condition and if so,
>> > what
>> > have you learned or what have you done about it? Did you perhaps adopt
>> the
>> > same approach as I, accepting the VS .NET solution structure as 'flat'
>> > and
>> > use the TargetFolder property to achieve the desired hierarchy on the
>> report
>> > server?
>> >
>> > Issue 2:
>> >
>> > We desire to use a single shared data source for all of our reports. A
>> > shared data source is contained in a given Report Project. There does
>> > not
>> > seem to be a way that I can use one project's shared data source in
>> another
>> > project's report. If we consider the hierarchical folder paradigm
>> described
>> > in Issue 1 (above), it seems the only solution is to establish the same
>> > shared data source in each and every Report Project I create.
>> >
>> > I suppose alternatively, that I could dispense with attempting to use a
>> > shared data source entirely. Rather, I would just imbed the same data
>> source
>> > into each and every report developed. My thinking here is somewhat an
>> issue
>> > of reuse/maintenance. If I only need one, I don't feel I should have
>> > to
>> have
>> > more than one instance across the entire Report Server. This may be
>> contrary
>> > to some of the larger scale objectives of Reporting Services, where
>> perhaps
>> > it is desired that different folders access different data using
>> > different
>> > credentials and whatnot. At present, we don't even name a real DB
>> > Server
>> in
>> > the Connection String, but rather a logical name, which is handled via
>> > an
>> > Alias that is established on each of our target environments (Dev, QA,
>> > Staging, Beta, Production) such that the deployed reports/data sources
>> will
>> > point to their appropriate DB.
>> >
>> > My question here is: Is it possible to use a single shared data source
>> > across many individual report projects without having to physically
>> > copy
>> that
>> > shared data source to each project?
>> >
>>|||You can certainly share a datasource by using the web API. You can
write a script that will upload a new report to the Report Server and
then tell it to use the datasource that is already there.
Plenty of examples in the doc, but specifically check out
CreateReport (to publish a report)
SetReportDataSources (to then set a datasource for that report)|||Very well (to all) then that is the way I will have to do it. I was kind of
hoping to be able to implement this 'referential' data source at design time
and just have that carry through during deployment, but it looks as if we
will have to hook it up after the fact.
In this case the developer is going to have to utilize 'their' data source,
which would be in a project and if its in the project I might as well let it
flow to the server. However, if I am going to do that, I might as well let
folks just standardize on imbedding the data source in the report itself and
if we should ever need to change it, just do so by parsing the XML in each
and every RDL.
"cmarinella@.gmail.com" wrote:
> You can certainly share a datasource by using the web API. You can
> write a script that will upload a new report to the Report Server and
> then tell it to use the datasource that is already there.
> Plenty of examples in the doc, but specifically check out
> CreateReport (to publish a report)
> SetReportDataSources (to then set a datasource for that report)
>
learned members have to say:
Issue 1:
It appears that Reporting Services supports a folder paradigm that nicely
models how we desire to organize our reports. However, this folder paradigm
is not supported in Visual Studio .NET. In other words, it does not appear
that I can construct a VS.NET solution that contains folders and sub folders
that describe a tree structure.
While the VS.NET solution is â'flatâ' I can however modify the Properties of
each Report Project and set TargetFolder such that as the projects are
deployed they end up in a hierarchy on the report server.
My question is this: Have any of you â'seenâ' this condition and if so, what
have you learned or what have you done about it? Did you perhaps adopt the
same approach as I, accepting the VS .NET solution structure as â'flatâ' and
use the TargetFolder property to achieve the desired hierarchy on the report
server?
Issue 2:
We desire to use a single shared data source for all of our reports. A
shared data source is contained in a given Report Project. There does not
seem to be a way that I can use one projectâ's shared data source in another
projectâ's report. If we consider the hierarchical folder paradigm described
in Issue 1 (above), it seems the only solution is to establish the same
shared data source in each and every Report Project I create.
I suppose alternatively, that I could dispense with attempting to use a
shared data source entirely. Rather, I would just imbed the same data source
into each and every report developed. My thinking here is somewhat an issue
of reuse/maintenance. If I only need one, I donâ't feel I should have to have
more than one instance across the entire Report Server. This may be contrary
to some of the larger scale objectives of Reporting Services, where perhaps
it is desired that different folders access different data using different
credentials and whatnot. At present, we donâ't even name a real DB Server in
the Connection String, but rather a logical name, which is handled via an
Alias that is established on each of our target environments (Dev, QA,
Staging, Beta, Production) such that the deployed reports/data sources will
point to their appropriate DB.
My question here is: Is it possible to use a single shared data source
across many individual report projects without having to physically copy that
shared data source to each project?You are correct on Issue 1. I have just organized my projects for a 1 to 1
relationship with the folders but if you want the folders organized in a
tree you have to do as you mention here. For SQL Server I just put in the
connection but for other data sources (like Sybase) I put in a file dsn.
For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
Bruce Loehle-Conger
MVP SQL Server Reporting Services
For Issue number 2 I do the following. Yes I have to have a shared
datasource created for each folder BUT the actual
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
> Our desires might be misguided, so I would like to hear what some of the
more
> learned members have to say:
> Issue 1:
> It appears that Reporting Services supports a folder paradigm that nicely
> models how we desire to organize our reports. However, this folder
paradigm
> is not supported in Visual Studio .NET. In other words, it does not
appear
> that I can construct a VS.NET solution that contains folders and sub
folders
> that describe a tree structure.
> While the VS.NET solution is 'flat' I can however modify the Properties of
> each Report Project and set TargetFolder such that as the projects are
> deployed they end up in a hierarchy on the report server.
> My question is this: Have any of you 'seen' this condition and if so, what
> have you learned or what have you done about it? Did you perhaps adopt
the
> same approach as I, accepting the VS .NET solution structure as 'flat' and
> use the TargetFolder property to achieve the desired hierarchy on the
report
> server?
> Issue 2:
> We desire to use a single shared data source for all of our reports. A
> shared data source is contained in a given Report Project. There does not
> seem to be a way that I can use one project's shared data source in
another
> project's report. If we consider the hierarchical folder paradigm
described
> in Issue 1 (above), it seems the only solution is to establish the same
> shared data source in each and every Report Project I create.
> I suppose alternatively, that I could dispense with attempting to use a
> shared data source entirely. Rather, I would just imbed the same data
source
> into each and every report developed. My thinking here is somewhat an
issue
> of reuse/maintenance. If I only need one, I don't feel I should have to
have
> more than one instance across the entire Report Server. This may be
contrary
> to some of the larger scale objectives of Reporting Services, where
perhaps
> it is desired that different folders access different data using different
> credentials and whatnot. At present, we don't even name a real DB Server
in
> the Connection String, but rather a logical name, which is handled via an
> Alias that is established on each of our target environments (Dev, QA,
> Staging, Beta, Production) such that the deployed reports/data sources
will
> point to their appropriate DB.
> My question here is: Is it possible to use a single shared data source
> across many individual report projects without having to physically copy
that
> shared data source to each project?
>|||Bruce, did you have a 'finished' reply to my second issue? It seems you got
cut off midstream. I see you said that I would need the datasource to be
present in each folder but...
"Bruce L-C [MVP]" wrote:
> You are correct on Issue 1. I have just organized my projects for a 1 to 1
> relationship with the folders but if you want the folders organized in a
> tree you have to do as you mention here. For SQL Server I just put in the
> connection but for other data sources (like Sybase) I put in a file dsn.
> For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> For Issue number 2 I do the following. Yes I have to have a shared
> datasource created for each folder BUT the actual
> "Herman K" <HermanK@.discussions.microsoft.com> wrote in message
> news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
> > Our desires might be misguided, so I would like to hear what some of the
> more
> > learned members have to say:
> >
> > Issue 1:
> >
> > It appears that Reporting Services supports a folder paradigm that nicely
> > models how we desire to organize our reports. However, this folder
> paradigm
> > is not supported in Visual Studio .NET. In other words, it does not
> appear
> > that I can construct a VS.NET solution that contains folders and sub
> folders
> > that describe a tree structure.
> >
> > While the VS.NET solution is 'flat' I can however modify the Properties of
> > each Report Project and set TargetFolder such that as the projects are
> > deployed they end up in a hierarchy on the report server.
> >
> > My question is this: Have any of you 'seen' this condition and if so, what
> > have you learned or what have you done about it? Did you perhaps adopt
> the
> > same approach as I, accepting the VS .NET solution structure as 'flat' and
> > use the TargetFolder property to achieve the desired hierarchy on the
> report
> > server?
> >
> > Issue 2:
> >
> > We desire to use a single shared data source for all of our reports. A
> > shared data source is contained in a given Report Project. There does not
> > seem to be a way that I can use one project's shared data source in
> another
> > project's report. If we consider the hierarchical folder paradigm
> described
> > in Issue 1 (above), it seems the only solution is to establish the same
> > shared data source in each and every Report Project I create.
> >
> > I suppose alternatively, that I could dispense with attempting to use a
> > shared data source entirely. Rather, I would just imbed the same data
> source
> > into each and every report developed. My thinking here is somewhat an
> issue
> > of reuse/maintenance. If I only need one, I don't feel I should have to
> have
> > more than one instance across the entire Report Server. This may be
> contrary
> > to some of the larger scale objectives of Reporting Services, where
> perhaps
> > it is desired that different folders access different data using different
> > credentials and whatnot. At present, we don't even name a real DB Server
> in
> > the Connection String, but rather a logical name, which is handled via an
> > Alias that is established on each of our target environments (Dev, QA,
> > Staging, Beta, Production) such that the deployed reports/data sources
> will
> > point to their appropriate DB.
> >
> > My question here is: Is it possible to use a single shared data source
> > across many individual report projects without having to physically copy
> that
> > shared data source to each project?
> >
>
>|||To answer your second question, yes you can have the same data source for
mutliple reports in multiple folders, but you need to connect each report to
the data source individually after you publish. You can either do this
manually or write a script. I haven't written a script yet to do this yet,
but someone here might have a code example.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:CAB6F427-B5FD-4711-8CB2-7865E992345C@.microsoft.com...
> Bruce, did you have a 'finished' reply to my second issue? It seems you
> got
> cut off midstream. I see you said that I would need the datasource to be
> present in each folder but...
> "Bruce L-C [MVP]" wrote:
>> You are correct on Issue 1. I have just organized my projects for a 1 to
>> 1
>> relationship with the folders but if you want the folders organized in a
>> tree you have to do as you mention here. For SQL Server I just put in the
>> connection but for other data sources (like Sybase) I put in a file dsn.
>> For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> For Issue number 2 I do the following. Yes I have to have a shared
>> datasource created for each folder BUT the actual
>> "Herman K" <HermanK@.discussions.microsoft.com> wrote in message
>> news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
>> > Our desires might be misguided, so I would like to hear what some of
>> > the
>> more
>> > learned members have to say:
>> >
>> > Issue 1:
>> >
>> > It appears that Reporting Services supports a folder paradigm that
>> > nicely
>> > models how we desire to organize our reports. However, this folder
>> paradigm
>> > is not supported in Visual Studio .NET. In other words, it does not
>> appear
>> > that I can construct a VS.NET solution that contains folders and sub
>> folders
>> > that describe a tree structure.
>> >
>> > While the VS.NET solution is 'flat' I can however modify the Properties
>> > of
>> > each Report Project and set TargetFolder such that as the projects are
>> > deployed they end up in a hierarchy on the report server.
>> >
>> > My question is this: Have any of you 'seen' this condition and if so,
>> > what
>> > have you learned or what have you done about it? Did you perhaps adopt
>> the
>> > same approach as I, accepting the VS .NET solution structure as 'flat'
>> > and
>> > use the TargetFolder property to achieve the desired hierarchy on the
>> report
>> > server?
>> >
>> > Issue 2:
>> >
>> > We desire to use a single shared data source for all of our reports. A
>> > shared data source is contained in a given Report Project. There does
>> > not
>> > seem to be a way that I can use one project's shared data source in
>> another
>> > project's report. If we consider the hierarchical folder paradigm
>> described
>> > in Issue 1 (above), it seems the only solution is to establish the same
>> > shared data source in each and every Report Project I create.
>> >
>> > I suppose alternatively, that I could dispense with attempting to use a
>> > shared data source entirely. Rather, I would just imbed the same data
>> source
>> > into each and every report developed. My thinking here is somewhat an
>> issue
>> > of reuse/maintenance. If I only need one, I don't feel I should have
>> > to
>> have
>> > more than one instance across the entire Report Server. This may be
>> contrary
>> > to some of the larger scale objectives of Reporting Services, where
>> perhaps
>> > it is desired that different folders access different data using
>> > different
>> > credentials and whatnot. At present, we don't even name a real DB
>> > Server
>> in
>> > the Connection String, but rather a logical name, which is handled via
>> > an
>> > Alias that is established on each of our target environments (Dev, QA,
>> > Staging, Beta, Production) such that the deployed reports/data sources
>> will
>> > point to their appropriate DB.
>> >
>> > My question here is: Is it possible to use a single shared data source
>> > across many individual report projects without having to physically
>> > copy
>> that
>> > shared data source to each project?
>> >
>>|||You can certainly share a datasource by using the web API. You can
write a script that will upload a new report to the Report Server and
then tell it to use the datasource that is already there.
Plenty of examples in the doc, but specifically check out
CreateReport (to publish a report)
SetReportDataSources (to then set a datasource for that report)|||Very well (to all) then that is the way I will have to do it. I was kind of
hoping to be able to implement this 'referential' data source at design time
and just have that carry through during deployment, but it looks as if we
will have to hook it up after the fact.
In this case the developer is going to have to utilize 'their' data source,
which would be in a project and if its in the project I might as well let it
flow to the server. However, if I am going to do that, I might as well let
folks just standardize on imbedding the data source in the report itself and
if we should ever need to change it, just do so by parsing the XML in each
and every RDL.
"cmarinella@.gmail.com" wrote:
> You can certainly share a datasource by using the web API. You can
> write a script that will upload a new report to the Report Server and
> then tell it to use the datasource that is already there.
> Plenty of examples in the doc, but specifically check out
> CreateReport (to publish a report)
> SetReportDataSources (to then set a datasource for that report)
>
project deployment issues
Im having some issues when deploying my project written in vb.net which
uses and Sql server database. During development I used my local
machine as the server database, and this worked fine for myself and
other users on remote pcs.
But now I have changed the sql connection string to point to a
dedicated sql server for deployment of the completed project I am the
only user who can access it. I have another administrator with access
to the same database and he can view/edit all the tables in sql server
Enterprise Manager, but when he runs my program it generates an error
on the first attempt the program makes to retreive data from the
database.
It is a basic select statement which works fine for me, but generates a
"cannot find <table_name>" type of error. We are both using exactly the
same version of the project, so I know the table exists.
I thought it must be some kind of permission i need to set in the
database, but he seems to think because he can see it in enterprise
manager it must be in my code.Hi
Does "administrator" have a full access to the server ? Is he a memeber of
sy
min server role?
Who is an owner of the table?
How do you perform a SELECT statement?
SELECT <> FROM dbo.TableName
SELECT <> FROM fred.Tablename ( fred is an user and owner of the table)
<nathan.atkins@.alcoa.com.au> wrote in message
news:1139196815.500065.315700@.o13g2000cwo.googlegroups.com...
> Im having some issues when deploying my project written in vb.net which
> uses and Sql server database. During development I used my local
> machine as the server database, and this worked fine for myself and
> other users on remote pcs.
> But now I have changed the sql connection string to point to a
> dedicated sql server for deployment of the completed project I am the
> only user who can access it. I have another administrator with access
> to the same database and he can view/edit all the tables in sql server
> Enterprise Manager, but when he runs my program it generates an error
> on the first attempt the program makes to retreive data from the
> database.
> It is a basic select statement which works fine for me, but generates a
> "cannot find <table_name>" type of error. We are both using exactly the
> same version of the project, so I know the table exists.
> I thought it must be some kind of permission i need to set in the
> database, but he seems to think because he can see it in enterprise
> manager it must be in my code.
>|||
> Does "administrator" have a full access to the server ? Is he a memeber of
> symin server role? - Yes
> Who is an owner of the table? - Me
> How do you perform a SELECT statement?
>
> SELECT <> FROM dbo.TableName
> SELECT <> FROM fred.Tablename ( fred is an user and owner of the table)
Currently im saying "SELECT <> FROM tablename
After reading your post im starting to think this is the problem, but
how to fix i dont know.|||Nathan --
Look in Enterprise Manager under "tables" on the database. Who is the
owner of the table you want to access? Is it "dbo" or is it you? Try
"select * from dbo.<table_name>" or "select * from
[DOMAIN\yourlogin].<table_name>. Does the latter one work? If so, you
are probably going to want to recreate your tables with "dbo" as the
owner, instead of yourself:
CREATE TABLE dbo.NewTable (...)
vs
CREATE TABLE NewTable
My best guess--
-Dave Markle
nathan.atkins@.alcoa.com.au wrote:
> Im having some issues when deploying my project written in vb.net which
> uses and Sql server database. During development I used my local
> machine as the server database, and this worked fine for myself and
> other users on remote pcs.
> But now I have changed the sql connection string to point to a
> dedicated sql server for deployment of the completed project I am the
> only user who can access it. I have another administrator with access
> to the same database and he can view/edit all the tables in sql server
> Enterprise Manager, but when he runs my program it generates an error
> on the first attempt the program makes to retreive data from the
> database.
> It is a basic select statement which works fine for me, but generates a
> "cannot find <table_name>" type of error. We are both using exactly the
> same version of the project, so I know the table exists.
> I thought it must be some kind of permission i need to set in the
> database, but he seems to think because he can see it in enterprise
> manager it must be in my code.
>
uses and Sql server database. During development I used my local
machine as the server database, and this worked fine for myself and
other users on remote pcs.
But now I have changed the sql connection string to point to a
dedicated sql server for deployment of the completed project I am the
only user who can access it. I have another administrator with access
to the same database and he can view/edit all the tables in sql server
Enterprise Manager, but when he runs my program it generates an error
on the first attempt the program makes to retreive data from the
database.
It is a basic select statement which works fine for me, but generates a
"cannot find <table_name>" type of error. We are both using exactly the
same version of the project, so I know the table exists.
I thought it must be some kind of permission i need to set in the
database, but he seems to think because he can see it in enterprise
manager it must be in my code.Hi
Does "administrator" have a full access to the server ? Is he a memeber of
sy
min server role?Who is an owner of the table?
How do you perform a SELECT statement?
SELECT <> FROM dbo.TableName
SELECT <> FROM fred.Tablename ( fred is an user and owner of the table)
<nathan.atkins@.alcoa.com.au> wrote in message
news:1139196815.500065.315700@.o13g2000cwo.googlegroups.com...
> Im having some issues when deploying my project written in vb.net which
> uses and Sql server database. During development I used my local
> machine as the server database, and this worked fine for myself and
> other users on remote pcs.
> But now I have changed the sql connection string to point to a
> dedicated sql server for deployment of the completed project I am the
> only user who can access it. I have another administrator with access
> to the same database and he can view/edit all the tables in sql server
> Enterprise Manager, but when he runs my program it generates an error
> on the first attempt the program makes to retreive data from the
> database.
> It is a basic select statement which works fine for me, but generates a
> "cannot find <table_name>" type of error. We are both using exactly the
> same version of the project, so I know the table exists.
> I thought it must be some kind of permission i need to set in the
> database, but he seems to think because he can see it in enterprise
> manager it must be in my code.
>|||
> Does "administrator" have a full access to the server ? Is he a memeber of
> sy
min server role? - Yes> Who is an owner of the table? - Me
> How do you perform a SELECT statement?
>
> SELECT <> FROM dbo.TableName
> SELECT <> FROM fred.Tablename ( fred is an user and owner of the table)
Currently im saying "SELECT <> FROM tablename
After reading your post im starting to think this is the problem, but
how to fix i dont know.|||Nathan --
Look in Enterprise Manager under "tables" on the database. Who is the
owner of the table you want to access? Is it "dbo" or is it you? Try
"select * from dbo.<table_name>" or "select * from
[DOMAIN\yourlogin].<table_name>. Does the latter one work? If so, you
are probably going to want to recreate your tables with "dbo" as the
owner, instead of yourself:
CREATE TABLE dbo.NewTable (...)
vs
CREATE TABLE NewTable
My best guess--
-Dave Markle
nathan.atkins@.alcoa.com.au wrote:
> Im having some issues when deploying my project written in vb.net which
> uses and Sql server database. During development I used my local
> machine as the server database, and this worked fine for myself and
> other users on remote pcs.
> But now I have changed the sql connection string to point to a
> dedicated sql server for deployment of the completed project I am the
> only user who can access it. I have another administrator with access
> to the same database and he can view/edit all the tables in sql server
> Enterprise Manager, but when he runs my program it generates an error
> on the first attempt the program makes to retreive data from the
> database.
> It is a basic select statement which works fine for me, but generates a
> "cannot find <table_name>" type of error. We are both using exactly the
> same version of the project, so I know the table exists.
> I thought it must be some kind of permission i need to set in the
> database, but he seems to think because he can see it in enterprise
> manager it must be in my code.
>
Subscribe to:
Posts (Atom)