Viewing 15 posts - 796 through 810 (of 2,010 total)
You'll need some sort of outter join to the tally table. Jeff talks a bit about this in the Dozens of Other Uses section of his article on Tally...
July 7, 2009 at 1:38 pm
Is the issue that you're not see the 11/13-11/15 columns at all?
You won't because they don't exist in your data. There is no way to display data that does...
July 7, 2009 at 1:32 pm
Is there any chance you could post your .RDL File?
I modified your test data a bit so that I could use it directly within SSRS (it didn't like all of...
July 7, 2009 at 12:37 pm
Since you are using the MAtrix I'm almost positive these records are being removed by your grouping. Not in the query mind you but in your Matrix.
Please...
July 7, 2009 at 10:48 am
More than likely the issue is that when the PC was renamed/added to the client domain, any credentials that the SQL server Services were using have now become invalidated. ...
July 7, 2009 at 10:38 am
Please do not cross post. This duplicates efforts and fragments replies and data needed to actually answer your question.
More data requested here.
Thanks
-Luke.
July 7, 2009 at 9:21 am
Could you please provide a bit more detail? In which type of report object are you trying to display this information, Matrix, Table, List? Are you doing any...
July 7, 2009 at 9:16 am
The user is directly accessing the database by the very nature of the datasource connection that you have specified. The report server is authenticating to the database using an...
July 1, 2009 at 9:08 am
Thanks for posting the datasource definition. I take it that you are using SSRS 2000 because of the definition you posted. Either way it seems you are using...
July 1, 2009 at 8:20 am
The reports use a dataset to connect to some sort of datasource. Do the reports all use the same datasource? The datasource definition should contain the connection information....
June 30, 2009 at 8:42 pm
How is the data source security set up? are you passing your user's credentials through to the database server or are you using a single set of credentials for...
June 30, 2009 at 1:04 pm
It depends on the order that the parameters are loaded or populated. SSRS gets handles the params strangely sometimes.
-Luke.
June 22, 2009 at 7:09 pm
Glad to help out. Sometimes it just takes an extra set of eyes.
Cheers,
-Luke.
June 22, 2009 at 7:04 pm
Jeff Moden (6/20/2009)
Paul White (6/19/2009)
Jeff Moden (6/19/2009)
Heh... cool... maybe a little head boiling will get him to fix the code windows for IE? 😛I admire your persistence.
And your optimism!
😛
......
June 20, 2009 at 7:37 pm
Viewing 15 posts - 796 through 810 (of 2,010 total)