Well you don't use <center></center> at all for anything, really, because that's not even real HTML.

And you don't "center a page in XML" because XML, in general, describes data rather than layout/formatting, so doesn't have a concept of centering.

To give you a useful answer, I need more information.

What are you actually using - is it XHTML, is it file.xml with a related file.xslt, or is it something else?

Do you mean center like this:


Or like this:

Why are the center tags not proper html?

I'm try to do the 2nd example you posted there.

I have a report made and I would like the whole thing centered on the page.

This is an example of the code that I can see.

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="KilnData">
      <DataSourceReference>KilnData</DataSourceReference>
      <rd:SecurityType>None</rd:SecurityType>
      <rd:DataSourceID>0915e801-0c00-4013-a86a-3762972008de</rd:DataSourceID>
    </DataSource>

Because proper HTML is for describing the meaning, not what it looks like (that's what CSS is for).

If this was anything other than Microsoft, I'd say you have an XSLT file somewhere, which transforms that XML into HTML, and you would just need to locate that file and set the left and right margins to "auto" (and assign a fixed width) and the report would be centered.

(That box above was simply <div style="background-color:silver; width:350px; margin:auto;">I'm a centered box,<br />with left aligned text.</div>)

But - because it's Microsoft - they've probably invented their own way of doing it, just because that's what Microsoft does.

And it looks like they have, with their RDL thing. So what you need to do is read their documentation on Layout / Page and see if you can set LeftMargin and RightMargin to auto, or if you need to calculate explicit values to use.

Didn't you mention you had a book on SSRS? This is probably mentioned in there somewhere.

XML is great, isn't it? It's so enterprisey.

If by "enterprisey" means "bloated worthless shite that appears better on paper but actually takes ten times as much effort to do anything with because it was designed to solve the wrong problem", then yes, it is.

That's a nicely enterprisey definition, well done! :D

(although I think adding a few terms like 'blue-sky' and 'process-driven' or maybe 'social media' could corp it up a bit)

FUCKKKK I have a real fucking strange issue going on with a report I made. And I would like to get a fresh set of eyes on it, but it will be pretty hard to get all the relevant data posted so you would even understand what the fuck I'm talking about. GRRRRRRRRR I hate life.

Have you ever used the CF Report Builder?

Has anyone checked on PeeB lately? I think his chair attacked him, causing him to fall, and not be able to get up!

My chair did not attack me!

It would never do such a thing to me. :@

Well that was the only logical explanation!

And no, not used CF Report Builder, fortunately.

With CF8/9 Adobe did (attempt to) make it non-shit, but I've not had any reason to see if they succeeded.

I was going to try it, but I'm too dumb to make it work with Ralio.

I've no idea if it'll run against Railo or not - wouldn't be surprised if Adobe had deliberately made it incompatible in some way. :/

haha, I guess there's a comic for every situation!

I don't chew gum.

Peter do you have any idea why this isn't working or how I can make it work?

If you look at this query there is a ConsumedVol that sums everything that is 'consumed' and a ProducedVol that sums everything Produced.

I need to also do this for the ConsumedTotal and ProducedTotal. As the query is now I'm getting those numbers, but they are all lumped together. How can I do multiple sums in this query?

SELECT
	ruhID,rudProductID,ruhDescrip,ruhDate,ruhLocationID,rudTotal AS ConsumedTotal,ConsumedVol=(SELECT SUM(ISNULL(rudVolume,0))
FROM
	ProductionDetail
WHERE
	rudID=ruhID
AND
	rudCategory='Consumed'),rudTotal AS ProducedTotal,ProducedVol=(SELECT SUM(ISNULL(rudVolume,0))
FROM
	ProductionDetail
WHERE
	rudID=ruhID
AND
	rudCategory='Produced')
FROM
	ProductionHeader
LEFT JOIN
	ProductionDetail
ON
	ruhID = rudID
WHERE
	ruhID
LIKE
	'%bg%'
AND
	ruhDate
BETWEEN
	'5/1/11'
AND
	'5/31/11'
GROUP BY
	ruhID,ruhDescrip,ruhDate,ruhLocationID,rudTotal,rudProductID
ORDER BY
	ruhDate DESC, ruhId ASC