Search results for query: *

I am trying to create a query that groups data by week. However the week should be Saturday to Friday. Any ideas how I should convert my date to Friday and then I can group/sum my data based on that date. Thanks .

I have a page that has drop down list and a user control The user control generate graphs and data grids for web enabled reports. protected void Page_Load(object sender, EventArgs e) { uc_report.sChartType = ddlChartType.SelectedValue; } Inside my UC i...

We are moving one of our database's to a new server. This new server is SQL 2008 64bit, and the old was 2005 64bit. Here is the error I am getting when I try to execute the package from Mgt Studio. [Destination 1 - DDRAbbreviations [147]] Error: SSIS Error Code...

Is it possible to color the header row of a cross tab a color. I know you can set the background of the text in the header, but the color does not extend to the borders. Is it possible to get the whole header cell colored? Thanks,

Hey Everyone, I have a cross tab that has Jan-Dec as the column headers and years as the rows. However, my data comes back with Jan 2011-Mar-2012. But Apr-Dec 2012 still show zeros. I do not want to suppress zeros, because I could have real zero values in my data. I only want to suppress...

I have a set of crystal reports that are hitting a production database, and they seem to be causing some performance issues to that production system. Is there way in Crystal Reports Server 2008 to limit a report so it can only be run during off hours? say 6pm-6am?

Is there any trick to getting the parenthesis in your select expert match in the SQL that crystal generates. I am using this in my select expert, but the SQL that crystal comes up the parens are way off and not using my left join. (({%Fee_Effective} < datadate) AND ((isnull({%Fee_Expiration}))...

I have the following stored procedure... CREATE PROCEDURE [dbo].[Quicksilver_Get_Charges_Pmts_Adj_Amt] ( @sSiteType varchar(5) ,@sState varchar(5) ,@sStartMonth varchar(6) ,@sEndMonth varchar(6) ,@sLOB varchar(50) ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets...

I have a report that contains several different date fields. I would like to get the user the ability to choose which date field the date parameter selects from. What would be the best way to do this? Thanks,

Has anyone else had this same issue with Crystal pulling up the list of tables in an oracle database. http://www.toadworld.com/BLOGS/tabid/67/EntryId/135/Toad-Sometimes-Slow-on-Oracle-10g.aspx Ever since our vendor upgraded to 10g it takes 8-15 minutes to pull up the list of tables.

Is there a way to use a parameter that allows multiple, to be using in a SQL Command? Any tricks to allow one or many into a SQL Command.

Is there a limit on the size that a SQL command can be. I have two SQL queries that I am using a UNION ALL to join together. Right now its at 100 lines. Each side of the query works fine, but when I put them together it looks as if its only running part of it. I cant create a view/stored...

I have this large command that pulls from our Oracle Database. When I run the query in SQL+ against the production and backup database, I get results returned. However, when I try to run the query through crystal, no results are returned. Any ideas? SELECT T1.CPCODE "Group_Num"...

I have a formula in a report and even though I have removed it from everywhere in the design view, it is still marked with a check box that it is used in the report. I can not delete this formula as Crystal thinks it is used somewhere. This has happened a few times before and I have rebuilt...

Do you know if it is possible to create a link from an external program or website to a report or folder on the crystal reports server. We have lots of little apps that have run crystal reports, but that requires us to distribute crystal dlls to the client and is becoming a bit difficult. It...

I have tried the techniques used in these 2 articles. http://kenhamady.com/cru/archives/39 http://kenhamady.com/cru/archives/335 My subreport is in one of my group headers. While the trick from these articles works when you are viewing the report in Crystal, when you Export to Excel Data...

Hello Everyone, I have a report that pulls data from a Stored Procedure in SQL 2005 Server. We have updated the logic in this procedure, but the report does not see this change. I can create a new report that pulls this stored procedure and it pulls the data just fine. I would be tough to...

Is there an easy want to vertically align a bunch of fields to the center of a details section? Or if I set the height of a object to vertically align the text in that object and then I can do fit section based on the size of that element.

I have a password protected site. On this site there are 2 types of files that I have links to. PDF and TIFF. I have a special Java applet that to view the tiffs and a link to the PDF files. Is there anyway to secure the files so you cant just browse to them if you know the file path and...

Hey Everyone. I have CR9 and 2008 and both are performing the same way with this issue. When I try to connect to my Oracle server, I enter my username/password and it takes 5-10 minutes for the database and table list to come up. This only started happening when the vendor upgraded the...