SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,064 questions
Microsoft Report Builder - Running report pulls inaccurate data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 77%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Greta Shallenberger
1
Reputation point
For a couple of my fields in my report, the data pulled is not correct. For example, a "Time Off Pool" field that should say something along the lines of "Entry_1454732" says something like "ABIRAAAA.wK.pV.u.cHZCM.aSAAA=". Another field populates with a date and just added one day for each subsequent line - which is not accurate to the dates it should be pulling. Is there a way to troubleshoot this? Thanks!
SQL Server Reporting Services
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 17%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI1%3C/text%3E%3C/svg%3E)
Isabellaz-1451 3,616 Reputation points2022-03-09T02:29:50.907+00:00 Hi @Greta Shallenberger
When you run the query statement on SSMS， how is the data look like？
Sign in to comment
5 answers
Sort by: Most helpful
-
-
Greta Shallenberger 1 Reputation point
2022-03-09T13:43:47.38+00:00 Here's how it looks! ^
-
Greta Shallenberger 1 Reputation point
2022-03-09T13:44:25.497+00:00 Time Off Pool and Pool Name should be quite similar.
-
Olaf Helper 47,441 Reputation points2022-03-10T08:27:35.833+00:00 the data pulled is not correct.
The you pull the data the wrong way.
"ABIRAAAA.wK.pV.u.cHZCM.aSAAA="
Looks like Base64 encoded data. Is the data source a web service/XML/SOAP?
-
Greta Shallenberger 1 Reputation point
2022-03-15T12:44:48.057+00:00 That is correct- it's from a web service. My company uses an online scheduling software called Verint and I connect to the data using a link they gave us.
-
Isabellaz-1451 3,616 Reputation points
2022-03-16T02:09:55.707+00:00 Then I guess you can ask Verint give you the correct data. The report builder will show what you give it，if the given data is wrong ，it will be wrong.
Best Regards,
Isabella -
Greta Shallenberger 1 Reputation point
2022-03-16T12:34:50.89+00:00 Thank you!
Sign in to comment -
-
Isabellaz-1451 3,616 Reputation points
2022-03-17T03:40:10.747+00:00 Then I guess you can ask Verint give you the correct data. The report builder will show what you give it，if the given data is wrong ，it will be wrong.
Best Regards,
Isabella
If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.-
Isabellaz-1451 3,616 Reputation points
2022-03-17T03:40:59.87+00:00 Hi @Greta Shallenberger
If the answer helps you ， could you please mark my answer as accept，I really appreciate it，thank you.
Sign in to comment -