How to Truncate table to print on Crystal Report?

Databases
1

Can anybody Help me Step by Step on how i Can truncate Tbl_sample. is my tasked on doing our project if i can follow it.i hope to have some idea how it would work. Thanks in advance.

2

Wait what? You want to truncate a table (which means to remove all of its rows and reset its seed for auto-number/auto-increment columns) and then display a Crystal Report of a now empty table?

I think you’re going to have to express the connection between truncating a table and crystal reports better and to help you figure out how to truncate a table, we definitely need to know what database you are using.

4

875×611 113 KB
hi sir cpradio this is the tables i had all i wanna print on the Crystal Report are Events, EventDetails, and Client name…

5

[quote=“marion16, post:4, topic:217539, full:true”]all i wanna print on the Crystal Report are Events, EventDetails, and Client name…
[/quote]

just run this query –

SELECT tbl_events.Event , tbl_events.EventDetails , tbl_client.Fullname FROM tbl_events INNER JOIN tbl_client ON tbl_client.RegID = tbl_events.Client

6

hi sir @r937 , thats great am getting there thanks.

but on my Crystal Report what do i need to drag or put on the report?

thanks @r937

7

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.