Last post Jul 31, 2017 07:03 AM by Deepak Panchal
Jul 27, 2017 08:03 AM|Capricon User|LINK
I am searching for custom reporting tool where where end user modify/use/create custom reports?Like if they want only 2 columns then they just drag these 2 columns and data filled in these data columns and create report and also able to modify columns?
i know only 1 tool like SSRS but i don't know is user able to use these conditions in SSRS which i define above?
Or is there any custom where user able to modify reports?
Jul 27, 2017 09:27 AM|Deepak Panchal|LINK
at design time you can follow steps below.
In the Toolbox, click Table,
and then click on the design surface and drag the mouse. Report Designer draws a table data region with three columns in the center of the design surface. The Toolbox may
appear as a tab on the left side of the Report Data pane. To open the Toolbox,
move the pointer over the Toolbox tab. If the Toolbox is
not visible, from the View menu, click Toolbox.
You can also add a table to the report from the design surface. Right-click the design surface, click Insert and
then click Table.
In the Report Data pane, expand the dataset AdventureWorksDataset to
display the fields.
Drag the Date field from the Report Data pane to the first column
in the table.
When you drop the field into the first column, two things happen. First, the data cell will display the field name, known as the field expression, in brackets: [Date]. Second, a column header value is
automatically added to Header row, just above the field expression. By default, the column is the name of the field. You can select the Header row text and type a new name.
Drag the Order field from the Report Data pane to the second column
in the table.
Drag the Product field from the Report Data pane to the third
column in the table.
Drag the Qty field to the right edge of the third column until you get a vertical cursor and the mouse pointer has a plus sign [+]. When you release the mouse button, a fourth column is created for [Qty].
Add the LineTotal field in the same way, creating a fifth column. The column header is Line Total. Report Designer automatically creates a friendly name for the column by splitting LineTotal into two words.
Lesson 4: Adding a Table to the Report (Reporting Services)
at run time you can try to hide and show column.
if you want more options and control then you can try to check Power Pivot.
PowerPivot for Excel Tutorial Introduction
Jul 28, 2017 05:19 AM|Capricon User|LINK
@Deepak thank your ur answer
but i did not ask that
i asked is there any tool end users (not programmers) modify reports.. that is if there is report on page then is this possible for end user to sort columns or only choose columns which they want in report
Jul 28, 2017 10:15 AM|VitaliyMF|LINK
Take a look to the following products:
Jul 31, 2017 07:03 AM|Deepak Panchal|LINK
as I said before , you can try to give option to user to hide or show the column in report.
In report design view, right-click the report item to show or hide, and then click
<report item> Properties. The <report item>
Properties dialog box for the report item opens.
In When the report is initially run, choose one of the following options to set the visibility of this report item the first time you run a report:
Select Show to display the report item.
Select Hide to hide the report item.
Select Show or hide based on an expression to use an expression evaluated at run time to determine the visibility. Click (fx) to open the
Expression dialog box to create an expression.
In Display can be toggled by this report item, from the drop-down box, type or select the name of a text box in the report in which to display a toggle image; for example, Textbox1.
In the following image, the table is configured to enable users to expand and collapse it. The display of the table is toggled by the Products Table text box.
Add an Expand or Collapse Action to an Item (Report Builder and SSRS)
Conditionally Setting Column Visibility in SSRS