Data Series Color and Fill Effects?

Hi,

I was wondering if one could manage the color of the data series in line and bar charts much like what you could do in Excel?

Even changing the default order of the colors would be nice, just so different charts actually look...well, different.

Thanks!

Well,

I figured out how to do it, when I actually have multiple data fields there. It is a simply matter of navigating to:

Properties -> Data Tab -> Edit Values...

However, when I have different series that are determined dynamically by dropping dimension fields into the series field, can you still dictate the colors and fills?

Thanks!

|||

OK, I found this online:

http://msdn2.microsoft.com/en-us/library/aa964128(SQL.90).aspx

But I can't seem to find the magical custom code window.

Where is the custom code window?

(I know this is a stupid question, but I really really can't find it)

Data Relationship & SQL data adapter

Hi

I was trying to fill SqlDataAdapter from a " View" with inner join of two tables. When I call the update method of the data adapter it is failing as it cannot generate automatic SQL for multiple tables in my view. Writing own SQL script for update is one way out but it is tedious process.

Is there any other work around to do this?

Can I create a view of two joined data sets on some condition (Just like creating a view in database) in the memory.

Cheers,

Sudath Attanayake.One option you might look into which is extremely common among database programmers, is to only do updates through stored procedures. One of the main reason is security. If you disalow any updates to hapen to the tables or views, then you can control who can update what by simply controlling the permission to execute the individual stored procs, or special case what data can be updated.