Hi,
You can download the BOL from http://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=6584
But that is about 120 MB in size.
I would like to copy here the information from BOL here when I work at my computer.
|||The "What is New" section for RS in the BOL said the only new features were those included in SQL 2K5 SP2. Is that true? If so, I'm very dissapointed. Is there another version of RS scheduled to be released in the next year?
Michael
|||We have several new features coming in Reporting Services 2008 but the current CTP does not contain any of them. We previewed a few of them at TechEd a few weeks ago. In the next few months, you will see new stuff from us.|||Thanks Brian.
Forgive me, but I have to ask, as I can't find information on one issue. The biggest issue for me these days is the lack of a "no-wrap" feature for HTML reports. It forces me to create 3 reports instead of 1 when my left axis columns are dynamic. Is anything like this available in SQL 2008? Will it be available with the upcoming stylesheet support?
I could potentially work around many of the sizing issues if I could dynamically control height and width using expressions (you can't currently). Is there any plan to allow simple expressions for height and width? Seems like there could be a two phase processing of this value; e.g. prior to rendering, calculate height and width expressions, and then render (obviously the expressions would have to be based on non-data variables such as parameters that could be evaluated when the report definition is first loaded).
Thanks again for replying,
Michael
|||Hi Michael,
It is possible to do this by applying XSLT to the XML data output instead. Would you be interested in that approach? This is something you could control and does not require engine changes...
The downside is that doing it generically requires an XSLT that is very smart about reading RDL, unless you don't care about preserving the original presentation at all. It's like re-writing the HTML renderer.
OTOH, you could do it non-generically fairly easily (on a per-report basis, IOW), if you write an XSLT specific to the original reporting presentation.
I know this doesn't answer your question and I have no idea what Brian will say <s>...
>L<
|||Thanks Lisa. That sounds like more work than I am willing to put in right now given my deadlines. I won't rule it out long term, but I will definitely wait to see if Brian replies at some point before taking a plunge like that. Thanks for your input!
Michael
|||If you get stuck for time and ideas (depending on Brian of course), and want to do it the easy, non-generic way, give me a shout off-forum (lisa at spacefold dot com).
I am not looking for work! I am saying I would try this one using your example as a way of giving myself the kick in the pants it takes to work out a more extensive/generic approach to the task.
if I don't have any time available to play with this, if and when you want to give it a whirl, I will be frank <s>. If the non-generic way turns out to be more difficult than I thought, I would tell you quickly and neither one of us would have lost anything <s>. If it works out for your sample, you might have a q&d solution and I would have moved forward on this idea, which is hard for me to do without some external requirement of my own, and we both win <s>.
>L<
|||If you want to go for it, and post an example, that's fine with me. It's YOUR time, after all! My deadlines are so tight I can't really even work on the issue at all. The only requirement for me is that it works with SQL Server Express, as my application has to be deployable on that platform. Good luck! I hope you can figure something out!
Michael
|||No I already said -- I can't do this without a real world example -- and I don't personally have a reason to do it. Remember this is supposed to be the non-generic quick version.
To work on YOUR report, I would need two things (that's why I included my email info last msg):
1) a sample of the HTML output that we're trying to create. The tricky part for me will be how close can I get to that result -- for example if there are embedded images I'm probably out of luck. (There is, I think, actually a way to do it but not strictly through XSLT and you SO not want to go down that path right now. )
2) the raw XML output from your report when you export it as that.
Then I see whether I can write an XSLT that you can attach to the report to turn one into the other, with the differences you're looking for, or maybe something that's close, with the differences you wanted, and the aesthetics of the original.
Does this make sense? Again, if it turns out to be tough, I'll abandon the effort and tell you pretty quickly. But how well I can do it on one of my reports won't help you and I'm not inclined or motivated <s>.
>L<
|||Lisa,
I appreciate the offer. Just the thought of you doing that much work on my behalf makes me feel guilty for not even trying it. However, I can't ship any of my reports to you. Given how many parameters I have, and how many fields I have, it would almost seem easier for you to create a simple matrix with 2 columns and 2 rows and see if you can resize them on the fly with dummy data. Not sure why you need actual report. Either way, I don't think you need to spend time on this (nor should you). I can't export as XML using the Express services anyway. It just gives me a "format not supported" error.
Normally I'd be more inclined to dive into this with you - but I'm on such a tight schedule I have to do things adequately, and then move on, even if the columns aren't exactly the right size.
Michael
No comments:
Post a Comment