Showing posts with label business. Show all posts
Showing posts with label business. Show all posts

Friday, March 23, 2012

report model template is missing

I want to create a new report model project, however in VS Business intelligence Development Studio, I could find the report model template in the New project dialog box. Anyone coulf tell me how can I add the templeate? Thanks

Do you have any other business intelligence projects installed like report server project?

Try this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1479717&SiteID=1

Report Model Template

HI,

When I create a new Business Intelligence Projects, I can not find the "Report Model Project" template. I am not sure If I failed to install a few components ( client components). If this is the problem, how can I add these templates?

Thanks,

RR

I'm having the same problem. I've chosen to install all components and yet no Report Model Project Template. Is there somewhere we could download this template. I don't know if this makes a difference, but I have a licensed copy of Visual Studio 2005 on my computer. Thanks in advance for your advice.|||

Ok. I've figured out what was wrong here.

The Report Model template appears to be related to integration services and is not included in the Express Edition.

I had installed Visual Studio, but not the SQL Server developer tools.

Later, I installed the express version when starting to work on SQL Server Reports.

After removing the Express Edition and then installing the SQL Server developer tools from the Visual Studio disks, the Report Model project is listed as an available option.

Report Model Template

HI,

When I create a new Business Intelligence Projects, I can not find the "Report Model Project" template. I am not sure If I failed to install a few components ( client components). If this is the problem, how can I add these templates?

Thanks,

RR

I'm having the same problem. I've chosen to install all components and yet no Report Model Project Template. Is there somewhere we could download this template. I don't know if this makes a difference, but I have a licensed copy of Visual Studio 2005 on my computer. Thanks in advance for your advice.|||

Ok. I've figured out what was wrong here.

The Report Model template appears to be related to integration services and is not included in the Express Edition.

I had installed Visual Studio, but not the SQL Server developer tools.

Later, I installed the express version when starting to work on SQL Server Reports.

After removing the Express Edition and then installing the SQL Server developer tools from the Visual Studio disks, the Report Model project is listed as an available option.

Saturday, February 25, 2012

report in SQL 2005 problem

Hi,
I am using the Business Intelligence Development studio to create a
simple report in SQL 2005 server. I have created a dataset and tried to
connect to a database and it failed to connect. An error is given out and
said that it cannot connect to the database because the server does not
allow remote connection and error 40. Can anyone tell me how to enable
"allow remote connection" in a database or how to solve this problem?
Thanks.
Use the "SQL Server Surface Area Configuration" tool.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I am using the Business Intelligence Development studio to create a
> simple report in SQL 2005 server. I have created a dataset and tried to
> connect to a database and it failed to connect. An error is given out and
> said that it cannot connect to the database because the server does not
> allow remote connection and error 40. Can anyone tell me how to enable
> "allow remote connection" in a database or how to solve this problem?
> Thanks.
>
|||Hi,
I tried to select "Local and remote connection" - "TCP/IP" and
"TCP/IP and named pipe" option and run again. But still got the same error.
Can anyone please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ue7WsZV6GHA.3452@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Use the "SQL Server Surface Area Configuration" tool.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00KobeBrian" <a@.b.com> wrote in message
> news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...
|||Sorry Folks. I got it. I just didn't point to the correct server. Cheers
"00KobeBrian" <a@.b.com> wrote in message
news:uhhxA8z6GHA.4644@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I tried to select "Local and remote connection" - "TCP/IP" and
> "TCP/IP and named pipe" option and run again. But still got the same
> error. Can anyone please help? Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:ue7WsZV6GHA.3452@.TK2MSFTNGP05.phx.gbl...
>

report in SQL 2005 problem

Hi,
I am using the Business Intelligence Development studio to create a
simple report in SQL 2005 server. I have created a dataset and tried to
connect to a database and it failed to connect. An error is given out and
said that it cannot connect to the database because the server does not
allow remote connection and error 40. Can anyone tell me how to enable
"allow remote connection" in a database or how to solve this problem?
Thanks.Use the "SQL Server Surface Area Configuration" tool.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I am using the Business Intelligence Development studio to create a
> simple report in SQL 2005 server. I have created a dataset and tried to
> connect to a database and it failed to connect. An error is given out and
> said that it cannot connect to the database because the server does not
> allow remote connection and error 40. Can anyone tell me how to enable
> "allow remote connection" in a database or how to solve this problem?
> Thanks.
>|||Hi,
I tried to select "Local and remote connection" - "TCP/IP" and
"TCP/IP and named pipe" option and run again. But still got the same error.
Can anyone please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ue7WsZV6GHA.3452@.TK2MSFTNGP05.phx.gbl...
> Use the "SQL Server Surface Area Configuration" tool.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00KobeBrian" <a@.b.com> wrote in message
> news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I am using the Business Intelligence Development studio to create
>> a simple report in SQL 2005 server. I have created a dataset and tried to
>> connect to a database and it failed to connect. An error is given out and
>> said that it cannot connect to the database because the server does not
>> allow remote connection and error 40. Can anyone tell me how to enable
>> "allow remote connection" in a database or how to solve this problem?
>> Thanks.|||Sorry Folks. I got it. I just didn't point to the correct server. Cheers
"00KobeBrian" <a@.b.com> wrote in message
news:uhhxA8z6GHA.4644@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I tried to select "Local and remote connection" - "TCP/IP" and
> "TCP/IP and named pipe" option and run again. But still got the same
> error. Can anyone please help? Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:ue7WsZV6GHA.3452@.TK2MSFTNGP05.phx.gbl...
>> Use the "SQL Server Surface Area Configuration" tool.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "00KobeBrian" <a@.b.com> wrote in message
>> news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I am using the Business Intelligence Development studio to
>> create a simple report in SQL 2005 server. I have created a dataset and
>> tried to connect to a database and it failed to connect. An error is
>> given out and said that it cannot connect to the database because the
>> server does not allow remote connection and error 40. Can anyone tell me
>> how to enable "allow remote connection" in a database or how to solve
>> this problem? Thanks.
>

report in SQL 2005 problem

Hi,
I am using the Business Intelligence Development studio to create a
simple report in SQL 2005 server. I have created a dataset and tried to
connect to a database and it failed to connect. An error is given out and
said that it cannot connect to the database because the server does not
allow remote connection and error 40. Can anyone tell me how to enable
"allow remote connection" in a database or how to solve this problem?
Thanks.Use the "SQL Server Surface Area Configuration" tool.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...[vbc
ol=seagreen]
> Hi,
> I am using the Business Intelligence Development studio to create
a
> simple report in SQL 2005 server. I have created a dataset and tried to
> connect to a database and it failed to connect. An error is given out and
> said that it cannot connect to the database because the server does not
> allow remote connection and error 40. Can anyone tell me how to enable
> "allow remote connection" in a database or how to solve this problem?
> Thanks.
>[/vbcol]|||Hi,
I tried to select "Local and remote connection" - "TCP/IP" and
"TCP/IP and named pipe" option and run again. But still got the same error.
Can anyone please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ue7WsZV6GHA.3452@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Use the "SQL Server Surface Area Configuration" tool.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00KobeBrian" <a@.b.com> wrote in message
> news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...|||Sorry Folks. I got it. I just didn't point to the correct server. Cheers
"00KobeBrian" <a@.b.com> wrote in message
news:uhhxA8z6GHA.4644@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I tried to select "Local and remote connection" - "TCP/IP" and
> "TCP/IP and named pipe" option and run again. But still got the same
> error. Can anyone please help? Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:ue7WsZV6GHA.3452@.TK2MSFTNGP05.phx.gbl...
>

Tuesday, February 21, 2012

Report from - Report to

Hi,

I have a report setup on reporting services which has several subscriptions attached. The report is run every business day, each hour (8am till 7pm), but the only problem I currently have, is with the report from and report to fields. Is there a proper way to set these up for the automatic distribution, so that the subscription that runs at 8am, will report data from the day before 7pm till 8am?

thanks!

Lionell

Can you clarify your ask? I think what you want is possible, but I'm not sure whether you want a distribution list (data-driven subscription) or you want the 8:00 AM report to be different than the other reports (parameterized report or distinct .RDL).

|||

It's a standard report, not a data-driven subscription. The 8:00 AM report needs to report data from the last time the report was run the previous day until 8:00AM of the current day.

Is there a @.LastTimeRun function which can be used? This probably needs to be put into the report right? Or can it be configured through the web based report manager?

Every report that runs needs to report data from a certain period, for example the 8:00AM report will report from 7pm previous day till 8:00AM current day. Next report will be run at 9:00AM and report data from 8:00AM till 9:00AM and so on.

Hope this explains it better.

regards

Lionell