report does not come up in remote machine

Hello,
I embedded the report I developed to my asp.net web page,
when I run it in my development computer it is running
fine but I the report does not come up when I call web
page in a remote machine. The rest of web page is working
only report object is not coming. What might the problem
be?
Thanks,
Jim.The account used to access report may not have sufficient permissions to
access the report. You may need to give it sufficient privileges from Report
Manager UI.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:a12801c48721$62e79070$a501280a@.phx.gbl...
> Hello,
> I embedded the report I developed to my asp.net web page,
> when I run it in my development computer it is running
> fine but I the report does not come up when I call web
> page in a remote machine. The rest of web page is working
> only report object is not coming. What might the problem
> be?
> Thanks,
> Jim.
>|||I am actually using the same user. Is report manager
Prograns-> Sql server-> Reporting Services -> Report
Manager? If yes, when I click that it goes to
Http://mylocalhost/Reports and it says "You are not
authorized to view this page"
Any solution?
>--Original Message--
>The account used to access report may not have sufficient
permissions to
>access the report. You may need to give it sufficient
privileges from Report
>Manager UI.
>--
>Ravi Mumulla (Microsoft)
>SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
message
>news:a12801c48721$62e79070$a501280a@.phx.gbl...
>> Hello,
>> I embedded the report I developed to my asp.net web
page,
>> when I run it in my development computer it is running
>> fine but I the report does not come up when I call web
>> page in a remote machine. The rest of web page is
working
>> only report object is not coming. What might the problem
>> be?
>> Thanks,
>> Jim.
>
>.
>

Report DateTime Parameters in UK date format

I have a report that I've developed that accepts several datetime parameters.
In the Report properties, I've set the report Language to English (United
Kingdom).
I am calling my report via the Web Service from an ASP.Net application. The
ASP.Net application Culture and UICulture are set for en-GB.
What is happening is that when a date is passed to one of the report
parameters (gEndDate) as "14/12/2004" (December 14), I get the following
error:
The value provided for the report parameter 'gEndDate' is not valid for its
typeI should also point out that my Visual Studio .Net 2003 environment is in
en-US and my computer is in the United States English setting.
The development environment I am testing (where I got the error) is a
Virtual PC environment set up as English UK in the Control Panel.
"AdamB" wrote:
> I have a report that I've developed that accepts several datetime parameters.
> In the Report properties, I've set the report Language to English (United
> Kingdom).
> I am calling my report via the Web Service from an ASP.Net application. The
> ASP.Net application Culture and UICulture are set for en-GB.
> What is happening is that when a date is passed to one of the report
> parameters (gEndDate) as "14/12/2004" (December 14), I get the following
> error:
> The value provided for the report parameter 'gEndDate' is not valid for its
> type
>

Report Builder

OK so I've developed quite a few reports using report server projects. Now I'd like to see what is available to the end-user after I, as a developer, am sick to tears of making and customizing reports. So I went to Report Builder.

I open Report Builder and see the list of my five entities. Then when I drag and drop a field from one of the entities to the report designer, ALL of the four other entities DISAPPEAR!

Can you not design a report in Report Builder using fields from multiple entities? The design of our databases have much to be desired, so that would make using Report Builder impossible...

Am I missing something here?

Yes, sure you can, if you previously defined the entities and relationship accordingly on either the database or the dsv laterone you should see the right relationships in the report model view. Did you have a look on the sample project with the Adventureworks database ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I must still be missing something (most likely in the setup of the report model).

I'm not sure how to define the entities and relationships properly so that I can drag and drop fields from multiple entities. When I drop one of the fields, all of the other entities (except for the one that I grabbed the field from) disappear.

It seems that I haven't set up the relationships at all...? How do I do this?

Wait a minute, I think I see it.

I have to set the relationships in the view.

|||

Ok, I defined the relationships between the tables in the view. I build and run the report model project.

Then when I run report builder and drag and drop a field, all of the other entities still disappear. When I delete the field, they all come back. Why is this?

|||

Report Builder operates with Report Model - this is semantic model that describes your database in terms of entities, attributes and relationships between entities. In short, an entity usually represents a table, entity attributes are table columns (or expressions that include columns). Database relationships are represented as roles on entities (db relship is visible as two roles in semantic model). For example you may have two entities: Customers and Orders. Each customer may have multiple orders, each order may have one customer. In your database, when you want to ask question about customers and orders, you would join the two tables thus employing Customer-Order relship. In semantic model you will see two entities instead of tables and each entity will have a role that points to another entity (Customer entity will have role "Customer Orders" and Order entity will have role "Customer").

Now when you open report builder, initially you will see all entities. When you put one entity on the surface you start building your question (or report) in the context of this entity. So at this point the flat list of entities disappears and you see your base entity at the root. You also see all attributes of that entity and all roles going from that entity. Now if you want to reach for some attribute in another entity you will need to navigate thru roles (clicking on them) to the desired entity.

When you build (generate) your semantic model, Model Designer will create entities for tables that have primary keys. Model Designer will also autogenerate roles for relationships based on PK-FK constraints. If your tables do not have primary keys, foreign keys you can always add them in Model Designer prior to generating the model.

Reporitng Services Web Service and Credentials

I have developed an asp.net, vb.net web app and have integrated reporting services. Right now I am using url access but am not to crazy about showing the parameters in the querystring. I am using a dynamic stored procedure to get client data. I would like to use the rs web service to programatically set the parameters and send them invisably to the web service. Since the web app is not using windows authentication I would like to pass the parameters using a hard coded account that has been set up with browse privilages in the report manager. Is it possible to hard code the credentials that are sent to the reporting service instead of the System.Net.CredentialsCache.DefaultCredentials? The report returns a bar graph which I am hoping to display on the page. Reading some posts about some problems returning images I might be posting some more questions.

Are there any good walkthroughs or code examples using reporting services web service other than MSDN's limited supply?

Thank you for your time!
--
- preisifigured out the first part

rs.Credentials = New System.Net.NetworkCredential("username", "password", "domain")

Now when i try and render my graph the image can't be found.|||this is not an answer to your question but infact a question to you. can you share with us about how far you have gotten in getting this RS thing to work. i mean i have created some reports which accept a couple of parameters. now i need to create a windows service that calls the reportservice everyday, and prints the report. which is a little similar to what you have done. xcept for the windows service part. so could you share some of your xperience ?

thanks.
dinakar