2012년 8월 21일 화요일 오후 4:38
Hey guys, been searching and reading and just keep getting lost, so I'm throwing this out to the world to see where I can get.
I'm working on a MS Publisher document for company birthday cards. What I'm trying to do next is query SQL to get a list of employees with a birth date withing a date range. The date range comes from user input when the Publisher document is open. The user input has already been coded and validated, the problem I'm having is connecting to the SQL db, query it, and then turn the results into the mail merge recipient list so the user can then print all of the cards automatically.
Hopefully that's enough info and hopefully I posted this in the right forum.
2012년 8월 21일 화요일 오후 6:17중재자
For the first problem (query itself) check
For the second problem I think this blog may help
For every expert, there is an equal and opposite expert. - Becker's Law
- 답변으로 표시됨 speedman_2001 2012년 8월 22일 수요일 오후 7:01
2012년 8월 21일 화요일 오후 7:37
Sorry, should have specified I was good on the SQL query, just getting the data to where I can use it was where I was thrown off.
Thank you very much for the SSRS link, it looks like I can adapt that, but I am very green on SSRS. I have the report so it shows the information I want on separate pages for each employee. The problem I can see happening is this:
Basically our vendor is giving us customized birthday cards with our logos & static information. The names are dynamic and will come from printing the SSRS report on top of the cards. The issue is going to be the size of the name as I have a limited amount of space for the name to appear. Is it possible to create the text box as the article you linked shows but have the text size dynamically change so it fills but does not exceed the width of the text box?
Beyond that it looks like it will work perfectly and thank you for the response.
2012년 8월 22일 수요일 오후 7:02
By george I think I have it!
Thanks Naomi for pointing me in the right direction, it's doing exactly what I need now.