Member Avatar for jovillanuev

Hi Guys,

I have created a manual SSRS Report.
when i click the layout tab it display report layout then i drag the fields from report datasets. i want to set my fields into
Table details and i want to insert group but this function is missing or hide.
i tried to right click in the corner and outside of the fields it display only report parameter, pageheader, page footer and properties.

what should i do guys.

Regards,

Jonel

  • 1 Contributor
  • 1 Reply
  • 73 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by jovillanuev

Dani AI

Generated

The grouping controls in SSRS are context‑sensitive, so the menu will look different depending on where you click and which designer you are using. If the right‑click menu only shows report parameter, header/footer and properties, that usually means you clicked the report body or a textbox rather than the Tablix row/column handle, or the Row/Column Groups pane is hidden. As reported "I got it now", this is a common, non‑fatal UI hiccup.

Common, reliable steps to make the group options appear:

  • Make sure you are in the report designer (BIDS/SSDT or Report Builder) Layout view, not Preview or the web Report Manager.
  • Select the Table/Tablix. Right‑click the small grey row handle at the left of the details row (or the tablix corner handle). Use Add Group -> Parent Group / Child Group to create groups.
  • If you do not see a Grouping pane, open the designer’s Grouping or Group and Sort window from the View menu (exact name depends on SSRS version). The Row Groups and Column Groups pane lets you add, edit, and reorder groups.
  • If there is no table yet, insert a Table (Tablix), bind it to the dataset, and then add groups. Also avoid trying to add groups from inside headers/footers—those menus differ.

Troubleshooting notes: check that the dataset is assigned, that you are clicking the row handle (not the textbox), and that you are not in Preview mode. These checks resolve the vast majority of “missing” group menu issues.

Member Avatar for jovillanuev

I got it now.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.