database errors: time

Showing posts with label time. Show all posts

Sunday, March 25, 2012

Crystal v9 and SQL stored procedure

I am having a heck of time doing what seems to should be simple. I have a stored Procedure (SQL Server) with one parameter that returns a records set. When I put this into a Crystal ver 9 report it prompts me for the param and produces the report. When I use this report as a subreport in a main report and link a value value from the main report to the subreport param (which is the SQL Stored Procedure param) I get a blank report.

Any clues?

I then decided that I would have the main report run the stored procedure and change the stored procedure to write a table of the result set into the database; I could not manage this as the crystal reports returns the succinct but cryptic 'not allowed when I try to write the table'. (When running this in the query analyzer, it generates the new table as expected).

If you can help it would be greatly appreciated.As a followup to my previous post, I found that if I changed the stored procedure so that it inserted the records into an existing table (as opposed to creating a new table and inserting the data) then the crystal reports interface successfully executed the stored procedure so it was hanging up on the create table part of the process. Can someone tell me if its possile (and if so how) to change the call from crystal reports so that it is permitted to create a table. The same user id and db login executes the create table correctly from QUery Analyzer.|||Not exactly know how to do it in SQL Server. But in Oracle, we can use object type to return
the record from stored procedure and call it from CR.
Other way is, to call this stored procedure from your program and save the result in text delimited
file, then load this file to CR...Just an idea.

Thursday, March 22, 2012

Crystal reports grouping time stamps by hour

I made a report in crystal reports and its cross tabbed with Times on top, what i need to do is be able to group the times by hour but I have no clue how to do that

right now it looks like this:

8:01 8:11 8:15 8:45 9:15 9:34 and so on

it needs to be like this
8:00 9:00 and so on having everything in the 8-9 range under 8 and 9-10 under 9 and so on

I am using a Ms sql database and taking info from a number field numbers are in the format 800 for 8 oclock 930 for 9 thirty and so on

how would I group them like thisI'm not sure whether this folg is a right solution. but it'll work.

Try to create a formula and check the numeric value. Form a group using code
Like

If {table.field} in [800 to 830] then
1
else if {table.field} in [831 to 900] then
2
etc

Then group the report using this formula. To display the time interval create one more formula. Refer the previous formula here

i.e
if {@.prev} = 1 then
"8.00 - 8.30"
etc

Hope this will work.|||Thanx I will try that out,

Tuesday, March 20, 2012

Crystal Reports - Verifying Database

Crystal Reports - Refresh Problems

Using VB6. New to Crystal. Our app opens a report and shows it. When
we change the underlying database, every time the report is viewed,
even if no fields that affect the report are changed, report was not
opening at all. im calling report from my VB application with few
parameters.

When im opening the report manually from Report Designer (8.5 Dev
edition) and using the option VERIFY DATABASE, its showing the message
("The database is now up to date"). and report working properly and
update info is ther in reports.

How can I get Crystal to just do it automatically? How can I do it in
code so end users see their reports despite changes in the database?

(i'm using VB 6.0, Ms Access 2000 and Crystal Report 8.5 Dev edition)Hi Sekhars

try this out
1. set the database property at form load event.
CrystalReport1.Database(0)="C:\mydb.mdb"
CrystalReport1.ReportFilename="c:\Report.rpt"

2, On the button_Click event
CrystalReport.Action=1

Try this out if it works rate me|||Hi Fundooo,

I'm using crystal report control to call my report created seperatly in report designer. im calling my report from vb application.

in your reply you suggested to use as below

crystalreport1.database(0) = "c:\mydb\test.mdb"
crystalreport1.reportfilename = "C:\myrept\test.rpt"

but im not able get DATABASE method, crystalreport1.database not working with me..... saying "AUTOMATION FAILED/ NOT SUPPORTED" -

still im fighting with this problem.....

regards
Sekhar|||do you know how to declare and instantiate a report object in VB??
eg in general declarations at top of form code area:
Dim objPrintApp As CRAXDRT.Application
Dim objReport As CRAXDRT.Report

and then, in a sub or function:
Set objPrintApp = New CRAXDRT.Application
Set objReport = objPrintApp.OpenReport(strReportSourcePath & strSourceFile)

If you're getting an automation error, you probably haven't done your declare and instantiation properly.

dave|||This is my Code
-------

Rem Reference to Crystal Report Object.
Rem DDReport = Crystal Report Object Name
Rem All required properties are set to DDReport object.

Private sub CmdPrt_Click()

On Error GoTo errhand

DDReport.ReportFileName = "c:\Reports\DDRpt.rpt"
DDReport.PrintReport
DDFavList = False
Unload Me
Exit Sub
errhand:
DDFavList = False
MsgBox Err.Description, vbInformation, "Error"
Exit Sub
end sub

Monday, March 19, 2012

Crystal report takes lot of time to display

hi k. babu
i hopes that u will solve my problem
i am ketan kshirsagar working on the some project
i am facing the problem at the time displaying data in crystal report.
i am fetching data from sql table t display the data in crystal report vrsion 4.5
it contains more than 3 lakhs records and crystal report will take more than half an hour to display it .what should i do to reduce the time to display these records?
please help me

regards
ketanYou should limit the records that are shown in the report
Did you use index for the key column in that table?
How many users are using your project?

Crystal REport run time error 6 over flow

In win98 se..i get run time error 6 over flow..when i try to open crystal report through a vb application on the client machine...i try to isolate the problem..what i found is that while displaying images..there is no problem..integers no problem but when data in string format (for example product name) is put onto the report..it prompts this error...the applicaiton works fine on xp..i dont know how to fix this problem..could any one please help meCheck if there are any viruses on that system
What does that string look like?
Does it have special characters?

Sunday, March 11, 2012

Crystal Report long response time

Hi

We are using Seagate Crystal Report 8 and there is a typical problem if we open the report using Designers it takes 4 mins else from outside it is populated in 30 secs. The report is taking data from view that returns apprx 12k records but by giving filter condition it returns in 2 secs. What can be the exact causes.

Thanks
AnkurHi ,as there are 12k records, it takes more time to print all 12k records when you open the report using designers. But when calling from VB, you might filter the records which returned minimum records. So it took minimum time to print.

Madhivanan

Crystal Report issue - passing text value in vb to crystal

I have a date time picker for begin date and end date to generate my report. I want the begin date and end date selected in my VB App to show on my crystal report as a selected date range. For example, I want my report header to show something like this:

Date Range: 12/14/06 - 12/31/06

This is most likely an easy solution, but I am new to Crystal. What would be the proper way to do this?Figured this one out.....|||How do you resolved this, can you put your code here?

Crystal report in VB

Hello,

THis is my first time using crystal report and VB6.
Can someone give me some examples on how should I do to preview the report built in crystal report in VB6? After preview, I want to print it out too, using VB.
I found something in the internet that I should use the crystal report control, but I still don't know how to display it...

Cheers!

ClaudiHi,
You can very well use the crystal report control. kindly follow the steps to view crystal report using VB 6.0

1. Open a vb application (Standard EXE).
2. go to Project Menu->components
3. in components list box, get the crystal32.ocx control to add that.
4. design a report using crystal report.
5. then follow the code to view the report from VB.

public sub cmdViewReport_Click()
With
.reportfile=app.path & "\MyReport.rpt"
.WindowTitle = "Report Output"
.WindowState = crptMaximized
.WindowShowGroupTree = True
.WindowShowPrintSetupBtn = True
.WindowShowSearchBtn = True
.Action = 1
End With
End Sub

Hope, this will help....

Regards

Deepak

Crystal Report high time taking to load:

In my application , crystal report taking too much time. My Report have more than 50,000 records to display. Report not showing first page untill it receives data of total 50000 records. After reciving total records from database then it is showing first page. It is taking more than 10 mins time. How to solve this problem?Hi. . .

I too have the same problem. My report contains more than 100 pages and it's taking quite a long time to display the report.

Is there any way we can start displaying the report as soon page1 gets filled with the required data??

Any hep pls!!

Thank you all.|||I'm not sure I have the answer but here area couple of things you can check.
Are you using page number or page N of M? If you are using N of M the first page can not be displayed until the last page has been calculated so it can display the total number of pages in N of M.

Are you using indexed fields for your table joins?

Do you have "perform grouping on Server" and "use indexes on server for speed" checked in the oprtions?

Does the SQL for your report have a where clause? If not, the processing can not be pushed to the server.

Good luck and I hope this helps a little.

Thursday, March 8, 2012

Crystal Report 9 suppress difficulty

Hi, I don't know how too :

- print the same report 5 time but with different header on each copy

- suppress the "insert box" and the "insert text objet" with the parameter field I know how too suppress the"insert text objet" with the parameter field but not the "insert box"

can you help me please

thanksIs the header selection based on an input parameter? You could create 5 header sections and use a parameter to select or suppress the header sections accordingly.

I don't think you can suppress a box. My only suggestion is to do as above, create the section twice, one with box, one without, and then suppress an entire section instead of trying to suppress the box.

Saturday, February 25, 2012

Cryatal Viewer

I need to test if the user had clicked the print button on the crystal viewer in my design (not in run time) this button is disable how can I by code know if the user had clicked this button on any else button of the crystal reportLet me get this straight...

You want to determine if the Crystal Viewer was clicked in design time

Do you want to add custome events to any of those controls
I can't see why you want to do this, they already have functionality, they already function as they should :confused:

Or..

You can in any case loop through the Form's controls, determine if the current control is a
CrystalDecisions.Windows.Forms.PageView then loop further through that container to (for example) change the caption of the Tabpage.

Can you explain your problem a bit more please!|||I need to know when he clicked the print button I need to know if he choosed to print as Landscape or portrait

Crump Links

I would like to add crump links feature to my drill down reports. Anybody has
an lead on this ?
Thanks for your time in advance.What are crump links?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Rajan" <Rajan@.discussions.microsoft.com> wrote in message
news:A5B7EC27-2C15-4589-AA2F-E13CEC1D3BC4@.microsoft.com...
>I would like to add crump links feature to my drill down reports. Anybody
>has
> an lead on this ?
> Thanks for your time in advance.|||i have a drill down report which is going to five level. I would like to give
a link how the drill down came all the way, so that by clicking the link user
can straightaway go to the drill down level say from 5 directly to level 3.
Normally we can see this type of links in sites. somethink like the following
one
MSDN Home > MSDN Library > Development Tools and Languages > Visual
Studio .NET > Visual Basic and Visual C# > Reference > Visual Basic
Language > Visual Basic Language and Run-Time Reference > Functions > S-Z
Functions
Hope i had made u understand. If not please give me a buzz.
"Jeff A. Stucker" wrote:
> What are crump links?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Rajan" <Rajan@.discussions.microsoft.com> wrote in message
> news:A5B7EC27-2C15-4589-AA2F-E13CEC1D3BC4@.microsoft.com...
> >I would like to add crump links feature to my drill down reports. Anybody
> >has
> > an lead on this ?
> >
> > Thanks for your time in advance.
>
>

Friday, February 24, 2012

crosstab and time values

Hello! I'm new to Reporting Services and cross-tab reporting in
general. I
need to create a report that has days (dynamic cols) and a wait time
col (static) and across the top and categories down the left.
Visually I need to see:
Day 1 Day 2 Total
Wait Time Col2 | Wait Time Col2 | Wait Time Col2
______________________________________________________
Cat1 00:05:00 10 | 00:10:00 5 | 00:15:00
15
Cat2 00:07:00 13 | 00:13:00 8 | 00:20:00
21
______________________________________________________
Total 00:13:00 23 | 00:23:00 13
Is it possible to apply an aggregate function to a time value? If yes,
how?
Can someone point me in the right direction?
Thanks in advance.I forgot to say: i=B4m using reporting services 2000 SP2. I really nedd
help!|||I forgot to say - I=B4m using reporting services 2000 SP2. I really need
help!|||You need to use a matrix to achieve this, instead of a table.
Then have categories as row groups and days as column groups.
Add subtotals to both groups to have the totals.
Add a static column to the data field to have your Col2s.
Matrixes can be a bit confusing at first, but this is definately the control
you need to use.
Kaisa M. Lindahl Lervik
"kaustika" <rosa.cunha@.gmail.com> wrote in message
news:1158867347.399372.184490@.i42g2000cwa.googlegroups.com...
> Hello! I'm new to Reporting Services and cross-tab reporting in
> general. I
> need to create a report that has days (dynamic cols) and a wait time
> col (static) and across the top and categories down the left.
> Visually I need to see:
> Day 1 Day 2 Total
> Wait Time Col2 | Wait Time Col2 | Wait Time Col2
> ______________________________________________________
> Cat1 00:05:00 10 | 00:10:00 5 | 00:15:00
> 15
> Cat2 00:07:00 13 | 00:13:00 8 | 00:20:00
> 21
> ______________________________________________________
> Total 00:13:00 23 | 00:23:00 13
> Is it possible to apply an aggregate function to a time value? If yes,
> how?
> Can someone point me in the right direction?
> Thanks in advance.
>|||I think I didn=B4t explain myself very well.
My doubts are: IN A CROSSTAB static column: (i) is it possible to put
time values? (ii) The sql query must return what? A double, an integer
or a datetime? (iii) And how to apply an aggregate function (SUM, AVG,
MAX, MIN) to a time value?
Thanks in advance.

Sunday, February 19, 2012

Cross tab stored procedure

Hi
I have a table with rows of timestamped values for given variables. Each of the variables are periodically inserted at the same time. ie
DateTime Variable Value.
T1 V1 xxxx
T1 V2 xxxx
T1 V3 xxxx
T2 V1 yyyy
T2 V2 yyyy
T2 V3 yyyy
In a SQLserver stored procedure I would like to insert this data into a temp table like the following. I don't need summaries just need a table or query where I can select on a variables value. ie "select * from temptable where V3 = yyyy"
Datetime V1 V2 V3
T1 xxxx xxxx xxxx
T2 yyyy yyyy yyyy
any suggestions for an SQL statement.
thanks in advance.
I don't exactly understand your business requirements. Are V1, V2, and V3 the only possible values for the Variable column? If so, something like this might help to get you started:

SELECT
DateTime,
MIN(V1),
MIN(V2),
MIN(V3)
FROM
(
SELECT
DateTime,
CASE
WHEN Variable = 'V1' THEN Value ELSE NULL
END AS V1,
CASE
WHEN Variable = 'V2' THEN Value ELSE NULL
END AS V2,
CASE
WHEN Variable = 'V3' THEN Value ELSE NULL
END AS V3
FROM
yourTable
) AS subQuery
GROUP BY
DateTime

|||

Thanks Terri

The base table contains many variables. The data in this table is produced by a periodic time base event which inserts a row for each of the variables along with their current value. What I am trying to achieve is a record set where I can compare the values of selected variables in a single row based on the timestamp. ie
DateTime Var1 Var2 Var3
1/1/2005 10:00 Product1 10 20
1/1/2005 10:05 Product2 9 15
1/1/2005 10:10 Product2 12 30
1/1/2005 10:20 Product1 15 16
Once I have this record set I can then do selections based on the value of any variable ie
"select * from recorset where Var1 = 'Product1'"
I tried a statement similar to the one you have posted but my case statement sintax wasn't quite right.
I'm not in the office for a few days so may not get a chance try your code.
regards
Noel

Thursday, February 16, 2012

cross project reporting in project server 2002

forum is there a way to view and report mulpitle projects
the same time. i.e see all the resorces and all their
projects, see all costs assciated with all projects.
Basically I'm trying to view all projects together in one
report as opposed to viewing each project individually?
and if so how id this done? Thanks for all repliesIs this a sql server question?
If this is a database structure access you are asking
about thgen you will need to post the structure and what
you want as the result of the query.
>--Original Message--
>forum is there a way to view and report mulpitle
projects
>the same time. i.e see all the resorces and all their
>projects, see all costs assciated with all projects.
>Basically I'm trying to view all projects together in one
>report as opposed to viewing each project individually?
>and if so how id this done? Thanks for all replies
>.
>

Tuesday, February 14, 2012

Cross Application Migration

Migrate your MS SQL Server to Oracle ... i juss in time for further detail contact us
support@.wayne-burt.com
or Visit us at http://www.wayne-burt.comCommercials?|||Do you also pay for the $200,000 Oracle cpu licensing fee for us?