set space in report on runtime

Question

1.00/5 (2 votes)

See more:

I am creating a microsoft report of rdlc type and design a list and i want that on runtime,I set report margins and add columns and space between columns on the basis of user's value in windows application.I tried a lot and i want to print 5*4 size labels.and 9 or 12 per page

Thanks in advance

Posted 15-May-11 6:09am

geetajain

Updated 16-May-11 3:00am

v2

Add a Solution

Comments

Abhinav S 15-May-11 12:31pm

Have you tried something so far? mentioning this will help others help you

Sandeep Mewara 15-May-11 13:04pm

What report? Crystal, SSRS, other? A little more details on effort made please.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rob Branaghan · Answer 1 · 2011-05-16T22:20:00

What I have done in the past is add a parameter that is

@StartAtLabel

You need to make sure you validate that a user cannot tell it to start at a label higher than the total of labels per page.

Then you have a report that contains a list, 2 columns set on the report.

In the sql part you add a UNION ALL to a select statement that will select blank records (or "####") for each one of the labels you tell it to miss, and then if the textbox value == "####" then you dont show the values.
This will then have the label start at the position because the report will fill in the rest of the values with blanks, and will not print in those places.

The hard part is designing the report to work based on label size.
Its usually a lot easier to create a new report PER label size.

I suppose if you wanted to you could set the margins and columns via parameters as well.