Report Builder permissions

I would like to know how can I show parts of tables in report builder,

according to parameters that will be sent from the application.

Is it possible?

help...

can I send parameters to report builder, in order to show specific report model for each user?

Report Builder Formatting Currency

Hi all

I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.

I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.

My Question is: Where do I set the culture setting?

I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated

G

under format in properties of the textbox

change it to

$ ###, ###, ###.##

|||

Thanks X

But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix

The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?

They dont give any other specifics

Thanks for the responce

G

|||

maybe set it in Connection String ?

Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us

|||

Hi

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

Still stuck

G

|||

GDavids - SAO wrote:

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

report model have Datasources link in Properties

Datasource have connection string ;]

|||

thanks giret

Where do I view this?

In Report Manager? Because I dont find it..

Thanks for the reponces

|||

http://localhost/Reports/

click on Your model name

Properties Tab:

General

DataSources

Security

|||

This gives the path to my datasource.

Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?

Report Builder Formatting Currency

Hi all

I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.

I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.

My Question is: Where do I set the culture setting?

I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated

G

under format in properties of the textbox

change it to

$ ###, ###, ###.##

|||

Thanks X

But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix

The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?

They dont give any other specifics

Thanks for the responce

G

|||

maybe set it in Connection String ?

Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us

|||

Hi

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

Still stuck

G

|||

GDavids - SAO wrote:

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

report model have Datasources link in Properties

Datasource have connection string ;]

|||

thanks giret

Where do I view this?

In Report Manager? Because I dont find it..

Thanks for the reponces

|||

http://localhost/Reports/

click on Your model name

Properties Tab:

General

DataSources

Security

|||

This gives the path to my datasource.

Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?

REporitng Services for 2005 Express Advanced

Good day,

I have recently downloaded the SQL Server 2005 Express Advanced. According to the site Reporting Services is included with this and when installing one can see Reporting Services installing so all seems fine.

Well, after many days of pulling my hair out I am stuck. All I am trying to do at the moment is view the http://localhost/reports page and I can't. I keep getting an error saying the following:

Server Error in '/Reports' Application.

---

Failed to map the path '/Reports/App_GlobalResources/'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.]

System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +3521404

System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +306

System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46

System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +418

System.Web.Compilation.BuildManager.Initialize() +235

System.Web.Compilation.BuildManager.InitializeBuildManager() +228

System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +310

[HttpException (0x80004005): Failed to map the path '/Reports/App_GlobalResources/'.]

System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426887

System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88

System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Please is there anyone that can help me. I can;t see what is causing this. I have read I need to give the local ASPNet account write access to a whole bunch of folders which I have done but no change. I ran the config tool that installs to set up new Report Manager and Server Virtual Directories and nothing seems to work.

Please someone help me.

I would love to test and try and develop using this, but if I can't even get the Report Manager Server part working I am a long way from development.

Thanks in advance.

Can you use regmon and filemon to see if there are any access denied error for you ASPNET account?|||

Hi James,

Thanks for your help. Yup, I have regmon and filemon and no access denied errors are coming up at all. Sorry I should have mentioned that.

Any other ideas?

Thanks again

|||

Hi - Did you solve this issue? I am still going through this. I have tried installing Reporting services at least 4-5 times now, still having the same issue.

I have IIS 5 installed - but am able to run ASP web sites using 2.0 Framework.

Thanks for your time.

|||

I did but I cannot remember what I did. I had all the good intentions of posting my results here but then got caught up in the next project.

One thing I did note is that I upgraded IE to Ver. 6, but more than that I cannot remember.

I am sorry

REporitng Services for 2005 Express Advanced

Good day,

I have recently downloaded the SQL Server 2005 Express Advanced. According to the site Reporting Services is included with this and when installing one can see Reporting Services installing so all seems fine.

Well, after many days of pulling my hair out I am stuck. All I am trying to do at the moment is view the http://localhost/reports page and I can't. I keep getting an error saying the following:

Server Error in '/Reports' Application.

---

Failed to map the path '/Reports/App_GlobalResources/'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.] System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +3521404 System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +306 System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46 System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +418 System.Web.Compilation.BuildManager.Initialize() +235 System.Web.Compilation.BuildManager.InitializeBuildManager() +228 System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +310 [HttpException (0x80004005): Failed to map the path '/Reports/App_GlobalResources/'.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426887 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Please is there anyone that can help me. I can;t see what is causing this. I have read I need to give the local ASPNet account write access to a whole bunch of folders which I have done but no change. I ran the config tool that installs to set up new Report Manager and Server Virtual Directories and nothing seems to work.

Please someone help me.

I would love to test and try and develop using this, but if I can't even get the Report Manager Server part working I am a long way from development.

Thanks in advance.

Can you use regmon and filemon to see if there are any access denied error for you ASPNET account?|||

Hi James,

Thanks for your help. Yup, I have regmon and filemon and no access denied errors are coming up at all. Sorry I should have mentioned that.

Any other ideas?

Thanks again

|||

Hi - Did you solve this issue? I am still going through this. I have tried installing Reporting services at least 4-5 times now, still having the same issue.

I have IIS 5 installed - but am able to run ASP web sites using 2.0 Framework.

Thanks for your time.

|||

I did but I cannot remember what I did. I had all the good intentions of posting my results here but then got caught up in the next project.

One thing I did note is that I upgraded IE to Ver. 6, but more than that I cannot remember.

I am sorry

REporitng Services for 2005 Express Advanced

Good day,

I have recently downloaded the SQL Server 2005 Express Advanced. According to the site Reporting Services is included with this and when installing one can see Reporting Services installing so all seems fine.

Well, after many days of pulling my hair out I am stuck. All I am trying to do at the moment is view the http://localhost/reports page and I can't. I keep getting an error saying the following:

Server Error in '/Reports' Application.

---

Failed to map the path '/Reports/App_GlobalResources/'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.]

System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +3521404

System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +306

System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46

System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +418

System.Web.Compilation.BuildManager.Initialize() +235

System.Web.Compilation.BuildManager.InitializeBuildManager() +228

System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +310

[HttpException (0x80004005): Failed to map the path '/Reports/App_GlobalResources/'.]

System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426887

System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88

System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Please is there anyone that can help me. I can;t see what is causing this. I have read I need to give the local ASPNet account write access to a whole bunch of folders which I have done but no change. I ran the config tool that installs to set up new Report Manager and Server Virtual Directories and nothing seems to work.

Please someone help me.

I would love to test and try and develop using this, but if I can't even get the Report Manager Server part working I am a long way from development.

Thanks in advance.

Can you use regmon and filemon to see if there are any access denied error for you ASPNET account?|||

Hi James,

Thanks for your help. Yup, I have regmon and filemon and no access denied errors are coming up at all. Sorry I should have mentioned that.

Any other ideas?

Thanks again

|||

Hi - Did you solve this issue? I am still going through this. I have tried installing Reporting services at least 4-5 times now, still having the same issue.

I have IIS 5 installed - but am able to run ASP web sites using 2.0 Framework.

Thanks for your time.

|||

I did but I cannot remember what I did. I had all the good intentions of posting my results here but then got caught up in the next project.

One thing I did note is that I upgraded IE to Ver. 6, but more than that I cannot remember.

I am sorry

replication. change user in client and not replicate all data (only new data).

hello, I need to replicate data in several clients of SQL server. The
replication I do it by means of a dynamic filter, according to suser_sname.
The problem is that I need the client can change the user and replicate
another data set, but only the created new data from last time that the
same user executed the replication (possibly in another client). how it
could make this?
I think what you are talking about is called realignments.
This is where a salesman is getting a subscription based on a filter which
only gives him data for his clients, ie the filter is on Salesman_A. You
want him to be able to now get only Salesman_B's data.
Your best bet is probably to drop the subscription and create a new dynamic
subscription and this time perhaps filter on hostname and hardcode the value
of the HostName parameter in the merge agent as Salesman_B.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Toms Hernndez" <tomihernandez@.yahoo.es> wrote in message
news:OK4lkRNwEHA.3320@.TK2MSFTNGP14.phx.gbl...
> hello, I need to replicate data in several clients of SQL server. The
> replication I do it by means of a dynamic filter, according to
suser_sname.
> The problem is that I need the client can change the user and replicate
> another data set, but only the created new data from last time that the
> same user executed the replication (possibly in another client). how it
> could make this?
>
|||Yes I could drop and recreate a new dynamic subscription with other
user. But my problem is replicate only the new data from the last
replication by this user,
although it does not have in local the previous data because this
replication became in another client.
Are you understand my problem?
Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
news:O6hqeeNwEHA.3296@.TK2MSFTNGP10.phx.gbl...
> I think what you are talking about is called realignments.
> This is where a salesman is getting a subscription based on a filter which
> only gives him data for his clients, ie the filter is on Salesman_A. You
> want him to be able to now get only Salesman_B's data.
> Your best bet is probably to drop the subscription and create a new
dynamic
> subscription and this time perhaps filter on hostname and hardcode the
value
> of the HostName parameter in the merge agent as Salesman_B.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Toms Hernndez" <tomihernandez@.yahoo.es> wrote in message
> news:OK4lkRNwEHA.3320@.TK2MSFTNGP14.phx.gbl...
> suser_sname.
>
|||Perhaps I don't understand your problem.
Is your problem that this laptop could have some recently entered data in,
and you want to sync it up to the publisher, before deploying your new
subscription?
If so, you could set the merge agent to run on a schedule (make sure you
remove the -Continuous switch) and run the merge agent a couple of times
before dropping the subscription.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Toms Hernndez" <tomihernandez@.yahoo.es> wrote in message
news:u$vJJmNwEHA.3840@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Yes I could drop and recreate a new dynamic subscription with other
> user. But my problem is replicate only the new data from the last
> replication by this user,
> although it does not have in local the previous data because this
> replication became in another client.
> Are you understand my problem?
> Thanks.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
> news:O6hqeeNwEHA.3296@.TK2MSFTNGP10.phx.gbl...
which[vbcol=seagreen]
> dynamic
> value
replicate[vbcol=seagreen]
the[vbcol=seagreen]
it
>
|||no, I will try to explain,
The replication begin in the subscriber, it is a pull merge
subscription. And the data to replicate depends of the user (suser_sname)
who is selected in the start of an application. Today is John and tomorrow
is Charles the user, and the data set is different to download to the client
and I dont need to download all the data of Charles, I need only from a
date (the date of the last sync from Charles in this laptop or in the other
laptop).
Are you understand now?
"Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
news:O8KVfqNwEHA.3872@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Perhaps I don't understand your problem.
> Is your problem that this laptop could have some recently entered data in,
> and you want to sync it up to the publisher, before deploying your new
> subscription?
> If so, you could set the merge agent to run on a schedule (make sure you
> remove the -Continuous switch) and run the merge agent a couple of times
> before dropping the subscription.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Toms Hernndez" <tomihernandez@.yahoo.es> wrote in message
> news:u$vJJmNwEHA.3840@.tk2msftngp13.phx.gbl...
> which
You[vbcol=seagreen]
The
> replicate
> the
> it
>