Applying colors to reports

Is there a way to apply .css or Skin files to all reports. Changing colors in each and every page is a little cumbersome.

Thanks in advance

Unfortunately no. HTML control is on the wishlist for the next version I believe.|||How about creating a custom assembly and putting your formatting functions in this centralized shared library? Instead of hard-coding colors in your report, reference the shared library. I am in the process of creating 50 reports where the color scheme has not been finalized, and I need the ability to change the color scheme globally. Maybe I can code a way to pull the formatting information from a database table. It would be easier to update the colors that way, instead of having to redeploy the assembly dll with every color change.|||

We have been looking for the same thing, finally we did put our colors (textual) in a database-table and assign text and background colors with an expression, causes some work to do, this for earch report but once done, you can change al your reports depending on the season or whatever crazy reason to change layouts.

Even our header images come from a database so during some periods we can (just like google) do some funny stuff.

Users mostly appreciate it.

Applying colors to reports

Is there a way to apply .css or Skin files to all reports. Changing colors in each and every page is a little cumbersome.

Thanks in advance

Unfortunately no. HTML control is on the wishlist for the next version I believe.|||How about creating a custom assembly and putting your formatting functions in this centralized shared library? Instead of hard-coding colors in your report, reference the shared library. I am in the process of creating 50 reports where the color scheme has not been finalized, and I need the ability to change the color scheme globally. Maybe I can code a way to pull the formatting information from a database table. It would be easier to update the colors that way, instead of having to redeploy the assembly dll with every color change.|||

We have been looking for the same thing, finally we did put our colors (textual) in a database-table and assign text and background colors with an expression, causes some work to do, this for earch report but once done, you can change al your reports depending on the season or whatever crazy reason to change layouts.

Even our header images come from a database so during some periods we can (just like google) do some funny stuff.

Users mostly appreciate it.

apply, ok, save dont function ?

when i login as admin to the Report Manager home page, change any setting
anywhere, then select APPLY or OK or SAVE nothing happens !
what the heck is going on ?
scottis there something in setup i have missed ?
its hosted on 2003 server|||basically the links to any aspx page seem to work but any scripts (i guess)
like NEW FOLDER, DATA SOUCRE, UPLOAD etc dont work

Apply buttons not submitting changes

Hi,

None of the submit "Apply" or "OK" buttons are submitting any changes with in Report Manager. The page does not go any where when these buttons are clicked.
Is this a limitation of the Evaluation version of RS 2000?

Thanks,

Drewhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=146347&SiteID=1

Append only unique records in SQL table

I have a stored procedure that appends data from a temp table to a destination table. The procedure is called from an aspx web page. The destination table has an index on certain fields so as to not allow duplicates.

The issue I'm having is if the imported data contains some records that are unique and some that would be duplicate, the procedure stops and no records are appended. How can I have this procedure complete it's run, passing over the duplicates and appending the unique records? Since the data is in a temp table (which gets deleted after each append) should I run some sort of 'find duplicates' query, and delete the duplicates from the temp table first, then append to the destination table?

Thanks in advance.
SMc

Lets say your destination table is called Dest and you temporary table is called Temp.

Both tables have two fields, A and B where A is the one that needs to be unique in Dest, but it's not necesarily unique in Temp (or Temp contains rows with a value of A that already exists in Dest).

insertinto Dest

select Temp.A, Temp.Bfrom Temp

where Temp.Anotin(select Dest.Afrom Dest)

|||

I was just fighting with similar, but a lot of simpler problem. Maybe these posts will help.

http://forums.asp.net/t/1185782.aspx

And IF NOT EXISTS(SELECT * FROM table WHERE .....

Hope it helps

Leif