Tables with Two Key
Hello, I Have two tables the first includes the Revenue Details and the other one claims, the tables looks something similar to the below, Medical Record No Visit Number Visit Date Name Claim ID Phamracy Claim ID Invoice Amount XX VAN100 1 Jan 20 John CL1000 150 YY VAN200 1 Jan 20 Adam CLP2000 250 ZZ VAN300 5 Jan 20 Lawrance CL1500 CLP2500 500 And the other table Include the the Claims Details as follow: Claim ID Payment Date Payment Amount CL1000 2 Feb 20 150 CLP2000 5 Feb 20 200 CL1500 3 March 20 200 CLP2500 7 Feb 20 300 Im trying to create a relation between the two tables but since there is two coulmns in the first table as the primary key and only one in the second table i could not get, im looking to build a summary that looks like Visit Number ( Table 1 ) Claimed Amount (Table 1) Paid Amount (Table 2 ) VAN100 150 150 VAN200 250 200 VAN300 500 500
Configuration Loss After Entering Report Server Key?
Hi, I've been using trial version of report server for a long time and I have reports published to url at related server. There is a limited time for expire of the trial version and I found a licence key from system department. But I have a concern about loosing report server configuration and the published reports afte entering the key. Because I need to re-install the setup and enter the key. Please inform me whether I loose configuration & reports. Thank you