Multicolumn Reports in RDLC…eeeasy, maaaaan!
Hi guys,
I’ve been (and I still am) very busy in these days, due to a BIG go-live on 1st January…and I admit that writing about NAV is not so enjoying after you work with it for 6 days a week and about 9-10 hours a day. I just need to rest a bit on sundays and to keep in touch with friends and other people, you know? It’s called social life
anyway, i’ve 3 topics i want to blog about and i am trying find some time here and there to write them.
this one is the shorter, but it’s very useful!
I’m talking about muli column reports, which are a bit painful and boring to design in classic client, because you have to evaluate 2-3 records in a single section (doing some “risky” NEXT in onaftergetrecord, create some array variables and evaluate them)…ok, I don’t want to blog about CLASSIC multicolumn reports, you can find how to design them anywhere in mibuso.
with rdlc, the whole story is actually faaaar-mooore-eaaasy. I don’t even need screenshots to explain it:
1. create a new report in classic (through wizard is fine) on customer table, and add the number and the name in the body section.
2. convert it with the create layout suggestion
2a. (optional) save and run it: you’ll see a plain list of customer numbers and names…nothing more
2b. if you did 2a, go back to the rdlc designer
3. click on the white space of the rdlc designer, find the “columns” property and select “2″ (or three, or four…whatever you like)
4. resize the white page and you’ll see a new column appear
5. adjust column spacing and size properties as you prefer
6. print the report. Nice huh?
I think this is a well known trick for the rdlc developers, but as a nav developer, i’ve never seen this anywhere on the communities/blogs i usually read. Enjoy!
December 19th, 2011 at 8:42 am
I still haven’t look for a way to span data from left to right (in an easy way). That means that your data will span top-bottom for the first column, and then top-bottom for the second column…