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...

Works great! Thanks so much!

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...

Thanks so much! worked like a charm! I haven't really needed to use sub-reports as links so I just took the defaults. Looks so much better!

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...

I think your right. I've tested this many ways and this is the best way so far. Thanks so much for your help.

Thanks for your quick response! Is there a way to do this without a parameter? It works except It shows up in the parameters for the users to filter from. Is there a way to create a button the user can click to hide/unhide the pdf? I would like the user to be able to turn this on or off...

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!

Hi LB, I figured it out. I needed to add a calculated field to my query so If it field name like Anes then "Anes" else "Sur". I then created a cascading parameter that if you select "Anes" then it shows the records for "Anes" else it show the records for "Sur". Thanks for your help!

Hi LB, Thanks for the quick response! This works but I would like to take this 1 step further. Using your suggestion I'm getting 2 parameters in the panel. One for {?Sur} and one for {?Anes}. What I would like to do is have only 1 parameter within the panel so if {?Which}="Sur" the only...

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...

Hi LB, Thanks for the quick response! I'm looking for a way to just suppress one label in the group header without using a parameter. The report will need to export to excel using Data-Only and either Typical or Minimal exporting format. Any thought? Thanks!

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!

Hi Ian, Light bulb moment!!!!! I figured it out! I had to create a second command Connection and added a query in this case the Parent Location and OR Location. I then joined the 2 command connections by these fields. Using the second command connection I was then able to create my dynamic...

Hi Ian, It looks like the problem occurs only when using a Dynamic Parameter. I tried all possible ways of creating this. If I create a static parameter the panel appears correctly. For this report I need to use the dynamic parameter since way have many locations/Depts etc. Any Ideas...if...

Thanks for your quick response! I tried your suggestions but didn't work. I started to delete and re-create the parameters that are not within the command and found that one of the parameters seems to be the issue. This parameter is a cascading parameter. I've attached a copy in a word...

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...