Can't See All Tables in Entities Pane

Why is it that only SOME of the tables in my database show up in the Entities pane?

There are a total of six tables in my database, yet only three of them are available to me in the Entities pane. I have looked at permissions, etc, and I am using the SA account. It seems like I should see either ALL or NONE of the tables, but that is not the case.

What am I missing?

Only tables that you included in the Data Source View when you built the Report Model will show in the list of entities. Did you include all six tables? If not, or if you have added tables since you built the model, you'll need to build the model again.

Can't open http:\\192.168.1.x\test\test.asp after ASP.NET2.0 insta

Please help me here as I am total lost in the situation. I've just upgraded
the application server to SQL 2005 with SQL reporting service, therefore, I
have to install ASP.NET 2.0.
After I have successfully installed SQL 2005 / reporting services, I have
found out that I cannot open a ASP page of an application website using URL
such as http:\\192.168.1.x\test\test.asp
More interestingly, I can open the URL without any issue using
http:\\servername\test\test.asp. It is working OK by using server name but
not using IP address.
I have to get it to work using IP address. Can anyone shed some lights on
making it to work with http:\\192.168.1.x\test\test.asp ?
Thanks a lot.Hope you might have seen this, but still; Do you have proxy server? then try
giving your IP address at Do not use proxy... in the IE
options->connection->Lan setting->Advanced.
Amarnath
"Meggie" wrote:
> Please help me here as I am total lost in the situation. I've just upgraded
> the application server to SQL 2005 with SQL reporting service, therefore, I
> have to install ASP.NET 2.0.
> After I have successfully installed SQL 2005 / reporting services, I have
> found out that I cannot open a ASP page of an application website using URL
> such as http:\\192.168.1.x\test\test.asp
> More interestingly, I can open the URL without any issue using
> http:\\servername\test\test.asp. It is working OK by using server name but
> not using IP address.
> I have to get it to work using IP address. Can anyone shed some lights on
> making it to work with http:\\192.168.1.x\test\test.asp ?
> Thanks a lot.

can't get multiple values using reportItems

On a report I have I have a hidden table which I am trying to get values from for a total. On a seperate table, I have an if statement that checks if a product # matches one on this table. This works fine if there is only one record in the hidden table. If there are more than one records, the ReportItems call only see's the last textbox (the last record) of the hidden table. Here's the total expression I use

=IIf( sum(Fields!PickupDeliveryDetails_New.Value)+ sum(Fields!PickupDeliveryDetails_Extra.Value) <= 0, 0 ,((sum(Fields!PickupDeliveryDetails_New.Value) + sum(Fields!PickupDeliveryDetails_Extra.Value)) /

(ReportItems("textbox36").Value

)

)

* (Fields!Actuals_TotalPTypeCharge.Value)

+ (IIf(ReportItems("table6"."TableColumn1").Value = Fields!Product_BPCSNumber.Value, ReportItems("textbox50").Value ,

IIf(First(ReportItems("table6"."TableColumn1").Value) = Fields!Product_BPCSNumber.Value, First(ReportItems("textbox50").Value) , 0 ) ) )

)

Any help on this would be greatly appreciated.

Morgan

That piece of code was not working. Heres the working code.

=IIf( sum(Fields!PickupDeliveryDetails_New.Value)+ sum(Fields!PickupDeliveryDetails_Extra.Value) <= 0, 0 ,((sum(Fields!PickupDeliveryDetails_New.Value) + sum(Fields!PickupDeliveryDetails_Extra.Value)) /

(ReportItems("textbox36").Value

)

)

* (Fields!Actuals_TotalPTypeCharge.Value)

+ (IIf(ReportItems("textbox27").Value = Fields!Product_BPCSNumber.Value, ReportItems("textbox50").Value , 0 ) ))

|||First of all, never use neon green on the post its VERY HARD to read. Is it possible to do a group by Product# in the hidden table and then run an aggregate sum on the values you want added. That way when you reference the textbox in the hidden table from the other table it would be the sum of all values for that same product #|||

That wouldn't work because I need seperate values for each product type total. There is a group by product # but there are multiple product #s.

I have solved my problem by getting the results from the hidden table in the second table (i got the values in the dataset by using left outer joins).

I would still like to know if there is a way to do what I was trying to do if it ever came up again and it couldn't be solved in the query.