Search results for query: *

Hello, I have a main report and a few sub-reports as links. All reports use the same stored procedure. The stored procedure uses start_date and end_date parameters within the stored procedure. what I would like to do is have the user enter the date parameter once for all sub-reports. what...

I have a sql table that contains a field as a varchar (2000). I need to pull a word from that field if it exists. For example: Table/field name is note.text. If the note.text field contains the word 'Education' (this word can be anywhere with the text)then return the word 'Education' Thanks...

Hello, I'm trying to figure out how to add a database field inside the doughnut. I've attached a copy of what I'm trying to accomplish. This is an extremely poor example but I'm short on time. Normally there would be several pie pieces but this will get the point across (i hope). This will...

Hello, I have several sub reports as links and use begin date and end date as parameters which links to the main report. The reports work fine. My question is that when I open the main report to enter the date parameters I get a list of all the sub-reports above the parameter as well as on...

Hello, I have a stored procedure that uses a few temp tables. I have created an SSIS package that executes this stored procedure and exports the end results to a .txt file. The problem I'm having is that I'm not seeing any fields or tables when executing the SSIS package. If I create a sql...

Hello, I'm using SAP Crystal Reports 2016 and have a report that has a pdf embedded in the page footer and is displayed as an Icon. This is needed for the report. Is there a way to suppress or hide this when the user exports this to a pdf or excel as we don't want to print the Icon. Thanks much!

Hello, I'm not sure if this is possible but I have a parameter that you can either select "Anes" or "Sur". What I would like to do is that if "Anes" is selected then show the Parameter {?Anes} and if "Sur" is selected then show {?sur}. I would need to do this within Crystal as a formula etc...

Hello, I have a Dynamic Cascading parameter called @Locations That looks like this: Parent_Location>OR_Department>OR_Location This works fine. I have a Static Parameter called @Group1 that has the values "Surgeon" and "Anesthesiologist" What I would like to do is If the user Selects...

Hello, Is there a way to suppress a label when exporting to excel. I have a group header label that I don't want to export when exporting to excel. Thanks for your help!

Hello, I am using SAP Crystal Reports Version 14.2.4.2410 (2017) I have a query that is used in the the Database Expert Query Command and uses a Start_Date and End_Date for the parameters. I also have a few other parameters that are not used within the query Command. When I prompt for new...

Hello, I'm using SQL Server 2017 and have a table that looks like the below: 1_Start_Time 1_End_Time 2_Start_Time 2_End_Time null null 11:12 11:18 null null 12:35...

Hello, I'm using Crystal XI and have a report that uses a few groupings. Group 1 - Location Group 2 - Sub Location Group 3 - Cards Within Group 3 I have a field called "Last Used Date". Is there a way I can sort on this field within the group without creating another grouping? If I create...

Hello, I'm using SAP Crystal Reports 2013 and It uses a stored procedure in which uses PL SQL. The Crystal reports has a couple of dynamic parameters. I'm using the time to load prompts in crystal repoRecord Selection Formula Eeditor to link the Stored Procedure to the parameters for example...

Hi Everyone, I have a table that looks like: LOG Date Start Stop 522747 12/1/15 0:00 [highlight #A40000]12/1/15 7:40[/highlight] 12/1/15 8:40 509655 12/1/15 0:00 [highlight #4E9A06]12/1/15 8:05[highlight #4E9A06][/highlight][/highlight] [highlight #A40000]12/1/15 8:25[highlight...

Hello, I have data that looks like the following OrderID Lin1Resp(formula field) Line Ord Question 272 1 dog 272 2 yes 272 3 no 273...

I have a stored procedure that looks simular to the below. Create Procedure sp_Customer (@SalesPerson Nvarchar (Max)) Select c.customerID,c.LastName, c.FirstName,c.CompanyName,c.SalesPerson from SalesLT.Customer c where c.SalesPerson in (@SalesPerson) I'm new to Crystal reports and I am...

I have a stored procedure that looks simular to the below. Create Procedure sp_Customer (@SalesPerson Nvarchar (Max)) as Select c.customerID,c.LastName, c.FirstName,c.CompanyName,c.SalesPerson from SalesLT.Customer c where c.SalesPerson in (@SalesPerson) I'm new to Crystal reports and I am...

Hello, Anyone know a sql script that will find all programs installed on a server without using powershell? Thanks for your help!

Hello, I have a main report that uses a multi parameter value. Once the values are chosen the report comes up great and is grouped by the values chosen. This report also has a button that when clicked brings up another report just for the values choses in that group. from the second report I...

I'm very new this and have this java script: ="javascript:void(window.open('http://src-ngreport/Reports/Pages/Report.aspx?ItemPath=%2fQuality_Reporting_1%2fDiabetes_Pg_Two_Quality_By_Provider_Dashboard &rs:Command=render&Rendering_Provider &...