WebJul 19, 2007 · Hi Guys!! I am currently using Crystal Reports XI and using stored procedure from SQL 2005 server. I am using a Datetime data type as my parameter on my stored procedure , since there is no Date data type in SQL 2005, I want to convert my parameter from DateTime to only Date data type in Crystal Reports so the user will … WebCreated Sub reports and added an existing report as a sub report in Crystal Report. Created hyperlinks in Crystal Reports to open a document in BI platform. Extensively used all the functionalities in Crystal Reports like Sort, Group, Hyperlink, Alert, Parameters, Formulas and Conditional Formatting..
Using Stored Procedures to Create Crystal Reports
WebMay 30, 2012 · I have a Crystal 11 report with a parameter.I've added a stored procedure to that report. When I added the stored procedure Crystal added another parameter … WebUsed Crystal Reports to generate ad-hoc reports Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency. Wrote complex stored procedures to process driver’s record and balanced the processing load between front end and back end. small bowel neurofibroma
Using Stored Procedures to Create Crystal Reports
WebFeb 4, 2014 · You will need to manually connect the @enddate parameter in the main report to each one in the subreport--there isn't a wizard or easier way to do this in CR. Steps: right click a subreport. select 'change subreport links...'. select the `@enddate1 parameter from the Available Fields list and move it to the Field to link to list. WebMay 17, 2024 · SQL - Passing a Stored Procedure Variable as a Parameter in a crystal report for end users to select In "parameter fields" under field explorer, select new and … WebJun 16, 2008 · I am having strange problems with my crystal report using a stored proc as the data source. This is the 1st report I build using a stored procedure, and I'm … solvay materials