Victoria Yudin

March 2009 - Posts

• 0 Comments 1,973 Views

  Alternating shading for lines in Crystal Reports Here is a new Crystal Reports tip from the Flexible Solutions GP Reports newsletter . I have added an example with some screenshots to better illustrate. Want to spruce up your Crystal report a little by adding alternate color shading to the lines? Here... Read More... Published: Tuesday, March 31, 2009, 07:00 AM Tags: GP Reports, Crystal Reports

• 0 Comments 1,592 Views

  Changing color scheme for Office 2007 There are many things I love about Office 2007. I think the ribbon is great and I have not only gotten used to it by now, I cannot even remember how to work without it when I am on a computer with an older version of Office. But what I have always wondered... Read More... Published: Monday, March 30, 2009, 05:52 AM Tags: Miscellaneous, Microsoft, Office 2007

• 0 Comments 1,409 Views

  Changing the color scheme for Office 2007 There are many things I love about Office 2007. I think the ribbon is great and I cannot even remember how to work without it when I am on a computer with an older version of Office. But what I have always wondered is who decided that baby blue was the... Read More... Published: Monday, March 30, 2009, 05:52 AM Tags: Miscellaneous, Microsoft, Office 2007

• 0 Comments 1,900 Views

  SQL view with security resource details for Dynamics GP 10 As a corollary to my view showing the Dynamics GP 10.0 security roles and tasks assigned to users , I have created another view that adds the security resource details. Thank you very much to Tim Foster for pointing me to a newsgroup post by David Musgrave... Read More... Published: Friday, March 20, 2009, 07:13 AM Tags: security, GP 10.0, SQL code, Dynamics GP, GP Reports, GP SQL scripts, GP SQL view, GP table information, Crystal Reports, SmartList Builder

• 0 Comments 1,889 Views

  SQL view to show security roles and tasks in Dynamics GP 10 Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic now, so by default no permissions are granted, but setting up and administering security is quite different from what many of us are used to after... Read More... Published: Thursday, March 12, 2009, 12:32 PM Tags: security, GP 10.0, SQL code, Dynamics GP, GP Reports, GP SQL scripts, GP SQL view, Crystal Reports, SmartList Builder

• 1 Comments 1,876 Views

  Searching for strings in SQL Server using LIKE Many times when searching for data in SQL Server we need to search for strings and use wild cards. One common wild card is % . As an example, I am going to use the Customer Master table (RM00101) in the Dynamics GP sample company, Fabrikam, Inc. If I... Read More... Published: Monday, March 02, 2009, 10:38 AM Tags: SQL code, SQL Server, GP SQL scripts