Hello,
I have an SSIS package where I use "Execute SQL Task" to pull back several rows of data which I want to send via an email. After the execute SQL task I use a for loop with a script task. However, I am struggling with the c# code. Most of the videos/help I have seen online use...
Hello,
I am using ASP.NET for a web application. A user picks a product which takes them to another page. The page will display more details on the product as well as a dropdownlist, which allows them to chose a specific size. Once the size is selected the "add to cart" link must be updated to...
Hello,
I need to pull all the users from Active Directory into my win forms application combo box using VB. I set the properties to load "name" and get firstname, last name. However, when users sign into the network the have to type in first letter of firtname and full last name. I am not well...
Hello,
I have created a .NET windows application that exports an XML file. I use the data in this file to populate a Word 2003 document, which has an associated schema. However, whenever I make changes to the schema I find that the elements in the XML structure pane in the Word document are not...
Hello,
I am using Crystal 10 and I have a report that can be viewed 2 different ways depending on user choice. This report must be exportable into Excel. I had to create a fake header in the details section in order to get the column headers to actually export into excel. The problem I am...
Can anyone tell me how I can solve the following problem with SQL built-in functions:
I have a lease that is for $1,000 it has 5 year terms and increases 15% at the start of each new 5 year term. So after the first 5 years it will increase to $1,150. What I need to know is the average annual...
Hello,
I need to find codes in a table. For example:
Code $ Amount
04134 1
4134 4
4134R 5
4134IM 6
I need to take these codes and make them consistent - 4134 and then total the amounts ($16) so I can link it to another table. Is there any way I can accomplish this...
Hi,
I am using Crystal 9.0 and need to export a multi-column report into Word 2000. The report looks fine in Crystal preview mode, but when I export it only the second column is seen and it repeats.
For example:
Crystal Preview:
Columnn A Column B
Crystal Design:
Column A...
Hello,
I created a graphic that shifts from frame 1 to 10 when it is run. However, it repeats itself over and over again. I would like it to move to frame 10 and stop. I am sure it is simple to do, but I cannot figure it out.
Thanks!
M.
I am new to web development. I have stuided the tutorials in Flash mx professional 2004, but not sure how to combine it with the app created in HTML and ASP. What I need to do is just create some visual effects - like when a link is clicked the page slowly transforms into another page,etc...Can...
Hello, I am trying to determine the peak minutes and non-peak minutes between dates. My table is structured as follows:
Date Down Time Down Date Up Time Up
4-14-02 17:00:00 4-15-02 13:00:00
Now my peak minutes are 8:00:00 to 18:59:59 and non-peak are
19:00:00 to...
Can anyone explain to me how to keep my legend from moving?
I went to chart options - General - Look - Layout - and selected Legend Below Chart. However, for some reason it doesn't save the request. When I close the report and re-open and run the legend appears on the left hand side. Do I need a...
Is there anyway I can print my report on only one page. It currently prints out on 2 pages. Part of the problem is that I have a subreport in the header, which is a graph. If I could shrink the graph I think the rest of the report may fit on one page. I am using Crystal 9.0.
Any help would be...
Hello,
I created a simple graph that displays a name and a count. The data comes directly from the db so I don't sum any data in the report. The problem is that all my names must be in the report even if there is no count value. However, in my graph all the names appear even when there is no...
Would anyone know how I would calculate the number of days in a given month excluding Saturdays and Sundays?
I would also like to count the number of Saturdays and Sundays per a given month.
Any help would be greatly appreciated.
M.
Hello,
I am trying to pass a muliple value parameter to my SQL proc and I am not sure how to accomplish this.
What I am trying to do is create a do loop that pulls in every value selected by the user then pass that value with all the approriate quotes, etc...to the proc.
So If the user...
Hi,
I need to find the differene in time for 2 fields. The table is set up as follows:
Field Name Data Type
UpDate varchar (i.e. 2002-04-01)
UpTime varchar (i.e. 22:50:00)
DownDate varchar (i.e. 2002-04-01)
DownTime Varchar (i.e. 22:45:00)
All I want to get is...
Hi,
I have a report that has 3 parameters that allow multiple values. However, it doesn't seem to filter the data correctly. It seems like the report meets each individual condition and not all the conditions as a whole. I am using Crystal 9.0 and this is my formula:
If {?Site Status} =...
Hi,
I concatenate an address in SQL and when I call the data in the ASP page I see all the commas where there is no address. I want to eliminate the commas.
For example:
123 Elm Street, Miami, FL 20333
If there is no adress it shows as:
, ,
on the page.
I am sure this an easy fix, but not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.