So this afternoon, as we're going our customer a demo of their system ( of course ), we noticed that two of our reports had magically disconnected themselves from their data sources.
I have no idea how this happened, but when you ran the report, you got an SRS error mentioning an invalid the data source or something.
Editing the reports via http://crm/reports (report, properties, data sources ) allowed me to reconnect the report to a pre-defined, shared system datasource and things were back to normal.
What I find alarming is the fact that these two reports have not been touched since Feb 23rd and we've made no configuration changes regarding reporting services or anything.
Anyway, if this happens to you, just go reset the data source connection and you should be back in business.
Oh, this is SRS 2000.
Later, Mitch
So, I've had 5 hours of marginal sleep, I'm neck deep in CRM and SQL Reporting Services development and customization, and the weather here in Dallas is just wonderful today.
But I'm stuck inside typing my life away and all that I can think about is, "It sure would be a good day to run away and join the circus."
If only it were so easy…..
If you are working with SRS and need to combine two CRM fields together, but having each on its own line, use the following expression:
=Fields!ShipToName.Value & vbCRLF & Fields!ShipToAddress.Value
vbCRLF is a special system constant that contains the values of carriage return and line feed characters.
Loading ...
