Access vs. MSDE

I understand how msde is more powerfull than assess but is the only way to use MSDE through the web matrix. If I want to update a table or change data how can I open the file and work with it or is this when I buy SQL server. I travel full time and do all my work from my laptop so I do not want to install any server software on it. Or should I just us access and use the upsize wizard to use MSDE.

Adam TaylorCould use a little more info.

It all depends:

Are you developing applications for other people?
Is it for personal/business use, contact management, etc?
What exactly is it that you are trying to accomplish?

Thanks.|||You can get to the tables etc using Access (At least you can with access 2002)

start Access
select the New Project (Existing Data)

Then select the machine (or type it) where the tables are
Supply login details (should be same as you require when using web matrix)

click the drop down to select a database to work on

It should work - does on mine

then you can use all access tools to manipulate the data - plus add tables and stored procedures

Pk

Access to MSDE database

Hi
I am just starting my first .NET project using the web matrix and an MSDE database. I am pretty much at the limit of my knowledge - all very interesting. I have some data in an Access spreadsheet (6 columns and 365 rows) which in the past I have copied and pasted into an Access database table. How do I get it into a MSDE database table? This process does not need to be automated/programmed as I will only have to do it once a year. Any ideas on the easiest way forward would be much appreciated.
Thanks in advance.
MikeUse the Upsizing Wizard in Access. Tools/Database Utilities/Ubsizig Wizard, as I recall.|||Douglas
Very many thanks for the advise - it got me going along the righttracks. In the end I used File/Export (which seemed well suitedto transfering data in a single table). I had to configure someODBC connections (which took me a while to understand and setup). Anyway, it seems to work now.
Thanks again.
Mike

Access to group field value from the child element

I have a matrix and have a column groups on month and products ( I have only
4 products) and am showing the number of products sold in that month. What I
need is to show instead of number products, I need to show the % of sales for
that product as compared to all sales.
I need to access the group total in the child field. If 10 items were sold
in each product, I would like to show 25% (10/40 * 100) in the detail. Is
there any way to access the group total in the child fields.
Any help is appreciated.
--
Thanks
RK BalajiI found the solution.. I just have to use the scope parameter in the count
function to get the value. Thanks.
"RK Balaji" wrote:
> I have a matrix and have a column groups on month and products ( I have only
> 4 products) and am showing the number of products sold in that month. What I
> need is to show instead of number products, I need to show the % of sales for
> that product as compared to all sales.
> I need to access the group total in the child field. If 10 items were sold
> in each product, I would like to show 25% (10/40 * 100) in the detail. Is
> there any way to access the group total in the child fields.
> Any help is appreciated.
> --
> Thanks
> RK Balaji

Access specific Graph data

Hello again
I have a graph which lists cell phone minutes broken down by month. I want the specific data for that month to show in either a matrix or table underneath the graph. The key is that I just want the date for that month only. When the user clicks on a specific month on the graph I just want to show that months data. I know how to accomplish this using the "jump to report" option with parameters,but how do I do this on the same report -- right underneath the graph?

thanks
km

Try SubReport.

SubReport is the report where you can view the main report and drilled down report (sub report) in the same window.

1)the development includes design of a new subreport

2) Have an item called "subreport" in the main report where you want to place that is beneath

3) assign the subreport properties to get your newly developed report(Name of the report,Parameters)

4) Control the visibiliy of the subreport.

Thanks

|||great thanks
appreciate the help
km

Access Items Generated in Matrix?

I am using a matrix in a report and it would be great to be able to work with
some of the values it is displaying after they had been grouped and split
apart.
Is it possible to access these values from the matrix somehow?i would look up actions with analysis services. this might be what you're
talking about.
OLAP (analysis services) against OWC allows a flexible, high-performance
reporting solution.
-aaron
"Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
message news:56DC1DA7-0E89-4FA0-821C-775B33B965C2@.microsoft.com...
> I am using a matrix in a report and it would be great to be able to work
with
> some of the values it is displaying after they had been grouped and split
> apart.
> Is it possible to access these values from the matrix somehow?|||Interesting... I will look at it.
Besides this possibility, does anyone know of any other technique that might
be useful here? Is there a way to do something akin to subtotaling but
instead have it show the difference between columns?
"aaron kempf" wrote:
> i would look up actions with analysis services. this might be what you're
> talking about.
> OLAP (analysis services) against OWC allows a flexible, high-performance
> reporting solution.
> -aaron
>
> "Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
> message news:56DC1DA7-0E89-4FA0-821C-775B33B965C2@.microsoft.com...
> > I am using a matrix in a report and it would be great to be able to work
> with
> > some of the values it is displaying after they had been grouped and split
> > apart.
> >
> > Is it possible to access these values from the matrix somehow?
>
>