Databases
StackOverflow2013
Postsdbo
POIssue with SQL Server Reporting Services
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIssue with SQL Server Reporting Services
    primarykey
    data
    text
    <p>I'm having an issue with our SQL Reporting Services and I'm hoping, someone, anyone can help me.</p> <p>In our beta environment it appears that newer patients will not have their reports generated. However, if I go further back to some of the older patients, they do get generated. In the development environment it creates the reports without a problem.</p> <p>All stored procedures and data generated are exactly the same. I looked through the logs and nothing seemed to be out of the ordinary. I'm at a complete and total loss on how to debug this.</p> <p>Does anyone have any suggestion on how to debug or see any kind of error or warning generated? </p> <p>I know this bug is vague, but I'm not sure what else I can provide without going into gritty detail. </p> <p><strong>EDIT: Added more details and clarification in response to Jamie F</strong></p> <p>I should note that a report is "generated", but the fields are not filled out. Now, to get more specific...</p> <ul> <li>A patient, or rather a patient ID is the main parameter for the report. There are also 3 medical categories that don't change, two date parameters, and a disease state.</li> <li>Newer patients (patients added to the database most recently) do not fill out the report. Somewhat older patients, fill out a portion. And much older patients fill everything out when available.</li> <li>(If I'm understanding correctly) A report is run upon request, in other words, they're not set to be auto-generated on some sort of schedule.</li> </ul> <p>I have installed <a href="http://www.microsoft.com/bi/en-us/Community/BILabs/Pages/ReportingServicesLogViewer.aspx" rel="nofollow">MS SQL Reporting Services Log Viewer</a> but nothing seemed out of the ordinary there. </p> <p>Like I mentioned above, reports get generated in the development environment, but not for the beta. I'm still at a loss and haven't made much progress since posting this question.</p> <p>The data source is from an SQL server being called with a stored procedure. The data returned for the patients, old or new is pretty much the same. Some dates and values are different, but that in general they look the same.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEmmanuel F
    1. USEmmanuel F
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload