NewsLetter-Style

Jean-François Handfield 101 Reputation points
2020-11-04T20:25:24.027+00:00

Ok I just started creating reports in PowerBI Reporting, which is real close to SSRS, so I hope you guys can help me out with a report I'm trying to create. Bare with me if my question seems fuzzy, I'll try to add details if you guys can't understand the questions :

  1. I'm trying to produce a report NewsLetter-Style on 2 columns. This report is going to be consumed as a way to produce label for mass mailing. So I got the 2 column part on my report done but what i'm trying to figure out is how to but a maximum of items block to be displayed by column. Right now I would like to fit 10 on each side and it has to line up perfectly. Is there a way to se a number of items by column ? Right now my setup is a List region containing 3 textbox with 2 of those having info from my dataset.
  2. The first item in my second column starts a bit too high for some reason how can i fix that ?
  3. I read on a Microsoft site that, for some reason, when you are exporting that report to Word you lose the 2 columns and it all goes on one column. How can I make a report that is going to retain the 2 column part so when can print those labels ? I tried exporting to PDF and from there exporting to Word and that works, but it's a process I would want my users to go throught.

I've attached a screenshot of my setup if it helps.
37518-ssrs.png

Thank you for the help

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,918 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 36,511 Reputation points
    2020-11-06T02:43:36.23+00:00

    Hey @Jean-François Handfield ,

    1.Please delete the 'sorting by' as shown in the first image.
    If you want 20 per page like the second image show, you may use 'Ceiling((RowNumber(NOTHING)) / 10)' which means put 10.

    37932-screenshot-2020-11-06-095506.jpg
    37809-screenshot-2020-11-06-095654.jpg

    2.Thanks for the "compiled" report, the issue is related with the table position.
    Please adjust the position of your table like my third image setting, make the location top to 0in.
    37854-screenshot-2020-11-06-104000.jpg

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,511 Reputation points
    2020-11-05T06:17:53.273+00:00

    Hi @Jean-François Handfield ,

    Please refer to the following solutions.

    1.If you want to set 10 record per page when you render reports, you may add a Parent Group with expression

    =Ceiling((RowNumber(NOTHING)) / 10)

    Here is a detail tutorial for your reference:

    https://www.mssqltips.com/sqlservertip/3493/display-a-fixed-number-of-rows-per-page-for-an-ssrs-report/

    2.You said that the first item in your second column starts a bit too high for some reason, I couldn't fully understand the issue.

    Could you please share a screenshot with me? Also you could display a static row or column on multiple pages with the following setting.

    Display a static row or column on multiple pages

    3.The report will only render like Newsletter when in the image or the pdf format , so when we export to Word, it will still be one column.
    https://video2.skills-academy.com/en-us/previous-versions/sql/sql-server-2008-r2/ms159107(v=sql.105)

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments
  2. Jean-François Handfield 101 Reputation points
    2020-11-05T15:09:11.797+00:00

    Hey Zoe,

    Thank you for the quick feedback. Like I said I'm in the early stage of understanding that beast of PowerBI Reporting or SSRS. So here goes.

    1- I did so searching before posting here and I did find the post you suggested and tried the =Ceiling((RowNumber(NOTHING)) / 10) and for some reason I didn't get the result I was looking for. Might be I'm not doing it the correct way. If I'm looking for 10 per Column, so 20 in total on the page, do I put 10 or 20 ? Plus now when I try it again it's giving me an error. Here's a screenshot of the setup I have and the error.

    2- I attached to this post a screenshot of my "compiled" report so you see that the second column starts a bit higher.

    Thank you again.

    JF
    37771-ceilingsetup.png
    37762-ceilingerror.png
    37782-report.png

    0 comments
  3. Jean-François Handfield 101 Reputation points
    2020-11-06T15:48:10.563+00:00

    Thank you for your help Zoe. I made it work but without the CEILING part since it wasn't working on my end. When I was using it I end up with for item on my page. Anyhow by using paddding and margins I end up 10 in each column like I need it. As for the location you showed me it fixed my problem for my second column starting a bit too high.

    Thank you again.

    0 comments
  4. ZoeHui-MSFT 36,511 Reputation points
    2020-11-09T01:27:21.607+00:00

    Hey @Jean-François Handfield ,

    Thanks for your reply.

    Glad to hear the issue has been resolved.

    We'd suggest click "Accept Answer" so we could archive the case.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.