A report VIEWER control ! How about the report DESIGNER control ?

Hi all, our team is really excited about the new ReportViewer control.
Heck, it even supports custom data sources, which fits in nicely with our
overall application design.
The only thing that seems to be missing then is a control that allows our
users to design (or at least modify) reports themselves. In our mind,
the biggest advantage to working with a report engine and report files
is the ability to provide your users with customizable reports.
Moreover, we know this functionality exists since we (programmers)
use the report designer in VS2005. So it would be up to Microsoft to
package it into a control and ship it.
I'm sure somebody else has already asked about this by now but repeated
google queries have turned up nothing relevant.
Thanks for any light anyone can shed on this.
Sven
PS: I hope my cross-posting does notTake a look at the information about Report Builder in Reporting
Services 2005. That is intended to give end users the ability to
design their own reports.
But it's not a control though. Of course, until recently the Report
Viewer control didn't exist either. :)
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:19:45 +0200, "Sven Devriese"
<desfen@.newsgroup.nospam> wrote:
>Hi all, our team is really excited about the new ReportViewer control.
>Heck, it even supports custom data sources, which fits in nicely with our
>overall application design.
>The only thing that seems to be missing then is a control that allows our
>users to design (or at least modify) reports themselves. In our mind,
>the biggest advantage to working with a report engine and report files
>is the ability to provide your users with customizable reports.
>Moreover, we know this functionality exists since we (programmers)
>use the report designer in VS2005. So it would be up to Microsoft to
>package it into a control and ship it.
>I'm sure somebody else has already asked about this by now but repeated
>google queries have turned up nothing relevant.
>Thanks for any light anyone can shed on this.
>Sven
>PS: I hope my cross-posting does not
>|||It is not as simple as that. The report designer is built to work with
Visual Studio and takes advantage of common functionality (for instance, all
the query design windows). As a matter of fact, the designer in 2005 now
ships with a special version of VS 2005. Plus you also have vb.net etc etc.
For that reason I don't expect to ever see this as a redistributable.
However, as Andrew mentioned, there is now Report Builder as well for end
users.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sven Devriese" <desfen@.newsgroup.nospam> wrote in message
news:usVb5ZxzFHA.612@.TK2MSFTNGP10.phx.gbl...
> Hi all, our team is really excited about the new ReportViewer control.
> Heck, it even supports custom data sources, which fits in nicely with our
> overall application design.
> The only thing that seems to be missing then is a control that allows our
> users to design (or at least modify) reports themselves. In our mind,
> the biggest advantage to working with a report engine and report files
> is the ability to provide your users with customizable reports.
> Moreover, we know this functionality exists since we (programmers)
> use the report designer in VS2005. So it would be up to Microsoft to
> package it into a control and ship it.
> I'm sure somebody else has already asked about this by now but repeated
> google queries have turned up nothing relevant.
> Thanks for any light anyone can shed on this.
> Sven
> PS: I hope my cross-posting does not
>|||Keep in mind that Report Builder generated RDL files cannot be used directly
with the report viewer controls in Local Mode. They can however be easily
used with the controls in Server Mode.
RDL is a documented and open standard, e.g. for the 2003/10 RDL of RS 2000
please check http://www.microsoft.com/sql/reporting/techinfo/rdlspec.mspx,
the 2005/01 RDL is very similar. You could write your own designer component
that generates RDL. In fact, there are ISVs who have implemented e.g.
web-based report authoring tools. Please check:
http://www.microsoft.com/sql/reporting/partners/default.mspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:g8upk1tmjfb3vasb96s71r36aadm4lohks@.4ax.com...
> Take a look at the information about Report Builder in Reporting
> Services 2005. That is intended to give end users the ability to
> design their own reports.
> But it's not a control though. Of course, until recently the Report
> Viewer control didn't exist either. :)
> Andrew Watt
> MVP - InfoPath
> On Wed, 12 Oct 2005 12:19:45 +0200, "Sven Devriese"
> <desfen@.newsgroup.nospam> wrote:
>>Hi all, our team is really excited about the new ReportViewer control.
>>Heck, it even supports custom data sources, which fits in nicely with our
>>overall application design.
>>The only thing that seems to be missing then is a control that allows our
>>users to design (or at least modify) reports themselves. In our mind,
>>the biggest advantage to working with a report engine and report files
>>is the ability to provide your users with customizable reports.
>>Moreover, we know this functionality exists since we (programmers)
>>use the report designer in VS2005. So it would be up to Microsoft to
>>package it into a control and ship it.
>>I'm sure somebody else has already asked about this by now but repeated
>>google queries have turned up nothing relevant.
>>Thanks for any light anyone can shed on this.
>>Sven
>>PS: I hope my cross-posting does not
>

A more consistant Web Report Viewer?

Is there another way of displaying reports online that will show the data exactly as it wil be printed?

A number of things have been causing me problems, such as the fact that the pagination controls do not show the same number of pages that actualy get printed. And some fields in the the report viewer do not line up with their column headers, but on the print outs they do.

We used to use Crystal reports, and would like the report viewer to act in a similar manor to their ActiveX report viewer.

Any help is greatly apprechiated.

Many thanks

Matt

I am kindof shooting from the hip here without looking into it too deeply, but I am pretty sure that you can specify CSS as they apply to viewed reports. In doing so, there should be a "print.css", which can be altered as well. This may not be the solution that you are looking for, but I think that it would merit some looking in to.

Hope this helps a bit,

Nathan

|||

Hi Nathan,

Thanks for your comments, but thats not exactly what i was after.

I just had a thought though, there obvously is an activex control that can render the report as this is launched in the print preview.

Does anybody know how to use this renderer as the viewer embeded in a HTML page?

Cheers

Matt

|||

Hi Matt,

Print uses the EMF image extension. You can find the details here: http://msdn2.microsoft.com/en-us/library/ms155373.aspx

If you set the PageHeight and PageWidth properties of your report and use the same margins, this will make the web viewer more similar to the view of Print.

|||You can try displaying the EMF yourself, but I would guess that PDF might be more useable since you don't need to actually write an application to display it. For EMF, you are going to have to write something actually display the metafile that we send.|||

Hi Guys,

Thanks for your feedback.

Brad: I have played around with the Page propeties, however i could not get them to match the printouts exactly (which in this instance is what i need to be able to do), but thanks for the details on EMF, i'll definatley look into it.

John: I will look at how viable using PDF is in our situation, but i think the EMF file might be the way i have to go.

Does anybody have any info on converting a report into and EMF file?

Thanks again guys

Matt

a key time as a split variable in Microsoft Time Series?

Hello,

I was working with Microsoft Time Series model (MTS) with some data, when in the mining model viewer, decision tree tab, I realized that the key time variable that I define, it was acting like a split variable.

So, I ask you, this is possible?, because, for me, this should not happen….

After, I review the Data Mining Tutorial by Seth Paul, Jamie MacLennan, Zhaohui Tang and Scott Oveson, and I found, in the Forecasting part, that the key time variable (Time Index) it was acting like a split variable too, in for example, M200 pacific:Quantity and R250 Europe:Quantity.

So people, it’s possible that a key time variable act like a split variable in a MTS model?

Thanks

This is by design. Imagine you have a series that behaves in a certain manner, then at some time, the behavior changes radically - possibly due to some external event not captured in your data. Since the Time Series prediction always occurs in the future, splitting on time allows us to isolate and describe that past behavior without averaging out that behavior into your current predictions. If your series was mostly increasing or decreasing, this would manifest itself naturally in a split like (t-2)>70, however, if your series is mostly stationary, such a split wouldn't make sense.

The implementation is that we add a monotonically increasing series that is only used as a split candidate and not as a regression candidate.