Generating/Rendering a PDF from a sql reporting services report – CRM 4

Posted by on Dec 9, 2010 in CRM 4.0, SQL Reporting Services |

sounds simple dosen’t it – my objective is to run an estimate report and render to PDF all from the click of a button as shown in the screenshot below:

Heres the code —

Deploy aspx to CRM ISV folder — create ISV button to call the ASPX page passing the oppID parameter (being the actual opportunityid) to the page.

Read More

This report requires a default or user-defined value for the report parameter ‘Parameter’. To run or subsribe to this report, you must provide a parameter value

Posted by on Dec 9, 2010 in CRM 4.0 |

ahhh sql reports — i mean come on this sounds like a simple parameter problem — however what seems to be the problem here is that in the report i was requesting from sql srs web services for CRM4 — you must define data source credentials with the datasource name being the datasource name on the report!!

then you get this error:

An error has occured during report processing —> Cannot create a connection to data source ‘DataSource1′ —> Guid should contain 32 digits with 4 dashes…

i’m kicking myself at this point saying WTF!!

This error occurs because the Microsoft Dynamics CRM Data Connector for Microsoft SQL Server Reporting Services requires the user’s SystemUserId value as the Log in name and the user’s OrganizationId value as the password (for the datasource credentials)..

When a report runs inside Microsoft Dynamics CRM, these values are passed automatically. These values must be entered manually when the report is run directly from SQL Server Reporting Services.

more info at: http://support.microsoft.com/kb/2006869

Read More

Two quick MySQL tips

Posted by on Oct 4, 2010 in CRM 4.0 |

MySQL: Running a SQL script from the command line:

MySQL: Stopping a long query:

Get the id from the first column then run:

Read More
%d bloggers like this: