Vertical Data

[rmoynihan]

Hi,

Instead of having data in rows horizontally is it easy to list data vertically in columns.

E.g instead of

Name, Age, Country, Profession
Name, Age, Country, Profession
Name, Age, Country, Profession

I want to achieve

Name                    Name                 Name
Age                       Age                    Age
Country                Country              Country
Profession            Profession         Profession

Thanks,

Ronan

[Steve]

Hi Ronan,

I've attached a sample report that shows you how to achieve horizontal table. Give it a spin and let us know if further help is needed.

Sincerely yours,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[rmoynihan]

Cool,

That's exactly what I was looking for.

I am probably going to use your reporting tools later for data reporting but at the moment I am seeing if they are a good fit to generate pdf documents.

The documents are generated documents after a user fills in a form and can then view/print the pdf to sign or save etc.

Is this a common use of the tool also or should I use some other pdf maker component.

Thanks,

Ronan

[Steve]

Hello Ronan,

This can be accomplished, but you would have to take care of passing the input from the form that the users fill into the report, which should be pre-designed and ready to display the info in the layout you've specified. You can review the following articles for more information:

• How do I access items from report and calling application
• Exporting a report to PDF programmatically

Sincerely yours,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[rmoynihan]

I have the values saved in the database so it should make it easier.

What about the database connection.

I want the reports to us the same connection string as my web.config.

Your guidelines recommend to use a seperate project for reports.
Can I pass the connection string programmatically, I know you can set the datasource in the code behind for each report.

Do you have some example of the reports used in web apps with the report data bound using code and stored procedures.

Thanks,

Ronan

[Steve]

Hi Ronan,

If you use the Report Wizard to create the report on your dev machine, this means that the connectionString is contained within the automatically generated DataSetTableAdapter. This means that you would have to either change it by hand to match the correct connectionString on your live server (which is hard for maintainability) or control the connectionString in some other manner e.g. through the applications config file (web.config for Web app/sites and app.config for Windows forms apps).
You can do that easily from the Report Wizard, by using the "Save the Connection String" step, which automatically creates app .config and settings file containing the needed attributes. Then all you need to do is change the connectionString to match the new server at a single location before deploying your project.
So you do not need to pass anything programmatically - naming the connectionString in the app.config of the class library to match the name of your existing connection in the web.config of your app would be sufficient.
As for the stored procedure, Telerik Reporting does not provide its own data layer but depends on the existing .NET objects (DataSet, Data Table, DataView, ADO.NET, lists - for more information on report data binding, please, refer to this help topic). Because of that, the Telerik Reporting Data Source Wizard cannot be used to connect to parameterized data source such as stored procedure or a Select command with parameters out of the box.
 
What can be done is to manually execute it, feed the returned result set in a DataSet and then pass this DataSet to the Telerik Reporting DataSource. Another approach using our report parameters and NeedDataSource event is shown in this KB article.

For more information how to use ADO.NET to call a parameterized stored procedure, please refer to this KB article.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Daniela]

Hi Steve,

I downloaded your example, sorry that i don't get it. Where exactly did u change the direction of the table?

thanks in advance,

[Steve]

Hello Daniela,

This forum thread is 2 years old and since then we have implemented "Rotate Layout" option. Right click inside a Table cell and select Rotate Layout option from the context menu.

Greetings,
Steve
the Telerik team

[Daniela]

Hi Steve,

thanks for your fast reply. can u please help me with something else?  
I downloaded your example from this thread http://www.telerik.com/community/forums/reporting/telerik-reporting/quot-dynamic-quot-table-in-telerik-reports.aspx 
I am trying to rotate the table but just when I generate more than 5 columns from the database, how can I change the rotatelayout property from c# in this example?


Thanks in advance,

[Steve]

Hi Daniela,

There is no rotate layout property. The option from the context menu which I told you about, converts column groups into row groups and vice versa. There is no way to change those at runtime as the whole table definition would have to be replaced/constructed the other way around. A possible solution for your case would be to check the number of records and generate the table according to this requirement.

Greetings,
Steve
the Telerik team