Accessing 2005 Reports from asp.net 1.1

Our web based Application is based on ASP.NET 1.1 and SQL Server 2005.
Can we use 2005 Reporting Services (ASP.NET 2.0) to create and publish
reports and use them in the 1.1 Application?
(We need to change the Data Source at run time, which is not easy or not
possible in 2000 Reporting Services).
Thanks in advance,
BenjaminIn order to display a report you need just an URL. What seems to be a
problem?
You can view any url in your 1.1 application, even from a different web
site.
Just redirect to it or grab an ouput and display it in your application.
If you have a way of changing datasource in runtime in RS 2005, just create
a 2.0 web page, which does it on load and redirect/transfer from it to the
the report of your choice.
"Benjamin" <benjamin@.servue.com> wrote in message
news:ORZ$mvz9GHA.4196@.TK2MSFTNGP03.phx.gbl...
> Our web based Application is based on ASP.NET 1.1 and SQL Server 2005.
> Can we use 2005 Reporting Services (ASP.NET 2.0) to create and publish
> reports and use them in the 1.1 Application?
> (We need to change the Data Source at run time, which is not easy or not
> possible in 2000 Reporting Services).
> Thanks in advance,
> Benjamin
>

Access Subforms not updatable

Hello,
I have an Access client that has a subform based on a VIEW. I wrote the view
with an instead of insert trigger. I also included the WITH VIEW_METADATA
option. The problem is this. If I have the VIEW_METADATA option in my VIEW,
the forms recordset is not updatable, but if it ALTER the VIEW, excluding the
option, then the recordset is updatable, but the trigger won't work. I need
the trigger to work. Is there anything that I can do.
Thank you,
Brandon
What is the trigger doing? Perhaps you can handle the whole process a
different way. Triggers often introduce unwanted complexity and have
unintended consequences.
--Mary
On Sat, 11 Sep 2004 19:39:02 -0700, "Brandon Campbell"
<BrandonCampbell@.discussions.microsoft.com> wrote:

>Hello,
>I have an Access client that has a subform based on a VIEW. I wrote the view
>with an instead of insert trigger. I also included the WITH VIEW_METADATA
>option. The problem is this. If I have the VIEW_METADATA option in my VIEW,
>the forms recordset is not updatable, but if it ALTER the VIEW, excluding the
>option, then the recordset is updatable, but the trigger won't work. I need
>the trigger to work. Is there anything that I can do.
>Thank you,
>Brandon

Access fields in the Fields collection by index

Is there anyway to access the fields collection using an index?
e.g,. =Fileds(0).Value ?
I want to create a calculated field based on two columns (position 1 and 2)
in a matrix report, but their column names change based on the dates as
paramaters.
Any ideas?On May 3, 11:06 am, Eric <E...@.discussions.microsoft.com> wrote:
> Is there anyway to access the fields collection using an index?
> e.g,. =Fileds(0).Value ?
> I want to create a calculated field based on two columns (position 1 and 2)
> in a matrix report, but their column names change based on the dates as
> paramaters.
> Any ideas?
You should be able to access the position 1 column via: =Min(Fields!
FieldThatIsPivoted.Value). The second positioned column will be tricky
to capture though. Otherwise, you should be able to handle this in the
query/stored procedure that sources the report (via while loop or
cursor). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant