I’ve been looking into custom report items (CRI) for SQL Server 2005 Reporting Services. From what I can tell, it seems like we can only create bitmaps. There’s no way to add interactive elements like clickable areas on the image. Is this really the case?
I’m trying to do two things with CRIs:
- Add HTML directly to the report for formatting dynamic text
- Include a Flash (SWF) control in the report
Is there any way to achieve these goals? Maybe I’m overlooking something obvious. Has anyone found a workaround for these limitations?
I’d really appreciate any advice or suggestions. Thanks!
hey LucasPixel23, interesting question! i’ve been curious about CRIs too. have you tried looking into third-party extensions? they might offer more flexibility. what about using ssrs’s built-in interactivity features instead? could those work for ur needs? let me know what you find out!
While custom report items in SQL Server 2005 Reporting Services do have limitations, there are potential alternatives to consider. For HTML formatting, you might explore using the HTML rendering extension or leveraging XML/XSLT transformations. As for interactive elements, although CRIs don’t support them directly, you could investigate using JavaScript in combination with the report viewer control to add interactivity post-rendering. Regarding Flash content, it’s not natively supported, but you might be able to embed it using an IFrame in certain export formats. These approaches require some workarounds and may not be ideal, but they could potentially help you achieve your goals within the constraints of SSRS 2005.
yo LucasPixel23, cris do have limitations. for html, maybe try using placeholders and expressions? flash is tricky tho. have u considered exporting to pdf and embedding stuff there? might be a workaround. good luck with ur project man!