Ask Garth
  • Home Page
  • Books
  • Blog
  • NewsLetter
  • Which Right Click Tool are you?
  • Blame Garth
Select Page
Display a Date in a Text Box

Display a Date in a Text Box

by Garth Jones | Oct 14, 2020 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

The idea for this blog post was on my list of “things to do” for quite a while. Why? Again, and again, I saw comments such as, “My date is in the wrong format,” and, “I just want the short date, I don’t need the time.” There are numerous ways to solve these problems,...
How to Create a SSRS Date Range Prompt

How to Create a SSRS Date Range Prompt

by Garth Jones | Aug 19, 2020 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

Hi Everyone! In this blog post, I am going to talk more about the SSRS date range prompt epiphany I had after creating my first Power BI date range slicer. In a new Power BI version of a Warranty Information Reporting report, I created a slicer in order for users to...
How to Create a Date Prompt in SSRS

How to Create a Date Prompt in SSRS

by Garth Jones | Aug 5, 2020 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

There is a long story behind why I needed to create a date prompt, but the short story involves some feedback from a customer. The customer wanted to see how often computers check their warranty status with Enhansoft’s Warranty Status API. Now, this blog post is not...
How to Customize SSRS Line Chart Markers

How to Customize SSRS Line Chart Markers

by Garth Jones | Jul 22, 2020 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

Hi All! This is what I call an interesting blog post. All report developers, at one time or another, wish they could customize reports to their own liking. It could be as simple as adding a department name, a project name or a company name to a SQL Server Reporting...
Adding an All Option to Your Prompt

Adding an All Option to Your Prompt

by Garth Jones | Jun 24, 2020 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

In my blog post, Turning Three Reports into One Report, I said that I would show you how to adjust your prompt to allow for an, “All Option.” Everything you need to do is within the SQL Server queries themselves. This blog post shows you how to edit BOTH the prompt...
Enhancing GetColor to add Defined Colors

Enhancing GetColor to add Defined Colors

by Garth Jones | May 13, 2020 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

While creating the videos for the GetColor updates. It dawned on me that I should show you how to Enhancing GetColor to add Defined Colors. To do this, I will show you how to define colors for a particular string value using the GetColor function. DEFINE COLORS Before...
« Older Entries
Next Entries »
  • Privacy Policy
  • Facebook
  • X
  • RSS
Copyright Garth Jones 2003 - 2025
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behaviour or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}
20044