Search results for query: *

Thanks for the reply. This report is a grand total report for hospitals forecast by finclass. I am trying to compare the overall totals for all hospitals. Group1 is the current forecast and Group2 is the previous forecast. I need to also display the differences. The report has a grouping...

I have a report with 2 groupings. Each group has 7 rows and totals. For example I have 1 group with: A, 1000, 1000 B, 2000, 1000 C, 1000, 1000 D, 2000, 2000 Totals, 6000, 5000 Another group with: A, 2000, 3000 B, 3000, 3000 C, 2000, 2000 D, 1000, 2000 Totals, 8000, 10000 What I would then...

No that is not me, but it is the same issue I am having. Thanks for your help.

I'm not using a split axes. My chart has 3 bars and 1 line. I just need to change the size of the markers on the line. I tried to create a line chart and change 3 of the series to a bar, but Crystal places the bars on top of each other. Any other ideas?

I am using Crystal 2008. I've created a bar chart and changed on of the series to a line. Is it possible to remove the markers or change the size of them?

I was trying to use the dynamic sql in my original post instead of having a dozen sql statements with the only difference being the variable and one line in the WHERE. Since I couldn't get it to work I went ahead and copied the SELECT and made the change.

Attached is one of the procedures I am trying to change. I haven't put the code I posted in, but you should be able to tell what I am trying to do. ALTER PROCEDURE RapidReport_YTD_By_Site(@Month int, @Year int, @Site varchar(10)) as SET NOCOUNT ON DECLARE @sSite_Num varchar(10) DECLARE...

I am trying to create a stored proc with a dynamic sql statement. What I am trying to accomplish is passing the count(*) to a integer variable. Below is my sql. The @iPul is returning NULL. How should I change this so I can get the value in @iPul? SET @SQLFromWhere = ' FROM P LEFT Join S...

I am using VB6 and have Lead Tools Raster Imaging 13 . I have never used lead tools and would like to create a tif file from VB. The tif page is an audit form that will have a table layout at the top with data pulled from our database and the rest of the page will have checkboxes. I will...

I got it to work. All I did was add the following before I add the parameters. Report.ParameterFields(1).ClearCurrentValueAndRange Thanks guys for your help.

Forgot to add that these are currently emailed to the physicians, but next month they will be accessing a portal to view their individual report.

Unfortunately, these need to be separate pdfs. It is a physician report that accepts physician ids.

Opening and closing the report everytime I want to change the parameter seems inefficient.

I do want to run it just once. I have 1 rpt file and this report accepts a doctor id. I have about 50 ids that I need to run this report with. Each one of these reports needs to be exported to a pdf file. Is it possible to pass the parameters to the report without doing OpenReport everytime?

I have an app that opens a crystal report, sets the login info, passes the parameter, then exports the report. Below is part of the code I am using. I need to run this report multiple times with new parameter values. How can this be accomplished without doing OpenReport everytime? Dim Report...

I wrote a script to query up about 50 ids. Loop thru them and open up the crystal report and pass the ids then export it to pdf format. I have 2 questions. 1. Instead of doing the below statements each time is it possible to do a refresh? Set Report = crxApplication.OpenReport("test.rpt"...