[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

SRSS Report mailing list

I need to create name badges for an upcoming event.  My badges are 3 x 4 and the report should have 6 individual badges on it.  How do I create a report with 2 columns and 3 'rows'?  How do I create my report so that each of the six 'parts' gets a different record?
0
ACUIWebDeveloper
Asked:
ACUIWebDeveloper
  • 5
1 Solution
 
Feridun KadirPrincipal ConsultantCommented:
If this is for Dynamics CRM, I think you will find it quicker and easier to do a mail merge with Word (select labels in Word).
0
 
planoczCommented:
You may have to use a matrix table, which will expand to the right and downward.
0
 
ACUIWebDeveloperAuthor Commented:
feredun - yes, this is for Dynamics CRM.  If the event just needed a badge, a mail merge would suffice (though my supervisor still wants a report so the registration desk person at the event can just run the report for any last minute arrivals.  That, and we have a couple of larger events that will have tickets to other events included.

planocz - how do I make the matrix repeat by row and by column?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
ACUIWebDeveloperAuthor Commented:
When I try to use a matrix, here is my result...

Matrix
Is there a way to a) line all the names up in one column? and b) hide the first column (the visibility option is grayed out)?
0
 
ACUIWebDeveloperAuthor Commented:
I need to make something like this:

Mock-up
Where each cell contains a collection of fields from a record.  I can make this happen with one column, but I need to make it happen with 2.  What happens now is that the first column is simply duplicated in the second.
0
 
ACUIWebDeveloperAuthor Commented:
Ok, I found 'a' solution.  I created two tables that pulled from the same dataset and set the visibility on the first to hide the even rows and the other, the odd.  I imagine it isn't the cleanest method but it works.
0
 
ACUIWebDeveloperAuthor Commented:
This is not a great way to solve this problem.  In essence I am querying twice and filtering the results based on row number.  I was unable to figure out how to make 2 columns and have each column continue into the next.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now