Dynamically Generating RDLC - awyke

We have a solution to a problem; the problem is that we need 500 reports to
be generated by usesrs who use the reports so we need a simple distilled
reporting tool they can use.

the solution is to dynamically generate the RDLC we are going to use LINQ to
SQL Business Objects to bind to the RDLC file.  The file has to be
dynamically generated.  Out plans are to use LINQ to XML to generate the
files.  As along as I adhere to the RDLC’s schema there should be no problems?

My design is a LINQ to SQL Relation hierarchy browser that allows the user
to chooses fields and drag and drop them onto a report while they are editing
the report.

Here are a couple of questions for you:

Does this make for a good choice in architecture and solving the problem?

--
Alexander L. Wykel
AW Software Works

Dynamically Generating RDLC - Bruce L-C [MVP]

Seems a little re-inventing the wheel. Has you looked at Report Builder. It
is a tool for users to do exactly as you say. It was released with RS 2005.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

Dynamically Generating RDLC - awyke

Well, our users are no where near devveloper level wee need some thing for
that would be easiy enough for an admin to use, plus you would have to
recomplime the project we don't want our admins doing that.  It is re
inventing the wheel, we just want it simpiler to some non technical user can
uses it with no assembly required.
--
Alexander L. Wykel
AW Software Works

Dynamically Generating RDLC - Bruce L-C [MVP]

Report Builder is different from Report Designer. Be sure that whatever you
are doing is significantly easier for the user than Report Builder.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

Dynamically Generating RDLC - shikarishambu

My 2 cents... Report Builder is not user friendly for it to be an end user
tool. It is for lazy programmers.

Dynamically Generating RDLC - Bruce L-C [MVP]

I've always thought that these and other tools (for instance Business
Objects does something similar) are really for a subset of power users. Most
people just will not have the skillset to create their own reports.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

Dynamically Generating RDLC - changli

Hi Alexander,
Appreciate your understanding that our newsgroup is focused on break/fix
issue, for such advisory questions, we could just give you some general
suggestions here. To work out a final solution, you may need to do many
tests.

Anyway I can confirm with you that if your generated RDLC schemas are
validated, they will be no problem in processing and displaying.

Since your end users are not developers and you want them to have the
capability to design custom reports, I think that it does make sense for
you to dynamically generate RDLC files from your users' dragging and
dropping on a front end UI. To hide your internal database information, I
recommend that you create a layer of business objects which are mapping to
your SQL metadata.

Please feel free to let me know if you have any further questions or
concerns. It is my pleasure to be of your assistance.


Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

Dynamically Generating RDLC - awyke

The plan was to give them something like the Add New Data Source dialog in
Visual Studio, that allows you to pick and chooses what the best widget is
for the particular db field.  I was going to use reflections to display the
object layer relationships and then allow them to drag and drop items.
Additionally there would be templates to start with that constrains where
they can add the data, and when kind of data they can add.  But yes the RDLC
sill be validated thru a valuator and the templates will be generated and
then imported using paste XML as XElemet (not sure where I got this codeplex
maybe) and just create components.
--
Alexander L. Wykel
AW Software Works

Dynamically Generating RDLC - changli

Thank you for letting us know your plan. I think that you have made a good
choice for the design.

Please feel free to let us know if you have any other questions or
concerns. Have a nice day!


Best regards,
Charles Wang

Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
====================================================