Search results for query: *

Hello, I have a Commissions report that I'm trying to finish but there is one final percentage that I'm having trouble with. Groups in the report: Group#1: Region Group#2: EmployeeName Group#3: SiteName All employees only work in one region, but there are times when one employee works at...

Hello, I'm not all that experienced with Crystal formulas, and have a parameter issue I can't figure out. I have the report working perfectly, and this parameter is the last step. I have a field in the report called "Terminal" that has almost a hundred different values, but here are examples...

Hello, I'm not even sure if this is possible, but I have two seperate reports right now that I need to make one. I don't work with subreports much but when I do, I normally put them in the main report footer, so that the subreport will just appear at the end of the main report. The reports...

I'm not sure how (or if it's possible) to concatenate the data in the way that I need it. Here's a sample of my data: Service1 Serivce 2 Service 3 Code Date NULL TS NULL 05S6 2011-01-09 00:00:00 FS NULL NULL 05S6 2011-01-09 00:00:00...

I have a table that I need to select the correct location numbers from but I can't seem to select the right numbers that I need. The location number is always the last number after all of the zeros to the right of it. For example, if in my table it reads "0000000004" then the location number...

Hello, I have the follwing code that I'm using to renam a text file, which works fine: My.Computer.FileSystem.RenameFile("d:\FTP\Void\Unsubs\Test\CW_EmailUnsubs022912.txt", "EmailUnsubs.txt") My problem is that the file that I need to rename ("CW_EmailUnsubs022912.txt") always has the date...

Hello, I have a stored procedure using a linked server that keeps returning a syntax error near the INSERT part of the statment - could someone please look it over and let me know. I've ran the actual query and it works just fine, but after I added the following code It's not working. I just...

Hello, I'm not sure what the best way to go about doing this would be, so I was hopinh for some suggestions of syntax I could use to get the correct date. I have a date column with five digit numbers, the two last numbers represent the month, and the first three numbers represent the year...

Hello, One of our users is having a problem with Oracle/ADI and excel. It seems to me like it's some sort of Excel issue, but I'm not too familar with Oracle so I'm really not sure at all. When the user tries to run Report Manager from Oracle, instead of a report showing up, a blank excel...

Hello, I have a report with a "Total" column that is a running total based on a formula, and the "Grand Total" is also a running total based on a formula. Basically, the report lists employees from a certain location, and the total number of a specific item that was sold by them. I have three...

I am trying to change the color of the menu bars (top menu bar, and left side navigation bar) to match the color of the Site Actions bar at the top. I was able to find a matching color(SiteSettings > SiteTheme) and applied the new site theme to our site, but now the SiteActions menu is the...

Hello, I'm using Crystal Reports XI, and I'm having what I hope is a simply enough problem with formatting. I have a pretty basic report, with the names of employees, and the counts of products that they've sold. I have three headers: Region(GH#1), SiteName (GH#2), and EmplyeeName (GH#3). Here...

Hello, I have a report (using Crystal XI) that has two groups, region (Group#1) and Sitename(Group #2). The data source is a stored procedure in SQL server. Here is a sample of what the report looks like: Southern Region Wash Lube Site #1 2,122 325 Site #2...

Hello, I'm trying to modify the master page so that I have two navigation sections. Right now it's just the default one block on the left where we can add headings and links. Ideally what I want is two blocks on the left, separated by just a small space between the two, but even keeping the...

Hello, I'm new to VB and have a pretty simple task that I need some help with. I'm building a visual studio DTSX package and I need to create new text files from scratch, and name them with today's date minus 7 days. So here's the code I have for creating a new text file, which works fine...

Hello, I'm new to VB and have a pretty simple task that I need some help with. I'm building a visual studio DTSX package and I need to create new text files from scratch, and name them with today's date minus 7 days. So here's the code I have for creating a new text file, which works fine...

Hello, I have a Visual Studio 2005 dtsx package that I created and then imported to SQL Server Agent as a job that is scheduled to run daily. The package basically executes sveral stored procedures (in SQL server mgmt studio) that populate a CUSTOMER table and a TRANSACTIONS table. Then it...

Hello, I have a Visual Studio 2005 dtsx package that I created and then imported to SQL Server Agent as a job that is scheduled to run daily. The package basically executes sveral stored procedures (in SQL server mgmt studio) that populate a CUSTOMER table and a TRANSACTIONS table. Then it...

Hello, I've never set up this type of job (Operating Sytem (CmdExec)) so I'm completely lost when it comes to the syntax. We have several other jobs that run this type of step, and I'm following the same syntax, but it's not working for me. All I need to do is execute a Windows command script...

Hello, I have a report that is created in Crysal XI, and we upload it to BusinessObjects InfoView. On InfoView there's no option to export it as CSV, so what I'm doing is exporting it as an "excel data only," then saving it from excel as CSV. As a CSV, I open it in Notepad, and here is a...