VBForums - Reporting http://www.vbforums.com/ Post all your questions here that involve reporting. This can be on any reporting topic related to Visual Basic including, but not limited to Crystal Reports, Access and Data Report Designer. en Thu, 20 Jun 2013 06:35:45 GMT vBulletin 60 http://www.vbforums.com/images/misc/rss.png VBForums - Reporting http://www.vbforums.com/ <![CDATA[[RESOLVED] Separating Groups In A Crystal Report]]> http://www.vbforums.com/showthread.php?724577-RESOLVED-Separating-Groups-In-A-Crystal-Report&goto=newpost Wed, 12 Jun 2013 15:27:29 GMT
Name: 2013-06-12_10-17-18.png Views: 39 Size: 12.4 KB

I have a Crystal Report (Version 13) report that is populated by a programmatically assembled (non-database filled) datatable. The data comes through fine, however I am now trying to group the data so that there is a separator between each group. I have attached a picture of the current state of the report. DoorID is the field I want to group by. I have checked the datatable and made sure that there are multiple DoorIDs in the datatable. However, when the report loads, it simply fills in the Details section with everything, with no separator between the groups.

What do I need to do to create the separation I'm seeking?


Edit: The answer is that it doesn't matter how you format your report if you're stupidly calling the incorrect report at runtime.
Attached Images
 
]]> Reporting samuelk http://www.vbforums.com/showthread.php?724577-RESOLVED-Separating-Groups-In-A-Crystal-Report Unable to draw line in cross-tab column in CR2008 http://www.vbforums.com/showthread.php?723991-Unable-to-draw-line-in-cross-tab-column-in-CR2008&goto=newpost Thu, 06 Jun 2013 06:34:16 GMT At present , my CRYSTAL REPORT 2008 Output given by crosstab is as follows :

Name: before line in crosstab.JPG Views: 49 Size: 33.1 KB

And I want following output, to understand you better , I draw the line manually in paint.
But I want, in crosstab , it should draw the line in between %colum and $column.
Name: after line in crosstab.JPG Views: 39 Size: 34.2 KB

Please let me know any solution to draw the line in between varying column and rows.

Thanks & Regards ,
Swapnil M. Gholap
Application Engineer
s.gholap@frames-group.com
Attached Images
  
]]> Reporting SWAPNIL M GHOLAP http://www.vbforums.com/showthread.php?723991-Unable-to-draw-line-in-cross-tab-column-in-CR2008 Crystal reports help http://www.vbforums.com/showthread.php?723479-Crystal-reports-help&goto=newpost Sat, 01 Jun 2013 06:33:31 GMT I want to make a crystal report for JobOrder.. 1. the first part will be details of job order - which I can do 2. in details section it should show the services for this job order - this too i can do 3. it should show items used for each service --this is where I need ur help items for each service is dynamic and some service may not use any items . the no.of items, their qty , their unit all coming from database. below is db schema.. Attachment 100685 (http://www.vbforums.com/attachment.php?attachmentid=100685) service_id contains sitem_id the third part should be like : Service1 : item1=25cm, item2=40cm Service 2: Service 3: item6= 90mm If anyone needs any more clarification let me know. Please if anyone can give atleast is this possible in crystal reports as Im developing windows app in vb.net 2008, mssql 2005. It would be also helpful if some1 tells me from where to start then I will search on that..I dont know what this type of requirement is said thanks in advance I want to make a crystal report for JobOrder..
1. the first part will be details of job order - which I can do
2. in details section it should show the services for this job order - this too i can do
3. it should show items used for each service --this is where I need ur help

items for each service is dynamic and some service may not use any items . the no.of items, their qty , their unit all coming from database. below is db schema..
Name: Untitled.png Views: 123 Size: 14.9 KB



service_id contains sitem_id

the third part should be like :
Service1 : item1=25cm, item2=40cm
Service 2:
Service 3: item6= 90mm

If anyone needs any more clarification let me know.

Please if anyone can give atleast is this possible in crystal reports as Im developing windows app in vb.net 2008, mssql 2005.
It would be also helpful if some1 tells me from where to start then I will search on that..I dont know what this type of requirement is said

thanks in advance
Attached Images
 
]]> Reporting afreen http://www.vbforums.com/showthread.php?723479-Crystal-reports-help Crystal report count record http://www.vbforums.com/showthread.php?723271-Crystal-report-count-record&goto=newpost Thu, 30 May 2013 09:23:05 GMT How to do something like this?

Current year and series number

13-0001
13-0002
13-0003
13-0004
13-0005

my codes:

unbound field : "13-0001"

WHILEPRINTINGRECORDS;

LEFT({@UNBOUND},3) & TOTEXT(VAL(TRIM(RIGHT({@UNBOUND},4)))+1,"0000") ]]> Reporting morbid.ivan http://www.vbforums.com/showthread.php?723271-Crystal-report-count-record Need help about crystal report record number http://www.vbforums.com/showthread.php?723125-Need-help-about-crystal-report-record-number&goto=newpost Wed, 29 May 2013 03:58:29 GMT I NEED HELP ABOUT CRYSTAL REPORT RECORD NUMBER. EXAMPLE : 1. BRYAN 2. VINCE 3. ROME -. ROME - if name is duplicated, skip to next record 4. LETTY 5. MIA -. MIA - if name is duplicated, skip to next record How do i do something like this? I NEED HELP ABOUT CRYSTAL REPORT RECORD NUMBER.

EXAMPLE :

1. BRYAN
2. VINCE
3. ROME
-. ROME - if name is duplicated, skip to next record
4. LETTY
5. MIA
-. MIA - if name is duplicated, skip to next record

How do i do something like this? ]]> Reporting morbid.ivan http://www.vbforums.com/showthread.php?723125-Need-help-about-crystal-report-record-number Vb 2010/2012 Report with sub Report...pulling my hair out. http://www.vbforums.com/showthread.php?722989-Vb-2010-2012-Report-with-sub-Report-pulling-my-hair-out&goto=newpost Mon, 27 May 2013 18:18:27 GMT This really is driving me bonkers.

I created a simple project in vs 2012.

1 form w/reportviewer.

2 reports

I can use either report on my reportviewer and my data is displayed.

On report 1 I added a row to my table, merged all the cells then dropped in a subreport in that row.

In the subreport properties I have Name: Subreport1,
Use This report: Report2

Note that all the videos I have watched have Use This Report as a combobox, mine does not.

In the subreport parameters the Name combo does not have anything listed. I manually enter PropertyID and in the Value combo I picked [PropertyID]

On report 1 I have a parameter called PropertyID using the PropertyID field.

Is there anyone out there that wouldnt mind using TeamViewer to kinda look over my shoulder and see what in the heck I am doing wrong?

I really want/need to understand reports/subreports, just seems like after weeks of watching different videos and tutorials I am no closer to understanding.

Thanks in Advance ]]> Reporting Longbow22 http://www.vbforums.com/showthread.php?722989-Vb-2010-2012-Report-with-sub-Report-pulling-my-hair-out <![CDATA[[RESOLVED] need help about round off]]> http://www.vbforums.com/showthread.php?722689-RESOLVED-need-help-about-round-off&goto=newpost Fri, 24 May 2013 06:26:30 GMT i need help about round off. for example. 123.4567 and the result that im looking for is 123.45. i need it to be round off in 4rt decimal place i need help about round off.

for example. 123.4567 and the result that im looking for is 123.45.

i need it to be round off in 4rt decimal place ]]> Reporting morbid.ivan http://www.vbforums.com/showthread.php?722689-RESOLVED-need-help-about-round-off Request for sample http://www.vbforums.com/showthread.php?722355-Request-for-sample&goto=newpost Tue, 21 May 2013 07:38:28 GMT I am new to programming. And I learn through reading and downloading samples and studying them. I would like to ask from you guys for a working vb6 sample with crystal reports 8 or 10 report that is simple and another with subreport(s). Please. Thank you. I am new to programming. And I learn through reading and downloading samples and studying them.

I would like to ask from you guys for a working vb6 sample with crystal reports 8 or 10 report that is simple and another with subreport(s).

Please. Thank you. ]]> Reporting codesearcher http://www.vbforums.com/showthread.php?722355-Request-for-sample crystal report http://www.vbforums.com/showthread.php?722351-crystal-report&goto=newpost Tue, 21 May 2013 07:27:34 GMT how to limit details per page? for example, i want 20 records in page 1 and in page 2 30 records will display? i need your help guys. thanks in advance. how to limit details per page?

for example, i want 20 records in page 1 and in page 2 30 records will display?

i need your help guys.

thanks in advance. ]]> Reporting morbid.ivan http://www.vbforums.com/showthread.php?722351-crystal-report